The merry-go-round scan or advanced scan is something that I’ve seen mentioned a few times recently and it’s a lovely little feature of Enterprise Edition that not all that...
2020-09-23 (first published: 2020-09-16)
225 reads
This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that...
2020-08-20
301 reads
SQL Server has given us the option to backup our databases directly to Azure BLOB storage for a while now but it’s not something that I’ve had all that...
2020-07-08 (first published: 2020-06-22)
505 reads
This month’s T-SQL Tuesday invitation is from Ken Fisher and he’s asking about non-SQL tips and tricks. This had me thinking for a bit and then something popped into...
2020-06-23 (first published: 2020-06-09)
342 reads
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on...
2020-06-03
20 reads
Undercover Catalogue Update 0.4.3 An update to the tables module, Row count and size infotmation added Fix – LocalInterrogation There was an issue with the LocalInterrogation stored proc not...
2020-06-01
19 reads
As always, the script from this post can also be found on our GitHub repo, HERE You’ve got a SQL Server with a few hundred databases on it (to...
2020-04-23 (first published: 2020-04-15)
726 reads
It looks like we had a bug the in the SQL script in Move All Your SQL Database and Log Files in Bulk. No worries though, it’s all been fixed...
2020-04-22
16 reads
This month’s T-SQL Tuesday invitation comes from Tracy Boggiano and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...
2020-03-17 (first published: 2020-03-10)
331 reads
Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags – Capture trace...
2020-03-02
17 reads
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
By Steve Jones
A customer asked if they needed to restore a database from backup to compare...
By Brian Kelley
If we aren't having the same conversation, we aren't going to be heard. That's...
I'm new to the development side of the house and stuck on a CTE...
Dear All, I am currently working on a Proof of Concept (POC) where I...
Hello, I would like to build a table capturing data starting from 1st day...
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers