A Quick Look At The All New Undercover Catalogue, Preview Release Due Out Soon…
I thought I’d give you all a little preview of our latest offering, the Undercover Catalogue which should be available...
2018-08-06
267 reads
SQL Undercover
Are your backup files where they say they are?
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...
2018-08-08 (first published: 2018-07-25)
2,015 reads
Selecting a Random Row From a Table
A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...
2018-07-26 (first published: 2018-07-20)
725 reads
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here.
Bert...
2018-07-18 (first published: 2018-07-10)
2,708 reads
Backup Your On Premise SQL Server Directly to an AWS S3 Bucket
I’ve been having a little play around with AWS recently and was looking at S3 (AWS’ cloud storage) when I...
2018-06-18
879 reads
Resend an email sent from SQL Server using TSQL
Sometimes emails from SQL Server go missing, especially when you share an inbox with colleagues. On most occasions it doesn’t...
2018-06-14 (first published: 2018-06-05)
2,390 reads
Convert a Positive Number To a Negative In SQL With a Spot of Bitwise Logic
Now this is something that I’ve seen asked a few times and it’s always a question that gets a fair...
2018-05-24
2,517 reads
Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,415 reads
T-SQL Tuesday #101 – My day of Essential SQL Server tools.
This month’s T-SQL Tuesday is brought to you by Jens Bestergaard – the subject is Essential SQL Server tools, the original...
2018-04-10
1,095 reads
Encrypting SQL Server Database Backups
We all go to great lengths to make sure that our databases are secure (or at least I really hope...
2018-04-09 (first published: 2018-04-04)
2,472 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers