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)
138 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)
247 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)
498 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)
409 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
30 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)
234 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
15 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
30 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)
244 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
21 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers