2019-10-11
861 reads
2019-10-11
861 reads
We tend to keep data around for a long time. Today Steve Jones is looking to see how long you've kept your databases around.
2019-10-11 (first published: 2015-10-02)
316 reads
Today Steve asks you to be a part of the change you'd like to see in our professional organization.
2019-10-10
149 reads
2019-10-10
754 reads
Learn how the INCLUDE phrase of an index can change the performance of a query.
2019-10-10
27,947 reads
2019-10-09
503 reads
Managing a complex workload is a skill many of us need to acquire and maintain. Today Steve has a few ideas on how to do that.
2019-10-09
211 reads
2019-10-08
726 reads
After missing the last T-SQL Tuesday, I’m back for the latest invitation from Alex Yates. In this one, Alex asks us to write about something in IT where you...
2019-10-08
19 reads
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
187 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers