(Ben Snaidero) Database and data security is becoming an ever increasingly more important aspect of what a SQL Server DBA is responsible for. Details of who did or tried to access your database is no doubt something every DBA has had an auditor ask them to provide as a part of a security audit.

(Pinal Dave) There are many times when internet has answers to many questions. To get the right answer, you need to search for the right keyword and it comes from practice. Let us learn how we can fix the error Unable to Change “Shared Feature Directory” Under Feature Selection.

(Melissa Coates) I must admit right up front: I’m more than a little obsessed with naming conventions. Prefixes…suffixes…I really enjoy coming up with the optimal convention to use so that a name is at least somewhat self-documenting without being horribly long.

(Vitor Montalvao) On a SQL Server 2016 install with the version higher than the RTM (13.0.1601.5), you get a timeout error when starting SQL Server Launchpad service

(Kenneth Fisher) I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at the same time, but with different parameters each time. One way to do it would be to open multiple query windows, and run them all as close to at the same time as poss

(blobeater) They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made. Naturally I became very interested. Within your database (when in the portal) under operations you may notice something similar to the below:

(Nicholas Lopez) In Azure, there is a feature called Azure Resource Management Locks which can help prevent accidental deletion resources such as a SQL Server by adding a level of protection. While it may not happen all the time, sometimes we make mistakes and delete the wrong server.

(Pinal Dave) It is always fun to receive a follow up comments when I write a blog post. Yesterday I wrote about SQL SERVER – Simple Query to List Size of the Table with Row Counts and here is the follow up question which I received about adding a NULL column.

(Arshad Ali) Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes.

(Kenneth Fisher) In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit more attention.