SQL Server 2025 GAs Today
If you aren’t watching the Ignite keynotes today, then you might have missed the announcement that SQL Server 2025 officially releases today. The main SQL Server page gives you...
2025-11-18
50 reads
If you aren’t watching the Ignite keynotes today, then you might have missed the announcement that SQL Server 2025 officially releases today. The main SQL Server page gives you...
2025-11-18
50 reads
Short version You want to get this running as fast as possible. Do these four steps, and then check the compatibility section later in this post. Step 1: Install...
2025-11-18
60 reads
Last week I asked you to write about SQL Server 2025 and what things you might be looking forward to in the new version. First, as usual, is Rob...
2025-11-18
143 reads
Writing Better Dynamic SQL
This updated and "sort" of a style guide is for SQL developers and, to some extent, DBAs, essentially anyone daring (and sometimes...
2025-11-18
319 reads
Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...
2025-11-18
16 reads
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it...
2025-11-20 (first published: 2025-11-18)
144 reads
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is a great feature that can help with writing SQL queries and scripts sql development. However,...
2025-11-15
182 reads
If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...
2025-11-28 (first published: 2025-11-14)
434 reads
Quite a long title for a short blog post ??While deploying a DACPAC (from a SQL Server Data Tools Database Project) through Azure Devops, I got the following error...
2025-11-16 (first published: 2025-11-14)
56 reads
I had a great question asked of me the other day and thought I would turn the answer into a blog post. The question is “I’m an experienced DBA...
2025-11-12
23 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Hub Via Wa:628218154374 Alamat: Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Hub Via Wa:628218154374 Alamat: Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan...
Hub Via Wa:628218154374 Alamat: Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5,...
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