If you’re running availability groups it may seem like a great idea to offload your read only reporting workloads to a secondary. There are a couple of ways that...
2019-10-28 (first published: 2019-10-16)
408 reads
The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is.
2019-10-18 (first published: 2019-10-14)
193 reads
Back in February, Sean McCown joined us on the Undercover podcast and presented a brilliant tutorial on the SMO. We thought that it was so good that we’ve decided...
2019-10-01
41 reads
This month’s T-SQL Tuesday invitation comes from Kevin Chant and he’s asking us about a fantasy feature that we’d love to see in SQL Server. I had a little...
2019-09-09
17 reads
Releases seem to be coming out thick and fast at the moment, here’s the latest v1.6 revision to sp_restorescript For those of you backing up to Azure BLOB Storage,...
2019-08-29
44 reads
This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...
2019-08-15
78 reads
We’ve released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our...
2019-08-12
14 reads
Intent locks, one of those things in SQL Server that seem to be very often misunderstood. They’re something that I’ve found myself explaining time and time again, I’ve even...
2019-07-25
650 reads
sp_RestoreScript 1.4 is now out and ready for download from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql New Features Compatible with case sensitive collations Now accepts wild cards in the @DatabaseName string, (‘Database1,Database2,SQL%’)...
2019-07-15
212 reads
I recently hit this rather interesting issue when migrating a bunch of SQL Servers onto a nice, shiny new SAN. The plan was simple enough, take the secondary servers...
2019-07-22 (first published: 2019-07-08)
2,674 reads
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi I am working on a rolling average calculation that is not working quite...
Comments posted to this topic are about the item Subscribing to a Great New...
Hi, is there a way when using excel as a flat file source in...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers