On the Move to SQL Server Connections
Brian Kelley, speaking on the SQLServerCentral track.
A bit of a crazy day for me, starting off a crazy week. I...
2011-03-28
748 reads
Blog Posts
Oracle Drops the Bomb
The below information has been taken from SSWUG.org.
Oracle Drops the Bomb
Since the purchase of Sun and it’s holdings by Oracle...
2011-03-28
819 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is really not too big of a deal. While demonstrating...
2011-03-28
21 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is...
2011-03-28
1,932 reads
SQL in the City – The Red Gate Tour
Red Gate Software is announcing SQL in the City today, a series of events that will bring a free day...
2011-03-28
1,459 reads
SQL Math: Whole Numbers, Real Numbers
It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no...
2011-03-28
1,880 reads
SQL Saturday #67 Wrap-up
Just… Wow. What an event. What a great group of people. I’m just so lucky to be involved with fantastic...
2011-03-28
923 reads
Think Like a Customer
This is the most important and essential first step for a DBA on the journey to providing outstanding customer service....
2011-03-28
856 reads
Tip on Speaking (and Writing) Well – The Key Idea
Cross-posted from the Goal Keeping DBA blog:
In the September 2010 issue of Toastmaster magazine there’s a great article by Chris...
2011-03-28
1,287 reads
Torn page detection vs Page Checksum
TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The...
2011-03-28
909 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