As an admin, you often get requests from developers asking for elevated permissions on servers and systems. Inside of SQL Server, this is called ‘sysadmin‘ access. As you can imagine, it is not a good idea to give this level of access to just anyone. I thought I would write a post to help you … Read more
Every DBA wants to become an expert in query performance troubleshooting. Not every DBA is willing to put in the time and effort it takes to become an expert.
Many DBAs liken their roles to being a mechanic, and with everything under the hood of SQL Server these days I think an F1 mechanic is an apt comparison.
Here is a list of the continuing problems that exist in every IT shop around the world. And they aren’t all new, either.
By pausing the SQL Server service before restarting the instance we allow end users to continue their work uninterrupted and we also stop any new connections to the instance.
Here’s an example of something I came across for Azure SQL Database V12 that I don’t see documented anywhere (yet): You can change the compatibility level of an Azure SQL Database.
