Bicep Your Elastic Jobs
I posted on Terraform and Azure SQL last year but wanted to see what Bicep could do this year. I’m going to test Bicep out with Elastic Jobs. TL;DR—My...
2024-05-22 (first published: 2024-05-02)
170 reads
Blog Posts
Migrate datetime data to datetimeoffset with AT TIME ZONE
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft Learn Docs article at the recommendation of my colleague Randolph West, who guessed (accurately) I...
2024-05-22 (first published: 2024-05-03)
415 reads
Using Flyway with Feature Flags
There is a nice article at Harness.io on their use of feature flags and how they deployed their next generation experience. It’s worth a read if you want to...
2024-05-22
51 reads
6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative data career or just want a new skill under your belt, learning SQL is a...
2024-05-21
110 reads
3rd Party Applications Have Issues
As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...
2024-05-20 (first published: 2024-05-02)
208 reads
Data-driven vs. Data-informed: Let’s Acknowledge the Truth
This comic was retweeted into my timeline on Twitter (I refuse to call it X). Here’s the dialog from the comic, for those that don’t want to click through...
2024-05-20
19 reads
Get row counts of all tables in a Microsoft Fabric warehouse
I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You get an option to load sample data when you create a new pipeline in...
2024-05-20 (first published: 2024-05-02)
270 reads
A New Word: Flichtish
flichtish – adj. nervously aware how much of your self-image is based on untested assumptions about yourself – only ever guessing how you’d react to a violent thread, a...
2024-05-17
22 reads
Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger
I wrote a post recently about pruning branches in git. That’s part of the job, but the other part is removing local branches. This post looks at one way...
2024-05-17 (first published: 2024-05-01)
351 reads
Develop and Test Your Rollback Plan
he rollback plan... what to do when things go wrong to get back to where you were before the deployment or implementation. I've seen too many cases where a...
2024-05-17 (first published: 2024-05-01)
371 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers