(Pinal Dave) While writing my earlier blog, I broke a few settings and started getting new errors. Earlier, when I used to run below command, it used to work fine. However, just a day ago, it has given me error related to the BackupDirectory Registry Key.

(Sunil Agarwal) Columnstore index is part of In-Memory technologies released in SQL Server 2014 and SQL Server 2016.

(Greg Larsen) During the development cycle, indexes will be placed on SQL Server tables to speed up performance when searching for records. Lots of thought probably has gone into creating just the right mix of indexes based on how developers think customers will use the system.

(Kenneth Fisher) My friend Andy Mallon (b/t) is hosting T-SQL Tuesday this month. In case you aren’t aware T-SQL Tuesday is a blog party started by Adam Machanic (b/t) almost 7 years ago. Each month someone selects a topic and hosts the “party”. Then whoever is interested posts a blog on that topic.

(Tony Davis) It is far easier to work out what is wrong with a slow-running SQL query than one that shows erratic performance. DBAs will groan when a process occasionally performs terribly without apparent reason. There is always a good chance that this is a symptom of the painful problem of paramet

(Niladri Biswas) The objective is to demonstrate the capability of generating sequential number using Row_Number() function inside a group and to perform Update operation.

(Pinal Dave) I have written a number of blogs around working with SPARSE Columns in the past and a primer to what SPARSE Columns can be got from the list mentioned:

(Rahul Sahasrabuddhe) This article talks about serverless architecture – code that runs without servers. We will also see how Serverless architecture is picking up pace now, and how various cloud platforms like Azure are readying up for severless offerings.

(Nakul Vachhrajani) SQL Server Integration Services (SSIS) are typically called upon when integrating systems exchange data from one source to a given destination. The reason I use the term “source” and “destination” instead of a “database” because either of the two can be something other than a dat

(William Brewer) For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude about the value to any organisation of having databa