Louis Davidson (Dr SQL)–Designing for Common Problems in SQL Server
The PASS Data Architecture Virtual Chapter hosts none other than Dr. SQL Louis Davidson as he helps application and database...
2012-08-10
1,043 reads
The Smiling DBA
SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint
This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing...
2012-07-28
973 reads
PASS Data Architecture presents Ami Levin: Where Are My (Primary) Keys?
I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my...
2012-07-22
827 reads
SQL Saturday #150 and TechDay Baton Rouge–BI 1 track
The SQL Saturday/TechDay in Baton Rouge will be the forth annual this year. The Business Intelligence sessions occupy 2 tracks...
2012-07-19
894 reads
PASS BI/DW presents Dimensional Modeling 101–by me…
With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach...
2012-07-16
864 reads
I’m Speaking: PASS Summit 2012 and more…
Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of...
2012-07-12
736 reads
Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...
2012-07-10
2,981 reads
Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got...
2012-07-08
1,478 reads
MAXDOP and Cost Threshold for Parallelism – an example for a parallel query
The most popular post on this blog ranked by hits is one about the CXACKET wait stat. There are no...
2012-06-18
2,407 reads
PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint
Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...
2012-06-14
701 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