Community Speakers/Leaders - Where's the ROI?
I participated in a lunch meeting recently with a number of people from MS that work on their community efforts,...
2008-06-16
1,786 reads
Blog Posts
Trigger Notes
One of the questions that came up during a panel discussion at SQLSaturday #4 was whether it was better to...
2008-06-15
1,481 reads
RC0 and HierarchyID
I gave a presentation Tuesday to my local SQL user group on 2008 T-SQL and data types. One of the items...
2008-06-13
768 reads
TechEd - Execution Plans
Randy Dyess of Solid Quality Mentors had a session and since I'd just gotten a copy of Grant Fritchey's book...
2008-06-13
860 reads
Avoid Domain Admin level accounts for SQL Server
Every so often I see a post in the forums where someone has stated they've used a Domain Admin level...
2008-06-12
12,923 reads
Notes on My Visit To The Space Coast Users Group
I visited the Space Coast group last night, hosted by Ken Tucker, and did about 90 minute of SQL Q&A...
2008-06-12
564 reads
SQLSaturday #6 in Cleveland - Registration Open
Long time acquaintance Allen White is hosting SQLSaturday #6 in Cleveland on August 9th. Registration and call for speakers is...
2008-06-12
440 reads
TechEd - Day 3
I left my laptop at the Red Gate booth, and then managed to wander up to a Data Compression talk...
2008-06-12
738 reads
TechEd - Query Performance
A program manager asked the question at the start: Who's had a query performance issue where a query "went bad"...
2008-06-12
1,060 reads
Presentations using a Panel Format
At the recent SQLSaturday #4 we had a session end up finishing much earlier than expected, so we gave the...
2008-06-11
713 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