Rotating Header Image

Posts from ‘March, 2010’

Monitoring With Powershell (pings, services, and websites)

So it’s no secret that I’ve been having an affair on TSQL. I’ve been seeing PowerShell behind her back and I gotta tell ya even after the initial excitement of a new language I’m still loving it. Let’s talk monitoring. I started with a requirement of: Pinging a list of production level servers Checking specific […]

SQL Server 2008 Internals and Troubleshooting and DBA Survivor

OK so I’m back from an extended vacation from and although my vacation had nothing to do with warm weather, beaches, or bacon it was time well spent on finishing up my chapters for the soon to be released Pro Server 2008 Policy-Based Management book. After going through this process I have a whole new […]

sp_refreshview How Did I Forget You?

So a developer asked me a question about how he added a column to a table and now the view that referenced the table wasn’t showing the column.  I asked the obvious question: “Did you add the column to the view?” to which he replied “The view is doing a SELECT *” OK it may […]

Congrats to Team Canada!!

It’s a rarity for me to blog about something non-SQL Server related but I have to tell you the 2010 Winter Olympic Games were pretty amazing.  Anyone who knows me (or who met me at the Summit last year) knows that I’m a huge hockey fan and I have to give credit where credit is […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.