Communications: Three Questions
The better skilled we are communications, the more likely we will be understood. Whether we're talking work colleagues or our families and friends, being understood is more important than...
2025-07-28
79 reads
Zero Downtime SQL Server Upgrade: Best Practices for Seamless Migration
Upgrading SQL Server is a mission-critical task for DBAs, especially when the goal is zero disruption to application connectivity. Whether you’re modernizing for performance, compliance, or supportability, choosing the right...
2025-07-28
158 reads
SQL Saturday Baton Rouge 2025
SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has some of the best food, presenters, and attendees in the country! Had some incredible questions...
2025-07-26
51 reads
Responsible AI: Why Leaders Need More Than Just Guardrails
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks, compliance protocols, and technical safeguards. These “guardrails” are necessary, but not sufficient. Because AI isn’t...
2025-07-25
42 reads
TempDB Performance Tuning in SQL Server 2022 vs 2016 vs 2019
📘 What Is TempDB and Why It Matters TempDB is a shared system database in SQL Server used for: Because it’s used by every session and process, TempDB is often a performance bottleneck—especially...
2025-07-24
1,441 reads
Optimize Azure Fabric Pipelines with This Key Spark Setting
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure Fabric pipelines with multiple notebooks running slower than you’d like? Are you paying for more...
2025-07-23
195 reads
Microsoft Fabric shortcut-based AI transformations
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
7 reads
Microsoft Fabric shortcut‑based AI transformations
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
28 reads
SQL Server Post-Install Configurations
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory can now be configured during setup. But don’t be fooled: there’s still a post-install checklist...
2025-07-23
72 reads
How Vastu Principles Can Inspire Smarter Database Administration: A Holistic Approach to Data Architecture
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that data flows securely, efficiently, and reliably. But what if we viewed database environments not just...
2025-07-23
18 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
Alamat Kantor BCA KCU City Tower Telp:08218200233
Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
Alamat Kantor BCA KCU Matraman Telp:08218200233
Wa:628218200233 Alamat. Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
Alamat Kantor BCA KCU Menara Bca Telp:08218200233
Wa:628218200233 Alamat. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5, Menteng,...
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