Spring may be long gone but you still need to clean up MSDB

System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look...

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

SQL Server 2012 Service Pack 2 (SP2) RTM Is Now Available !

SQL Server 2012 Service Pack 2 (SP2) RTM is now available for download at the Microsoft Support site. Service Pack...

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

What is this default trace you speak of?

I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...

Win a Free Copy of my Book - Getting Started with SQL Server 2014 Administration

Readers of my blog would be pleased to know that I have teamed up with Packt Publishing and we are...

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

VMware vSphere 5.5U1 NFS APD Patch Released

If you are running VMware vSphere 5.5 Update 1 and are using NFS-connected storage, update your hosts ASAP (test first,...

Presentation DAC SQL Server Implementation Framework From Dev to Prod