The Four Different Types of Flyway Files
This is documented, somewhat, but I wanted to put this down for myself, as the I don’t love the docs and they are hard to sort through. Flyway is...
2023-07-07 (first published: 2023-06-26)
127 reads
Blog Posts
T-SQL Tuesday #163 – Career Advice I received
It’s time for our monthly blog party and thanks to Gethyn Ellis ( t | b) for hosting this month. Gethyn asks us for the best Career
The post T-SQL Tuesday #163...
2023-07-07 (first published: 2023-06-21)
240 reads
Microsoft Fabric introduction video
I blogged about Microsoft Fabric a few weeks ago, and wanted to follow up with an introduction video that covers the basics so hopefully you will understand the major...
2023-07-05 (first published: 2023-06-19)
489 reads
Storytelling for DBAs and Other Technical Folk
(for your reading pleasure, written by Jules. –ed) We have all had that sinking feeling of defeat: you’ve just finished explaining a very important and highly technical thing to...
2023-07-05 (first published: 2023-06-20)
406 reads
Talking about the New Open-Source SQLCMD on Data Exposed
I was on the Data Exposed: MVP Edition show recently, talking about SQLCMD. I’ve written a few articles on the topics as well, and a blog post about setting...
2023-07-05
27 reads
Connecting to Azure SQL DB with an Azure Active Directory Account in Azure Data Studio
This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I...
2023-07-03 (first published: 2023-06-15)
231 reads
Speaking at Live! 360
I am super excited to announce that I have been selected to speak at SQL Server Live! in Orlando in November. I have selected to present two sessions, which...
2023-07-03
12 reads
Speaking for Future Data Driven Summit 2023
I am excited to announce that I have been selected to speak for the Future Data Driven Summit 2023. This is a free online conference, on Wednesday, 27-September-2023, for...
2023-07-03
27 reads
What Happens in the Background when Executing Queries with Always Encrypted
In previous posts we've looked at a number of aspects of Always Encrypted and how it works. I think it's very useful to understand how it actually works in...
2023-07-03 (first published: 2023-06-15)
239 reads
A New Word: Licotic
licotic – adj. anxiously excited to introduce a friend to something you think is amazing – a classic album, a favorite restaurant, a TV show they’re lucky enough to...
2023-06-30
19 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers