T-SQL Tuesday #016 – Aggregation
It’s that time of month again, time for Adam Machanic’s (Twitter | Blog) T-SQL Tuesday blog party. This month the party...
2011-03-09
817 reads
Blog Posts
Aggregating With Correlated Sub-Queries #tsql2sday
It’s that time of the month again. Time for T-SQL Tuesday! This month’s event is being hosted by Jes Schultz...
2011-03-08
694 reads
An Overview of SQL Server AlwaysOn
One of the changes coming in SQL Server v11 (not sure what the name will actually be), also known as...
2011-03-08
919 reads
Come on Out to OPASS
Tonight is the March OPASS meeting. You should come on out, it’s always a great time. Note our new location and be sure to RSVP so we can have...
2011-03-08
5 reads
Come on Out to OPASS
Tonight is the March OPASS meeting. You should come on out, it’s always a great time. Note our new location...
2011-03-08
811 reads
Customizing Report Manager Should Be Easier
You might be reading this hoping that I have the magic answer on how to make the Report Manager portal...
2011-03-08
683 reads
Firefox and Reporting Services
Not everyone uses IE and that’s ok, but what’s strange is that by default if you point Firefox at a...
2011-03-08
862 reads
Full backups, the log chain and the COPY_ONLY option.
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,345 reads
How to Raise Your Game by Doing Nothing
What if I told you that you could become a more effective Database Administrator by doing nothing?
That’s right, in this...
2011-03-08
485 reads
March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries
Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL...
2011-03-08
650 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 KONTAK BCA KCP Alaydrus Telp:08218154392
WA CS (08218154392) Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...
ALAMAT BCA KCU RAWAMANGUN Telp:08218154392
WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
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,...
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