As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying to figure things out for yourself. It may even be very common to feel the icy pain of the development cold shoulder (intentional or not) as you go about doing your duties to protect the […]
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server. That disruption comes in the form of the SHUTDOWN TSQL command. You can read what Chris wrote from his article here.
Granted, you do need to have elevated permissions such as sysadmin, serveradmin or securityadmin. […]
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want to dive into a something a little more fun: the interview trick question.
Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick […]
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what. In addition, they may need to know by what means people have access within your databases. Enter the permissions audit.
When that need arises, it is frequently adequate to just perform […]
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events (aka XEvents). There appears to be an inherent fear with how to use extended events. In addition to that fear, is the fear that extended events does not do what Profiler can do so easily.
Today, I […]
I have been doing a lot of posts of late about extended events but have failed to share some of the essential building blocks, such as the use of the file target. I am not looking to do a series of definitions, but just share a couple of quick tips and examples here and there that […]
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor for a specific thing to happen. But sometimes you don’t know if there is an event for that “thing”, or maybe you don’t know if there is […]
Yes Virginia, there are ghosts in your database. More specifically, there are SQL Server database ghost records. They are not there to haunt you. They are not there just for this holiday season (speaking of Halloween Month).
How can there be ghosts in the database?
Why would there be ghosts in the database?
Do they happen because somebody […]
There is plenty of legislation and regulation in place these days that strongly suggest encrypting a database. In SQL Server, we have the ability to comply with these regulations in a couple of different ways. We can choose to encrypt at the column level or we can choose to encrypt the entire database using TDE […]
Frequently we hear the analogy that <insert item here> are like opinions, everybody has one and not all of them are good (some may stink).
Well, this may just be another one of those <items>. Whether it stinks or not may depend on your mileage. It’s a missing indexes script.
I had shared a similar script back […]