Change SQL Startup Parameters with PowerShell
Backups Abound
The Annoyance
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
2011-03-31
14,422 reads
Blog Posts
Hanging with an Inspiration
A long, long time ago, in a state far away, I started writing about technology. At the time, in the...
2011-03-31
1,404 reads
PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer. This past week I got word back concerning that...
2011-03-31
4 reads
PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer....
2011-03-31
1,541 reads
Presenting with a Mac
My name is Brian Kelley and I used to be a PC bigot. That was back in 1989. I was...
2011-03-31
1,574 reads
Taking It To The Next Level
Have you set the bar high enough to ensure your success?
You’re reading Taking It To The Next Level, day 5 of 5...
2011-03-31
1,430 reads
To Do: Win Great SQL Training and a Cruise
Wondering what to do when you get a break from work email today?
Make your opening move in a fun contest.
What’s...
2011-03-31
1,905 reads
Brad McGehee talking about tempdb issues
Brad presented a session that tries to help you identify and fix tempdb problems. Performance monitor is your friend. the...
2011-03-30
1,855 reads
Brian Kelley on Security at SQL Server Connections
Random notes from Brian Kelley’s security talk. Brian spent a number of years working a a security guy for a...
2011-03-30
1,897 reads
Dude, where’s my memory?
A session I have wanted to see. Marciej Pilecki has done this before with high ratings and I have missed...
2011-03-30
1,663 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
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