Blog Posts

this month is the big month and a month to remember their are so many announcements has been done in this month – May -2024 . As this is...

2024-05-23

24 reads

Bicep Your Elastic Jobs

by hellosqlkitty

SQLKitty

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)

150 reads

Migrate datetime data to datetimeoffset with AT TIME ZONE

by Will Assaf

SQL Tact

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)

391 reads

Using Flyway with Feature Flags

by Steve Jones

The Voice of the DBA

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

29 reads

6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery

by Tracy McKibben

RealSQLGuy - Helping You To Become A SQL Hero

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

84 reads

3rd Party Applications Have Issues

by Kevin3NF

Dallas DBAs

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)

188 reads

Data-driven vs. Data-informed: Let’s Acknowledge the Truth

by Meagan Longoria

Data Savvy

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

4 reads

Get row counts of all tables in a Microsoft Fabric warehouse

by Koen Verbeeck

Koen Verbeeck

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)

253 reads

A New Word: Flichtish

by Steve Jones

The Voice of the DBA

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

9 reads

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

by Steve Jones

The Voice of the DBA

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)

334 reads