Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking...
2018-11-27
10 reads
Jason Brimhall
Ghosts in your Database
Yes Virginia, there are ghosts in your database. More specifically, there are ghosts in your SQL Server database. They are not there to haunt you. They are not there...
2018-11-26
11 reads
Monitor Database Offline Events
The other day, I shared an article showing how to audit database offline events via the default trace. Today, I...
2018-11-26 (first published: 2018-11-15)
1,920 reads
Azure Data Studio and XEvents
Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have...
2018-11-21
859 reads
Azure Data Studio and XEvents
Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have finally gotten around to adding Extended Events (XE) to...
2018-11-21
4 reads
Cannot Use the Special Principal – Back to Basics
I recently had a client call me out of the blue because he happened to be getting an error while...
2018-11-21 (first published: 2018-11-07)
2,575 reads
T-SQL Tuesday #108: New Horizons Beyond SQL Server
There comes a point in one’s career when a change is requisite. Big or small there always seems to be...
2018-11-21 (first published: 2018-11-13)
2,128 reads
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time...
2018-11-20
249 reads
How Long is That Event Taking
Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time is a bit troublesome. Is it milliseconds, seconds or...
2018-11-20
2 reads
PowerShell ISE Crashes
Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh version, the more efficiently you will be able to...
2018-11-19
13 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers