Log Shipping with ESEUTIL and PowerShell on a Slow Network

Posted by on December 12, 2011 No comments

This post is stemming off of my last post Moving a Large Database Across the Network with ESEUTIL. Since log shipping for SQL Server requires a fast network.  This combination can prove to be quite useful especially when you are …

Read more »

Moving a Large Database Across the Network with ESEUTIL

Posted by on November 24, 2011 No comments

As I’m writing this little gem, I am currently moving a 68GB compressed SQL backup file from the East Coast to the West Coast (USA) and I must say, I’m happy about it.  Why you ask? because it doesn’t take …

Read more »

Performance Tips Using DMV (Execution/Session)

Posted by on June 10, 2011 No comments

Let’s face it. As a DBA you need to keep an eye on what is happening within your database. Here are a couple of DMF/DMVs worth retaining to memory. The category I am going to delve into is sys.dm_exec_sql_text and …

Read more »

Money Data Type – Not $o much

Posted by on May 10, 2011 No comments

I wanted to write about this little gotcha! It can be so simple to overlook while designing a table. To most of us in the USA we think of money to be only two decimal places – example: $1.99 not …

Read more »

WMI Event Watcher Task

Posted by on May 4, 2011 No comments

Recently I had a need to run a dtsx package after a file entered a certain folder.  I used the WMI Event Watcher Task and liked it so much that I wanted to take minute to shed some light on …

Read more »

Hello World!

Posted by on April 27, 2011 No comments

‘Hello World!’ Such a familiar term in the Microsoft development environment.  I am putting together this blog to offer a simple clear perspective in the world of Business Intelligence and perhaps a bit of Database Administration. I am a self proclaimed data geek. Ever since …

Read more »