Tag Archives: sql server

Quick Schema Auditing

I was working on a demo recently and needed to show that a little monitoring can help you catch schema changes. At first I looked at SQL Audit and DDL Triggers, but then I ran across a short custom metric … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Why Would You Move?

I was reading a thread on Quora about why SQL Server is chosen by companies, and another on StackOverflow about why Oracle is a good choice. As much as I sometimes joke about the Oracle RDBMS, I think it’s a solid platform, … Continue reading

Posted in Editorial | Tagged | Comments Off on Why Would You Move?

Document, then Install

I saw someone post a note that they had installed a new SQL Server and wanted to document the install. Did anyone have a good script or process for doing this? I’ve done this myself, but lately it seems to … Continue reading

Posted in Editorial | Tagged , | Comments Off on Document, then Install

The Decline of SQL Server

For many years in my career, SQL Server was the runner up. Both Oracle and DB2 were in much wider use and more popular among all sizes of companies. Serious applications used one of those platforms, according to many technologists, … Continue reading

Posted in Editorial | Tagged , | 2 Comments