SQL PASS 2014 Summit Diary – Day 6

Today is the last official day of the PASS Summit.  The sessions will wrap up at the end of the...

Working with Very Large Tables Like a Pro in SQL Server 2014

I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....

Blogging for a year!

I’m actually quite proud of the fact that I’ve now been doing this for a year now (and that I’m...

Determine size of the file using T-SQL/Powershell/Ole Objects

There are many ways to find the filesize.
This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and...

Friday Followup For November 7, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Go-Karting Friday PM after PASS Summit 2014 Wraps Up

Hi everyone! If you’d like to join us in the second installation of a high-speed tradition after the SQL PASS...

How to find all running SQL Server Instance on a machine ? TIP #70

Hello friends,

Many times it happened with me I forgot the instance name of SQL Server.

So here is a small trick...

PASS Summit: Blogger Q&A with Board of Directors Executive Committee

On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors:...

Reblog: October 31 to November 6

Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...

Remove Witness from SQL Server Database Mirroring

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2)...