SQL Server Myth on Clustered Index page allocation or B-Tree formation
Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...
2011-07-11
2,365 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
My Favourite SQL Server Myths and Realities
It has been more than two months since I blogged. I have been blogging in my Organization internal blogging site on Management...
2011-06-28
3,807 reads
Why knowledge of internals is required for DBA? here is a valid reason
I got a report from development team that section of BizTalk communicating with SQL Server to update status
is frequently...
2011-02-24
1,195 reads
Evaluating Performance of View and Stored procedure
I got a chance to evaluate performance of both views and stored procedure for high level decision making.
As all of Us knows that purpose/scope...
2011-02-13
11,589 reads
Examining PFS, GAM and SGAM pages
Anyone who can interpret data and index pages will surely think about interpreting PFS, GAM and SGAM pages. I am...
2011-02-13
5,620 reads
SQL Server Storage Internals Part 6 – How to read Clustered and Non Clustered Index Pages
In this article we are going to see how index pages are organized with data pages and how to read different...
2010-12-29
7,601 reads
SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-29
5,713 reads
SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-27
9,511 reads
SQL Server Storage Internals Part 2 - Partitions and Allocation Units
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-27
4,468 reads
SQL Server Storage Internals Part 4 - How to read a Heap page
I like to share 4 updates before moving on to this section:
1. I 've updated my profile to know more about...
2010-12-21
7,760 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
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
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