Database Corruption: Incorrect PFS Free Space 2017-06-08 Posted in: Database Administration SQL Server A database is restored, and corruption is discovered. Here's a short story of what happened next. [...Read More]
SQL Server Extended Event Handling via GUI 2017-05-29 Posted in: Database Administration Development SQL Server SQL Server 2016 SQL Server Event Handling A look at SQL Server Extended Events and how to handle them using the QueryableXEventData class in a C# GUI app. [...Read More]
Flaming Hair And The Apocalypse 2017-05-24 Posted in: Career Database Administration Development Did you know I saved the world? It's true, it's true. [...Read More]
Installing Multiple Instances of SSRS 2017-05-08 Posted in: Database Administration SQL Server 2017 SSRS It really isn't that hard-when you aren't burdened with false assumptions. [...Read More]
The PowerShell Disconnect 2017-04-16 Posted in: Career Database Administration Development PowerShell PowerShell continues to feel awkward and unintuitive. Is prior development experience a hindrance to its adoption? [...Read More]
T-SQL Tuesday #89: The Times They Are A-Changing 2017-04-11 Posted in: Career Certification Database Administration Microsoft SQL Server For T-SQL Tuesday #89, Koen Verbeeck wants to know how we feel about technology and change. [...Read More]
Certified And Inexperienced: The Kiss Of Death 2017-04-05 Posted in: Career Database Administration Why does real world experience win out over inexperience and education? And should it? [...Read More]
The Mount Rushmore of Lazy SQL Security 2017-03-21 Posted in: Database Administration Security SQL Server Four SQL Server authorization blunders that people keep making over...and over...and over... [...Read More]
UnPivot The Output Of RESTORE HEADERONLY 2017-02-22 Posted in: Database Administration Development SQL Server T-SQL "Flipping" the output of RESTORE HEADERONLY can't be that hard. Can it? [...Read More]
Cannot Generate SSPI Context 2017-02-17 Posted in: Database Administration SQL Server Windows Maybe my pain can be your gain. Here's how I resolved the "Cannot Generate SSPI Context" connection error. [...Read More]