Using DATETRUNC–#SQLNewBlogger
I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though...
2023-12-29 (first published: 2023-12-18)
475 reads
The Voice of the DBA
Friday Flyway Tips–Deploying Migrations with a Target
Recently I was working with Flyway Desktop (FWD) and helping a customer work on deploying part of their work. They weren’t sure how easy this could be, but this...
2023-12-27 (first published: 2023-12-15)
133 reads
A New Word: Nementia
nementia – n. the post-distraction effort to recall the reason you’re feeling particularly anxious or angry or excited, trying to retrace your sequence of thoughts like a kid gathering...
2023-12-15
46 reads
Clearing Intellisense in SQL Prompt
I got this question from an account rep: if a customer is using SQL Prompt and a snippet, for example AT, that was also used as an alias, is...
2024-01-01 (first published: 2023-12-13)
276 reads
Executing One Line in VSCode–#SQLNewBlogger
I wrote about arrays in PowerShell last week, but I realized one of the things I did while experimenting was look up how to run code a line at...
2023-12-22 (first published: 2023-12-11)
336 reads
Friday Flyway Tips–Comparison Options
Recently a customer asked how they could get index changes to be captured in Flyway Desktop. In their case, they wanted a different fill factor, but I decided to...
2023-12-08
29 reads
A New Word: Guiltwrights
giltwrights – n. the imaginary committee of elders that keeps a running log of your mistakes, steadily building their case that you’re secretly a fraud, a coward, a doofus,...
2023-12-08
42 reads
TryHackMe Advent of Cyber
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure I’d spend the time. Someone then posted a link to the TryHackMe advent calendar. I...
2023-12-06
15 reads
Removing a PowerShell Array Element–#SQLNewBlogger
I saw an article on this and realized I had no idea how to do this, so I decided to practice a bit. I don’t work with PoSh arrays...
2023-12-05 (first published: 2023-12-04)
168 reads
Using ThinOptics to Read Data
As I’ve aged, I find myself struggling to read many things in my life. It started with difficulties seeing menus, but moved on to other areas. During the pandemic,...
2023-12-01
51 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers