TDE: Database Backups and High Availability
Database backups continue to work without change when you have TDE enabled. The only difference is that the backups contain encrypted data that cannot be read without the certificate...
2023-05-15
31 reads
Blog Posts
Techorama Slides – Analyze Cosmos DB Data with Synapse Link
I’ve uploaded the slides for my session at Techorama to Github.
The post Techorama Slides – Analyze Cosmos DB Data with Synapse Link first appeared on Under the kover of...
2023-05-15
14 reads
The first two chapters of my book are available!
As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...
2023-05-15 (first published: 2023-05-03)
581 reads
A New Word: Vemödalen
vemoödalen – the fear that originality is no longer possible I used to worry about this, and often I thought that I’d run out of original things to do....
2023-05-12
88 reads
Experiments with GitHub CoPilot
There has been a lot of attention given to ChatGPT and AI over the last month or two. I’ve tried a few things with the public interface at Open.ai....
2023-05-12 (first published: 2023-05-03)
611 reads
New Stars of Data – SQL Bad Practices caught in the Wild
At the 12th of May 2023, a new edition of New Stars of Data takes place. If you’re not familiar with the concept, it’s a free virtual event focusing...
2023-05-12 (first published: 2023-05-11)
45 reads
Power BI Cruise Recap – Deep Data Dives
Thank you so much to those of you who were able to attend this three-hour, C# packed session! The Power BI Cruise was an incredible conference, and I cannot...
2023-05-12 (first published: 2023-05-02)
295 reads
The Importance of SQL Server Performance Tuning in the Cloud
Make sure your cloud SQL Server databases are optimized and achieve significant cost savings.
2023-05-12
100 reads
Implementing Temporal Tables Where You Have Existing Data
An in-depth look at how you convert an existing table with data to a system versioned table that will maintain a history of changes.
2023-05-11
124 reads
Monitoring Deadlocks in Azure SQL Managed Instance
Hello Dear Reader! My lastest blog on our Azure FastTrack blog for Microsoft is live, Monitoring Deadlocks in Azure SQL Managed Instance. Here's a little from the blog:To paraphrase Annie,...
2023-05-10 (first published: 2023-05-02)
437 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers