The company I work for, Perion, chose Amazon Web Services as the main cloud provider for managing and operating our applications. These days I am learning how to manage databases and data related flows in the AWS cloud. Which is the…
Several days ago I have spent a few hours of my life figuring out how to do dynamic pivot in Amazon Redshift. To tell you the truth, I have expected much more from this DBMS SQL language. Redshift is based on Postgre SQL 8.0.2 ( which was…
I wonder if I had started my career as a PostgreSQL DBA or MongoDB DBA, would it be easier for me to acceptthe rapid growth and the variety of data storage solutions and our new reality of the Polyglot persistence? Polyglot is…
The idea to organize SQL Saturday is so exiting and scary at the same time. For me - this is my first SQL Saturday. For SQL Saturday - this is a first time in Israel. All my religious and not so religious friends are energetically making…
Cloud technologies burst into our lives without asking our permission. At the beginning many of us thought the only thing that it brings would be the thunder and the rain. Time shows that, instead, it might even bring some color…
Last week I have worked on the new email report using Google Charts and liked it so much that decided to share it here with anyone who finds it useful. I have a Schema Changes Audit table which is being maintained by the DDL…
In the database world, disk based data stores are slowly being replaced by memory-based data stores. Memory prices are becoming more affordable and operational databases can usually fit totally into memory. According to the Gartner (the…
The key player in the transactional replication topology is the Distributor. Misconfiguration of the Distributor can lead to increased load on the production server, can interfere with the regular application activities and even cause…
On the nice sunny day getting this error message can be really frustrating. In fact, it is frustrating on any day. Especially if you are doing something really simple. Most of you at this moment yell at your monitor “DDL…
- I have a challenging SQL problem for you, – yelled one of my coworkers one morning entering my office and dropping on his way a few pictures, SQL server system views map and a visitors chair. – Much more interesting than all your alerts…
