(Ignacio A. Salom Rangel) Backup is the most essential for the protection of data on which whole business is dependent. In a way to protect the data, user should maintain periodic backup of data, which is to be monitored and verified.

(Ed Elliott) I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac’s. In particular I am talking about how to control the deployment, what tool is used to deploy the dacpac, what connection details are passed in, which of the hundreds of

(Hannes du Preez) You can use a normal SELECT query joined with a bunch of AND statements to determine if a certain value exists, but this can become cumbersome and tedious.

(Pinal Dave) I have written a number of posts in the past working on shared databases and the concepts around these can be read at Sharding or No Sharding of Database – Working on my Weekend Project for the starters point of view.

(Tony Davis) A developer friend of mine recently, upon the briefest mention of SQL Server, descended unexpectedly into a rant about the pain of getting rid of the blasted thing. I was somewhat taken aback.

(Dimitri Furman) A customer using Azure SQL Database recently brought an interesting problem to our attention. Unexpectedly, their production workload started failing with the following error message: “The database ‘ProdDb’ has reached its size quota. Partition or delete data, drop indexes, or consu

(Svetlana Golovko) One of the SQL Server Master Data Services (MDS) models was incorrectly modified and we need to restore the MDS database to the state before the modification took place.

(Nakul Vachhrajani) I often receive questions related to debugging code using SSMS. Based on these questions, I have written a lot of blog posts in the past, however I was recently asked the question:

(Hannes du Preez) There will be times that you encounter a situation where you have to update a row, if it exists, or create a new row if the certain data is not already present.

(Pinal Dave) In one of my recent consultation visits to a customer, there was deep performance related problems. They were unclear to what was happening and what was the actual problem. But these are some of the challenges that I love to take head-on too.