(Jason Brimhall) Given the critical level of importance related to permissions, one may think it is a concept that is well understood by all who are given the charge of protecting the data.

(Jason Thomas) It has been quite a while since I posted something and was already thinking of dusting up my tools. That was when I was going through the Power BI Community forums, and found an interesting question

(Arun Sirpal) Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while.

(Greg Larsen) Have you ever wanted to know who made a schema change to your database? If so, that information is tracked in the default trace. The default trace is just a server-side profiler trace that gets started when SQL Server starts up, provided the default trace is enabled.

(Thomas LaRock) You shouldn’t be running unpatched versions of SQL 2000. That’s what you need to know.

(Arun Sirpal) The great thing about new versions of SQL Server is the fact that they are packed full of new features but there some that don’t really get talked about much.

(Jack Vamvas) Question: When executing a stored procedure I received an error message

(Kenneth Fisher) Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who isn’t. For example, I’m doing a big delete on a table in a 24×7 environment, I can’t afford downtime to do it so I’m doing my delete in small chunks to reduce transact

(Thomas LaRock) It is clear to me that no one, except for database administrators, has any idea what a DBA does all day long:

(Alex Grinberg) Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 201