Speaking at SQL Saturday #145 in Nashville

I will be speaking at SQL Saturday #145 in Nashville, TN to speak on one of my favorite topics – Virtualizing...

SQL Server:Understanding The Page Free Space (PFS) Page

In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...

Update with UPDLOCK

Do you think it’s a good idea to add UPDLOCK hint to the table which will be modified in an...

X-XMLA: vii. Partition Management with XMLA

In the 7th article of this series, I will discuss how to manage your partitions with XMLA.   We will be...

A Journey To SQL Authority

I am delighted to welcome to the blog someone who is without a doubt one of the biggest names in...

Comments on the SQL in the City Tour

There’s still anevent in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New...

High Energy Plankton – T-SQL Tuesday #35

High Energy Plankton
In 2022 humans will finally have become their own worst enemies/frenemies.  No matter how hard Gore works to...

High Energy Plankton – T-SQL Tuesday #35

So, what I’d like to know is, what is your most horrifying discovery from your work with SQL Server?
Related Posts:

Data Platform MVP 2020 August 12, 2020

It's an Honor:...

Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!

Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the...

MDS Error: “Cannot insert the value NULL into column ‘Code’”

In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...