This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
SQL SERVER – Find Owner of Database – Change Owner of Database
As there was no owner, it was not possible to open that database in the SSMS. We had to find Owner of the Database and change it later on.Â
SQL SERVER – List Databases Where User Has DB Access
This is a very interesting function and it helps us to list databases where User Has DB Access. Well, it is pretty straightforward to know with the help of function HAS_DBACCES.
SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist
One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal.Â
SQL SERVER – Adjust Memory with Dedicated Administrator Connection (DAC)
the services did not start at all. Let us learn today how to Adjust Memory with a Dedicated Administrator Connection (DAC).
SQL SERVER – Renaming distributor_admin Bad Idea
A client of Health Check, recently send me an email after reading best practices. Why Renaming distributor_admin Bad Idea.
SQL SERVER – Deny Drop Permission for a Table
Lots of people asked me to write a follow-up blog post where we can deny drop permission for a table from the SQL Server Security Standpoint.