A New Word: Zielschmerz
zielschmerz – n. the dread of pursuing a lifelong dream, which requires you to put your true abilities out there to be tested on the open savannah, no longer...
2023-11-03
130 reads
Blog Posts
Deleting a Git Branch–#SQLNewBlogger
I had someone ask me recently about deleting branches. While I had known how to delete a local branch, I had to look up how to delete a remote...
2023-11-03 (first published: 2023-10-23)
176 reads
Friday Flyway Tips–Seeing Pending Migrations
I find that quite a few people using Flyway will end up with a lot of migration scripts over time. While you can certainly re-baseline and split scripts into...
2023-11-03
47 reads
SQL Server query runtime is not everything
SQL Server query developers, listen up! Query execution time is not everything you should be worried about. You need to examine the parse and compilation time for each of...
2023-11-03 (first published: 2023-10-18)
662 reads
Finding Object Dependencies in SQL Doc
I had a customer recently ask if they could find out which objects are dependent on others using SQL Doc. This post shows how to do that. Using SQL...
2023-11-01
317 reads
SQL Server Backups are Not a High-Availability Solution
Please continue doing your backups! Backups are Disaster Recovery, yes…but not HA. Some will argue with this (in the comments most likely), but I broadly define “High Availability” as...
2023-11-01 (first published: 2023-10-17)
334 reads
Using the Pure Storage PowerShellSDK2 - Part 3 - Getting Performance Data from FlashArray
Welcome back to the second installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, we’ll learn how to retrieve performance data from FlashArray...
2023-11-01 (first published: 2023-10-18)
160 reads
Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-10-30
9 reads
Fabulous Stuff in Fabric – Part 1: Cloning Tables
A while ago I had a little blog post series about cool stuff in Snowflake. I’m starting up a similar series, but this time for Microsoft Fabric. I’m not...
2023-10-30 (first published: 2023-10-17)
342 reads
T-SQL Tuesday 167 – Encryption and Data Protection Roundup
Huge thanks to everyone who responded to my invitation to blog on Encryption and Data Protection for this month’s T-SQL Tuesday. I got what I hoped for, which was...
2023-10-30 (first published: 2023-10-17)
318 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers