SQL Scripts: List Databases A Login Can Access
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
Nuggets Of SQL Server Knowledge
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
In a previous article, I went over how SQL Server will recommend an index that it believes will help a query run faster, and I showed how to find missing …
One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it …
Filtered indexes are one of those neat little SQL Server features that a lot of people don’t seem to know about, or if they do they don’t use them very …
One thing that a lot of DBAs, especially Accidental DBAs such as myself, don’t seem to realize is that just because a database is sitting on a specific version of …
I recently had a case where I needed to download a database backup to my laptop. It usually takes about 12 hours for this particular backup to copy down, so …
In a previous Index Basics post we went over the importance of having a Clustered Index on your tables, and we learned that SQL Server will automatically create a Clustered …
Sometimes it becomes necessary to change the owner of a database. When a database is first created, SQL Server likes to set the owner of that database to the login …
Security and permissions are a big part of a DBA’s job, and being able to find out things such as who has elevated login permissions, or when the last time …
As a DBA, one of the things I routinely need to check is how much space is available in my database data and log files. In this post of my ongoing SQL …
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.