In this episode of the podcast, Adrian looks at the scripting options available in SSMS. https://www.youtube.com/watch?v=0LAVuOaWj2g
Undercover TV Podcast – Scripting Options in SSMS
Availability Groups and Redo Latency, Data Committed on a Primary isn’t Visible on a Synchronous Secondary
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 you could do that, you could use read only routing or simply just point those reports directly at a read only secondary (read only routing is... Continue Reading →
Undercover TV Podcast – Intent Locks
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. https://www.youtube.com/watch?v=44vNrHJR984
We Thought That Sean McCown’s SMO Tutorial Was So Good, It Needed To Be A Video In It’s Own Right
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 to make it into a video in it's own right. https://www.youtube.com/watch?v=v3rk8wTmkVY The podcasts are going to be revived very soon with a whole new format and... Continue Reading →
sp_LockDetails – Get Details of all Locks Taken Out Against a Database.
Be sure to get the latest version of this script from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox Have you ever wanted a quick and easy way to see who was holding (and waiting on) locks on a particular database? Perhaps you've got some blocking issues going on and you want to see exactly which rows the row level... Continue Reading →
Getting Our Query Back After SSMS Crashed or We Closed the Tab Without Saving It
Here's a quick one for you, have you ever spent all day working on some query or another only for SSMS to crash or for you to accidentally close the tab that you're working on without saving the query? I'm sure you have, we all have. What happens next is usually a muttering of some... Continue Reading →
SQL Tuesday #118 – Your Fantasy SQL Feature
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 think about this and there's one thing that came straight to my mind, it is something that's possible with third party tools but isn't something supported... Continue Reading →
sp_RestoreScript 1.6 Release – @Credential Added For Backups In Azure BLOB Storage
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, we've now added a @Credential parameter. You can grab the latest version from our GitHub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql or for full documentation, visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/
Undercover Catalogue 0.3.0-Auditing and Change Tracking Comes to the Catalogue
We're pleased to announce the release of the Undercover Catalogue 0.3.0. You can grab it from our GitHub page... https://github.com/SQLUndercover/UndercoverToolbox/tree/master/SQLUndercoverCatalogue Installing and Upgrading Full installation and upgrade instructions can be found on the main Catalogue page, https://sqlundercover.com/undercover-catalogue-0-2/ v0.3.0 Brings Auditing to the Catalogue The biggest change that we've introduced to the Catalogue is auditing. All... Continue Reading →
