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

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

Summit 2014 – Next Impressions

As Summit 2014 begins to wind down, it is time for some more impressions from the week.  The week has been good so far.  It has been very busy...

Summit 2014 – Next Impressions

As Summit 2014 begins to wind down, it is time for some more impressions from the week.  The week has...

SQL PASS Summit 2014 Diary – Days 3-5

The last two days have been an absolute blur.  As I first posted this week, I had planned to blog...

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

Versioning In Your SQL Database

Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...

Versioning In Your SQL Database

What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking about version control,...

Thoughts on the 2014 PASS Summit From A Non-Attendee

I missed the Summit this year, but tried to follow along remotely via Twitter, PASSTV, and the blog posts I...

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