BlitzWaits custom module available for Inspector V2
We have been working on a new custom module for Inspector V2, in fact this module is part of a new project where we will be producing two other...
2020-01-22
23 reads
Introducing The Undercover Catalogue
In this video, David give a quick introduction into the Undercover Catalogue.
2020-01-20
40 reads
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git Hub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/CatagoryControlledAgentJobs.sql Agent jobs, they can be a right pain to manage when you’re...
2020-01-16
41 reads
Undercover Catalogue 0.4.0 Released
We’re pleased to announce the release of the Undercover Catalogue 0.4.0, (please see HERE for full details of the Catalogue). The new version brings with it a number of...
2020-01-06
28 reads
CPU custom module available for Inspector V2
If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may...
2020-01-02
31 reads
Happy New Year – Our Top Posts of 2019
With the New Year fast approaching and maybe already having arrived depending on where you are, we thought we’d do a quick recap of our top 5 posts from...
2019-12-31
31 reads
2019-12-24
20 reads
SQL Undercover TV Christmas Special – David's Top 5 Azure Data Studio Features
In our Christmas Special, David picks his top 5 features of Azure Data Studio.
2019-12-17
33 reads
Inspector V2.00 now available
The SQL Installation file can be found here.The new Powershell installer can be found here.If you are running the powershell collection you will need to grab the latest revision.The...
2019-12-03
46 reads
Troubleshooting Resource Semaphore and Memory Grants
Memory grants, now here’s a fun thing that can pretty much take your SQL Server to its knees. The Symptoms The first thing that you’re going to notice is...
2019-12-03
301 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers