SQL Server 2008 SP2 Cumulative Update 3
Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in...
2011-03-22
1,237 reads
Blog Posts
SSAS - Measures or Attributes in Multiple Display Folders
I had a client recently show me a neat little tip that I thought I would share.In the cube he...
2011-03-22
1,283 reads
SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.
When deploying or processing a cube or dimension you may encounter an error similar to this:
Errors in the metadata manager. The...
2011-03-22
1,260 reads
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
2011-03-22
2,075 reads
What Are Your Indexing Strategies?
A couple weeks ago, I got some pretty great new. The book proposal that I had submitted to Apress was...
2011-03-22
636 reads
21st March - Today is International Day for the Elimination of Racial Discrimination
How to Counter Intolerance, Adapted from UNESCO’s Recommendations
1. The Battle Against Intolerance Requires Law
Every Political Entity needs to reinforce Human...
2011-03-21
1,112 reads
Blog Syndication
I got sent an email recently asking how I went about syndicating my blog on some of the popular SQL...
2011-03-21
1,737 reads
Communication
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become...
2011-03-21
2,614 reads
Database Mail – Collection of SQL Server Scripts
As part of my blogging I’ll be periodically providing readers with a collection of my scripts which I use on...
2011-03-21
938 reads
Dedupe Data CTE
As a DBA working with SQL Server, some data issues arise that need to be fixed. One such data issue...
2011-03-21
1,391 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