I am a senior software programmer who is still working hard to get a DBA hat. I am in love with SQL Server. SQL Server for me is all about passion. I am MCSA in SQL Server. Through this blog I am giving myself an opportunity to learn more about SQL, as well as sharing my knowledge and expertise with the world.

Blog Post

Non-Clustered Index

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...

2015-10-04

322 reads

Blog Post

Non-Clustered Index

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...

2015-10-04

477 reads

Blog Post

GAM and SGAM

In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...

2015-09-12

448 reads

Blog Post

GAM and SGAM

In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...

2015-09-12

809 reads

Blogs

Ramblings about data communities and your contributions, no excuses

By

I have been active in the data community throughout my career. I have met...

SQL Server Journey till 2025 (brief)

By

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

Building Power BI Reports: Desktop vs Fabric

By

Why this comparison feels confusing If you’re a Power BI report author who’s just...

Read the latest Blogs

Forums

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

By NKTgLaw

SQL Server is typically viewed as a transactional or analytical database engine. However, it...

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

By DanielP

Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...

Having a Little Fun at SQL Server Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Having a Little Fun at...

Visit the forum

Question of the Day

String Similarity I

On SQL Server 2025, when I run this, what is returned?

SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL')

See possible answers