We ran into this issue a while back.  SQL 2008 has a “feature” that will not allow inserts into a table on either side of…

(I know this isn’t SQL-related, but I think this may be a great read for people with similar interests.) This is not a cookbook. If…

I ran across an interesting problem when trying to tune some SSIS data source performance issues the other day. I had noticed that we were…

    A while back I received a review copy of Windows PowerShell 2.0 Best Practices by Ed Wilson (blog | twitter) and the Windows…

I recently presented for the SQLPASS AppDev Virtual Chapter on “Powershell for Database Developers”.  I promised that I’d get the files used in the demos…

I was recently trying to generate a bunch of data that I needed to pass through one of our in-house DLLs in order to use…

Here are some of the more interesting Powershell links I came across recently, along with some thoughts about them. Powershell, String Encryption, and GPG –…

I’ve run across this before so wanted to write up a solution to keeping track of schema changes we’ve used. We trust our team to…

While with the time and knowledge we can write a lot of the things we’ll use in Powershell, it’s often not worth it to re-invent…

I’m writing this one so I remember these operators. Powershell doesn’t use standard operators such as =, <, , !=, etc. These operators are used…