2023 Year End Review
Jump into the wayback machine and see what Dave was up to in 2023.
[...Read More]Why Do We Stay In Scornful Big Tech Relationships?
Once again, I find myself contemplating a breakup with a Big Tech company. There's a lot to consider, but the overwhelming question I ask myself is "Am I willing to actually go through with it?" It can take a lot of time and heartache to get to "yes". Can you get there too?
[...Read More]Quitting Google
I've booted another big tech company from my personal life. They're no longer worthy of me.
[...Read More]Listing Table Constraints with sp_helpconstraint
- Posted in:
- SQL Server
- TSQL
For SQL Server metadata, the information schema views may not be suitable for all of your needs. Here is an example involving table constraints.
[...Read More]WMI error 0x80041032
- Posted in:
- SQL Server
- WMI
- SQL Agent
My SQL Server Agent WMI Alert stopped working. But why?
[...Read More]The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered
- Posted in:
- SQL Server
- SSIS
- Visual Studio
Differences between your development workstation and a SQL Server host can make SSIS packages challenging. Here's how I overcame one of those obstacles.
[...Read More]SQL Saturday Jacksonville 2023
- Posted in:
- SQLSaturday
- R
- SQLServer
Thanks to everyone that made it to SQL Saturday Jacksonville 2023. If you attended my "Getting Started with R" session,
[...Read More]
Page Compression vs Compress() vs Columnstore
Dave chooses a winner from an admittedly imperfect test.
[...Read More]The exorbitant toll of divorcing Google
Rooting an Android device can help you take control of your privacy. But it's far too complicated. We all deserve better.
[...Read More]DDL Trigger Event Groups
- Posted in:
- SQL Server
- Database Administration
A "compact" query showing DDL trigger event group hierarchies.
[...Read More]