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

331 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

487 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

454 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

846 reads

Blogs

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

By

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

The Book of Redgate: Evidence

By

We aren’t the only company that does this, but Redgate Software does try to...

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

By

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....

Read the latest Blogs

Forums

The New World Of AI Robots

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New World Of AI...

Logic question in a WHERE clause using IIF?

By DaveBriCam

Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...

Execute as failure

By pdanes

Security has long been a problem for me. Every time I think I understand...

Visit the forum

Question of the Day

BIT_COUNT() V

What does this return on SQL Server 2025?

select bit_count(null)

See possible answers