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 […]
You can now create nonclustered indexes on the Clustered Columnstore index
This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that […]
SQL 2016- Live Query Stats
I am a bit confused about this feature so I thought I would post about it to get feedback on its usage in SQL 2016. With SQL 2016 […]
SQL 2016- Activity monitor – Active Expensive Queries
Hurray L1 DBAs you now have an easier way to query active expensive queries. A new tab is added in activity monitor to show DBAs currently active queries. […]