Service Broker–WAITFOR and Activated Queues
We’ve implemented Service Broker for handling a small portion of the transactions we want to catch and apply into our Operational Data Store. Mostly we wanted to make sure we accounted for actual DELETE operations and handled
Quickly script permissions in SQL 2005+
Posted by paschott in SQL Server On February 17, 2011
I wanted an easy way to generate a script to recreate all DB object and schema permissions for a database. Searching online, I found several different examples, but none quite did everything I needed. I put this
SQL 2008 R2 – SSIS Data Export Oddities
I don’t know if anyone else has had these sorts of issues, but we work quite a bit with conversions of various source data into our SQL Server database. I recently was handed a backup from SQL
SQL 2008 Merge and PK/FK Constraints
Posted by paschott in SQL Server On January 17, 2011
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 a Foreign Key relationship. If you attempt to insert into a table
Book Review: Cooking For Geeks
(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 you’re looking for a new collection of recipes, this is not the
SSIS, OLEDB Data Sources, and Table Variables
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 doing a pretty large select out of a table filtered on a
Review: Windows PowerShell 2.0 Best Practices – Introduction
A while back I received a review copy of Windows PowerShell 2.0 Best Practices by Ed Wilson (blog | twitter) and the Windows PowerShell Teams at Microsoft. Having finally found the time to sit down
Powershell for Database Developers
Posted by paschott in SQL Server On April 13, 2010
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 up to my blog shortly so wanted to make good on that
Powershell: Writing Text Files
Posted by paschott in PowerShell On March 17, 2010
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 some custom encryption algorithms. Thanks to the wonderful Powershell community, I found
Powershell Links – 2010-03-06
Posted by paschott in PowerShell On March 7, 2010
Here are some of the more interesting Powershell links I came across recently, along with some thoughts about them. Powershell, String Encryption, and GPG – SQLServerCentral.com brought this one to my attention. Chad Miller discusses working with