How to output from invoke-sqlcmd to Powershell variable

Sorry for another Powershell post but I’ve been doing a lot of it recently and coming up with (what i...

Magazines I Read This Year

In December I went through my current magazine list and made some changes, mostly based on what I had been...

Pragmatic Works Has Balls...SQLBalls

http://www.flickr.com/photos/54296260@N05/6036813377/

That is right Dear Reader, I am making the jump, Starting Monday February 6th I will be a Sr. Consultant...

Re-blog – January 27 – February 2

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

Recovery Modals in SQL Server

Being a SQL Server DBA, one should be able to understand how many recovery modals do we have in SQL...

Sanjee-SQLMaster

Dear All,

very good maorning to all of you.

Slowly Changing Dimensions

When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make.  It...

Speaking for Baton Rouge UGs and SQL Lunch Next Week

I have been quiet over the past year trying to get acclimated to my new job and my new found work...

Verifying Last Successful CheckDB with Powershell and SMO - sorta

A few years ago, I wrote a script that was published on SQLServerCentral.com about how to verify the last successful...

A Script A Day - Day 2 - Database Mail Troubleshooting

Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...