Chance to win a free seat in my Performance Troubleshooting Workshop in London!
As you might know, I'm running my "Advanced SQL Server Performance Troubleshooting
Workshop" from September 12 – 14 in Central London. You...
2011-08-21
966 reads
Blog Posts
Pull Performance Data from Perfmon Logs with PowerShell
For the last year and a half or so I've been presenting a session on how to gather perfmon data...
2011-08-21
2,415 reads
What Will Be New for Reporting Services in 2012?
Drum roll, please! We’re in the throws of refreshing the Wrox Professional Series book on Reporting Services and, as we...
2011-08-21
1,276 reads
ORDER BY Clause with clustered index
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...
2011-08-20
1,978 reads
Thoughts on DBA Professional Development
As a DBA, we have a lot to work on and also we have a lot to learn about. The...
2011-08-20
1,404 reads
Win a Ticket to the “Advanced Programming” Course
We are opening another class of the “Advanced Programming in SQL Server” course on 28/08. You can find all the...
2011-08-20
472 reads
Attach database without log file and rename database
Assuming the database was detached successfully , this t-sql code will attach a mdf file without a log file . It will also...
2011-08-19
1,332 reads
Bitwise Operations
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing a follow-up to that. Alas the opportunity has passed...
2011-08-19
6 reads
Bitwise Operations
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing...
2011-08-19
1,598 reads
JAX Code Camp 2011
For the past 7 years, Bayer White and other Jacksonville .Net leaders have put on great Code Camps for .Net...
2011-08-19
1,010 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