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
459 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
397 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
642 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
451 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,221 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
485 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
370 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)
2,002 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,332 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
643 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers