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
125 reads
Blog Posts
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
New Job -> Week 7 and Beyond
This is part of a series of new job blog posts. You can find them all here. As a DBA, the first six weeks on the job can be...
2023-05-10 (first published: 2023-05-01)
160 reads
Code That Writes Code
“Work Smarter, not Harder” We’ve all heard it before, pretty much any job, anywhere. In our DBA slice of the IT world, this is very relevant to how we...
2023-05-08 (first published: 2023-04-28)
511 reads
Tales From The Field Weekly Wrap Up for the Week of 05-01-2023 A new house, a reunion, & 15 Years of SQL Saturday Jacksonville
Hello Dear Reader, what a week! On Thursday my wife and I closed on a new house. We are so incredibly excited! We owned a house for a very...
2023-05-08
17 reads
What Is Azure Data Factory?
What Is Azure Data Factory? Azure Data Factory (ADF) is a cloud-based PaaS data integration solution that provides a fully managed, serverless environment for ingesting, preparing, and transforming your...
2023-05-08 (first published: 2023-05-01)
703 reads
A New Word: Chysalism
Chysalism – n. the amniotic tranquility of being indoors during a thunderstorm? While I love the sun, I did enjoy thunderstorms when I lived in Virginia. Something neat about...
2023-05-05
30 reads
Change the Default Git Branch for a dbt Cloud Project
In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what...
2023-05-05 (first published: 2023-04-24)
42 reads
Exporting SQL Data Compare Results to Excel
I had someone ask recently about getting SQL Data Compare results in Excel. It’s easy to do and this post looks at the process. Exporting a Comparison I won’t...
2023-05-05 (first published: 2023-04-25)
155 reads
Traveling to SQL Saturday Jacksonville 2023
I’m heading to SQL Saturday Jacksonville 2023 today, speaking tomorrow. After not making any of their events, I went in 2022 and am back for their 15th event this...
2023-05-05
31 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers