Query backup history

As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.

It shows you the...

Reblog: June 6 to June 12

Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...

SQL Saturday South Florida And Then Vacation

I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...

Data loss in clustered index occurs when you run online build index in SQL Server 2012

Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.
This morning I checked my...

Giving Away Woodworking Magazines

I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a...

Happy Anniversary!

Today, http://mssqlfun.com/ completed 2 precious years with your support & acknowledgment. It’s wonderful time enriched with fun & learning.
Please keep liking us...

Mainstream Support Ending Soon || SQL Server 2008 and SQL Server 2008 R2

Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon.
Mainstream Support...

Partitioning Basics – Part 2 – Splitting/Merging Partitions

This post follows on from the previous post Partitioning Basics – Part 1
Let’s have a look at the partitions setup in...

Presentation DAC “SQL Server Implementation Framework From Dev to Prod”

The San Francisco SQL Server User Group – June 11 2014 Uploading presentation DAC for Today’s session….

Presentation DAC SQL Server Implementation Framework From Dev to Prod