UNDERCOVER TOOLBOX: Get Details of All Open Transactions
It was 3am in the morning and I was asleep and enjoying a delightful dream (I knew it was a...
2018-02-07
451 reads
SQL Undercover
Undercover TV – We’ve got a YouTube channel!
We’ve now got ourselves a shiny new YouTube channel at UndercoverTV.
We’ll be using this to host our monthly podcasts as well...
2018-02-01
388 reads
sp_RestoreScript 1.2 is now available
sp_RestoreScript 1.2 is now available HERE and on GitHub
Changes include Service Broker options and the ability to restore a database in...
2018-01-30
641 reads
SQL Undercover Podcast – Feb 2018
The first SQL Undercover podcast where Adrian introduces the Undercover Inspector, David releases sp_restorescript 1.2 along with a bit of...
2018-01-29
443 reads
Creating a SQL Server Test Lab On Your Workstation – Part Three, Creating a Windows Failover Cluster and a SQL Server Availability Group
Welcome along to the third part of our series ‘Creating a SQL Server Test Lab On Your Workstation’. If you’ve...
2018-02-02 (first published: 2018-01-24)
2,211 reads
Introducing: The SQLUndercover Inspector
Introducing: The SQLUndercover Inspector! Finally we have a V1 almost ready to hit our GitHub but what exactly is it?
Just another...
2018-01-22
469 reads
All Scripts Now On Github
@adedba Adrian Buckman has been working hard and has put all of our scripts up on Github https://github.com/SQLUndercover/UndercoverToolbox
2018-01-18
363 reads
Dissecting SQL Server, The Internal Structure of a Row
I’m sure that most of us know that SQL Server stores all it’s data in 8Kb pages. But what do...
2018-01-26 (first published: 2018-01-15)
1,989 reads
Creating a SQL Server Test Lab On Your Workstation – Part Two, Creating a Domain Account and Joining a SQL Server to the Domain
In the second part of our series on creating a SQL Server test lab on your workstation, I’m going to...
2018-01-12 (first published: 2018-01-03)
2,323 reads
Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller
One of the most useful tools to the DBA when we need to test new features, recreate a fault that...
2017-12-18
634 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers