I am not sure how many other users have visited this blog but it’s been one of my go to places when I wanted to read up on […]
Renaming all columns in a table quickly
Recently imported a table where the column names where quoted using double quotes which then became the table names , So a column name would be “Airline” instead […]
The hazards of data types when deleting data
Recently in one of the forums a question was posted where the developer had run a delete statement similar to the one below This deleted all the data […]
Does Partitioning Improve Performance?
Partitioning is a great feature for improving the way we manage our data. However we can also improve performance of select statements from the table as well. This […]
Measuring Uptime in SQL Server – Why nines don’t work
A key part of every DBAs jobs is maintaining uptime. A DBAs capability is measured by the amount of Uptime he is able to ensure on servers he […]
LnT Infotech SQL Server Training
Just finished a virtual training for LnT InfoTech in EPIP industrial Area. Looking forward to the next training with Well Fargo
Video on Performance tuning memory allocation and spill issues
I was inspired by a recent article I read on parameter sniffing to add my own contribution to the topic, I explain how tempdb spools occur due to […]
Suspect MSDB and no Backups
Yesterday I got a call from a client about MSDB being suspect after a drive failure. Unfortunately the client didn’t have any backups. Now the correct and best […]
administration / MSSQL / TSQL
Lock, Latches, Waits and Deadlocks explained weirdly (like never before)!!!
When conducting MS SQL Server Trainings I often resort to weird examples to explain how certain things work. Over the years I have some favorites that I use […]
Security: Capturing additional login information Trace vs Audit
Recently on a popular SQL Server forum as well as commonly during my trainings people ask about how to get additional security information about logins. Most often the […]