System Sessions/Spids Rather than Spid < 50
Saw System Sessions posted on the PSS blog and it shows an example of information being written to the error...
2008-01-23
609 reads
Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
543 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
844 reads
A Holiday Posting
It's Martin Luther King, Jr. day here in the US where we remember the famous civil rights leader. So my...
2008-01-21
677 reads
Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,450 reads
Learning to Blog via Books
I was chatting with a friend recently and in the course of 'what are you up to lately' I mentioned...
2008-01-20
498 reads
Connecting to a Reporting Services Model
There's always been some confusion about models in Reporting Services, many people ignore them thinking that they are only for...
2008-01-18
1,567 reads
Free Ebook Chapter(Book) - Introducing SQL Server 2008
Saw it mentioned in the recent MSPress newsletter, Peter DeBetta is writing Introducing SQL Server 2008 and right now Chapter...
2008-01-18
867 reads
The Interviewer is Wrong
Michael Coles had an interesting post about a job interview a friend went on. The person answered questions correctly, but...
2008-01-17
885 reads
MVP Chat
My first MVP chat was today, a monthly hour long session where we have a Microsoft representative and we all...
2008-01-17
725 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