SQL SERVER – How to Shrink tempDB Database?
Just yesterday, I received an email from a client who had hired me last year for Comprehensive Database Performance Health Check. While I worked with them last year, they were struggling with the performance of the server. We scientifically and strateg …
How Often Do You Give Your Server a Physical?
A good doctor knows their patients – literally – inside out. They know the history of health and illness, what the patient has continuing issues with (maybe allergies, sinuses, or in more serious cases, diabetes or cancer), and how we …
SQL Server Logon Trigger Examples
The post SQL Server Logon Trigger Examples appeared first on SQLServerCentral.
Making the switch to SQL Monitor
The post Making the switch to SQL Monitor appeared first on SQLServerCentral.
DBA Training Plan 11: The Basics of Executing a Query
Up til now in the DBA Training Plan, we’ve been taking inventory of our servers, making sure the data’s well-protected, and understanding the basics of how the data’s stored in indexes inside those data files. Now, let’s start l …
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
When I work with Comprehensive Database Performance Health Check, I get all sort of questions and I love answering them. Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored …
Find SQL Server Integer Columns to Make Skinnier
The post Find SQL Server Integer Columns to Make Skinnier appeared first on SQLServerCentral.
How to stop standardization being a stumbling block in database DevOps
The post How to stop standardization being a stumbling block in database DevOps appeared first on SQLServerCentral.
DBA Training Plan 10: Managing Index Fragmentation
In the last episode, we looked at your index designs with the output of sp_BlitzIndex. You might have gotten a little overwhelmed what with all the different warnings (and all the learning resources!) You might have thought, “Is there an easier w …
SQL SERVER – Power Options, Power Plans and Database Performance
Everyone knows that I love my job and particularly solving SQL Server Performance Problems. Recently I ended up a very interesting scenario when working with my client on Comprehensive Database Performance Health Check. After a careful investigation in …
How to convince your boss you need SQL Server monitoring
The post How to convince your boss you need SQL Server monitoring appeared first on SQLServerCentral.
Contribute to the SQLCop Project
The SQL Cop project is an open source set of tests that help promote code quality by looking for common poor T-SQL coding practices. These tests are based on the tsqlt framework and run within its structure. You can add the SQL Cop tests to your databa …
Executing Dynamic SQL Using sp_executesql
The post Executing Dynamic SQL Using sp_executesql appeared first on SQLServerCentral.
Redgate Takes over the SQLCop Project
I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github. …
DBA Training Plan 9: My 3 Index Guidelines
In our last episode, we used sp_BlitzIndex @Mode = 2 to get to know the contents of our database, sorted our indexes from biggest to smallest, and started asking questions about leftover backup tables that we probably didn’t need to keep around a …