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...

Lose #5 Before #sqlpass

Win Valuable Prizes!

Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...

PASS 2012 Countdown – 4 Weeks To Go

One week down and we are now 4-weeks from this years PASS Summit.  Hopefully, you have already registered for the...

Update with UPDLOCK

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

Auditing changes in Merge Replication

One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...

Generate Uniqueidentifier with SSIS

If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box...

Slides and Scripts from Idera Auditing SQL Server presentation

I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...

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...

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:...

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...