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)
485 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)
144 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
52 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)
279 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)
344 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
38 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
53 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
23 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)
178 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
59 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
ALAMAT BCA KCP Majapahit Telp:08218154393
WA:08218154393 Jl. Majapahit No.112, Pandean Lamper, Kec. Gayamsari, Kota Semarang, Jawa Tengah 50161
ALAMAT KONTAK BCA KCP Ungaran Telp:08218154393
WA:08218154393 Ungaran Square, Jl. Gatot Subroto Blok A3-A4, Banaran Barat, Bandarjo, Kec. Ungaran Bar.,...
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers