dbachecks – A different approach for an in-progress and incremental validation
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
504 reads
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
504 reads
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called...
2018-02-22
862 reads
In two weeks from now, on 23rd of February, I will be speaking at SQLBits 2018! It’s my first time on the largest SQL Server conference in Europe for...
2018-02-09
9 reads
One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...
2018-01-23
740 reads
Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know...
2017-12-15 (first published: 2017-12-05)
2,485 reads
Last night, I received Adam Machanic’s (b | t) newsletter “Announcing sp_whoisactive v11.20: Live Query Plans”.
For those who don’t know about it, sp_WhoIsActive is a stored procedure that provides...
2017-12-05
12 reads
Today I will write just a short blog post to do a quick reminder!
I still hear a lot of people suggesting CTEs because they think it works like a...
2017-11-30
8 reads
Today I will write just a short blog post to do a quick reminder! I still hear a lot of...
2017-11-30
707 reads
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
4 reads
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
6 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
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...
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