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
25 reads
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
25 reads
In this video, David give a quick introduction into the Undercover Catalogue.
2020-01-20
41 reads
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
42 reads
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
30 reads
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
32 reads
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
21 reads
In our Christmas Special, David picks his top 5 features of Azure Data Studio.
2019-12-17
33 reads
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
302 reads
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
48 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Grand Comal Residence, Jl. Raya Ahmad Yani No.20 Blok EA A19, Dusun II,...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers