Tag Archives: sql server

30 Years of SQL Server on Windows

I’ve spent over 30 years working with SQL Server. I saw a post recently from Bob Ward who is celebrating 30 years at Microsoft, noting this is also the 30th anniversary of SQL Server on Windows. It’s been an honor … Continue reading

Posted in Editorial | Tagged , , | Comments Off on 30 Years of SQL Server on Windows

If You Build It, Will They Use Linux?

There’s a great scene in Field of Dreams where James Earl Jones says that people will come. It’s in response to the voices Kevin Costner hears early in the movie. This is the climax of the movie, where Costner makes … Continue reading

Posted in Editorial | Tagged , | 4 Comments

Has SQL Server Performance Improved?

I saw a very interesting blog post this week from Brent Ozar that asked if SQL Server 2019 More CPU-Intensive Than SQL Server 2016? You can read the post, but a client was having CPU issues and thought everything between … Continue reading

Posted in Editorial | Tagged , | 3 Comments

Capturing Data Changes

While working with a customer recently, I saw some code from them that used the OUTPUT and INTO clauses of an UPDATE statement to capture the changes made into another table. In this case, as users updated code strings in … Continue reading

Posted in Editorial | Tagged , | Comments Off on Capturing Data Changes