Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY). This month we have an open invitation from Mike Donnelly (blog | twitter), asking us to talk about something new […]
Tag: SQL Internals
Audit who Dropped the Database
In the first article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who dropped the database and when they […]
Audit Schema Change Report
In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion. You can read about that here. I recommend reading that article first because it helps […]
Effects of Max Mem on Plan Cache
Some effects on plan cache and max memory settings
Ghosts – an eXtrasensory Experience
Really, at this point what is there that hasn’t been done about the ghosts? Well, if you are well tuned to these apparitions, you may have received the urge to explore them with Extended Events – sometimes called XE for short.
Database Ghosts
Recently you may have seen my first article on this topic over at SQL Solutions Group. If not, here is the link so you can read that article first before proceeding here. This article is […]
Effects of sp_rename on Stored Procedures
There comes a time when mistakes are made. Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure. When a mistake such as that happens, we are […]
Scaring a Database Near you
Something I have a hard time by-passing is a good R2 unit. I have R2 units in so many different forms, including a standing R2 cake one year for my birthday. So when I cam […]
Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to you asking “What do we do?” […]
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along – the transaction log on the primary […]