SQL Server Autogrowth Settings Changes
Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...
2024-02-01
3 reads
THAT Conference 2024–Austin
This week I attended THAT Conference in Round Rock, just outside Austin, Texas. This was my second time attending the conference, which is a very unique. The conference runs...
2024-02-01
43 reads
sp_snapshot – The easy way to take database snapshots of one of more databases – Version 2.0
Presenting you with an updated version of our sp_snapshot procedure, to easily create database snapshots. This new version adds more flexibility to the procedure, allowing you to specify the...
2024-02-14 (first published: 2024-02-01)
427 reads
Query Store: How to open multiple instances of the 'Tracked Queries' dashboard
At the beginning of this week, I shared how you can Search for queries with Query Store GUI .
Today I want to share something, Query Store related, that bugged...
2024-02-16 (first published: 2024-02-01)
373 reads
Exploring the Spark Connect gRPC API more
All Spark Connect Posts
Code
Goal of this post In this post we will continue looking at the gRPC API and the AnalyzePlan method which takes a plan and analyzes it....
2024-02-01
123 reads
DBAs, Give Git a Try – Getting Started
One of the really interesting things over the last decade is both the rise of Git as the main VCS system for most projects, and the number of people...
2024-02-14 (first published: 2024-01-31)
1,198 reads
BI Training with Eugene Meidinger
I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...
2024-01-31
65 reads
How to Find Where Your Databases Reside In The File System
How to Find Where Your Databases Reside In The File System
SQL Script:
Copy
/*
RETURNS LIST OF FOLDER NAMES WHERE SQL SERVER DATABASE
FILES ARE STORED.
It is dynamic...
2024-12-27 (first published: 2024-01-31)
877 reads
Understanding and Using xp_sqlagent_enum_jobs in SQL Server
Understanding and Using xp_sqlagent_enum_jobs in SQL Server
What is xp_sqlagent_enum_jobs?
xp_sqlagent_enum_jobs is an undocumented, extended stored procedure in Microsoft SQL Server. It is used to provide information about the jobs that are...
2024-02-12 (first published: 2024-01-31)
1,141 reads
Darling Data SQL Server Stored Procs in Azure SQL Database
Erik Darling, founder of Darling Data, has created these fantastic stored procedures to query SQL Server more efficiently to get health, log, or performance information. I will go through...
2024-02-16 (first published: 2024-01-30)
541 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers