Category: SQL Server
SSDT: Why Use SQL Projects?
What Are SQL Projects and why use them? SQL Server has always been lacking in a good solution to control versions of your database. We…
Installing SQL Server, Sharepoint, PowerPivot on a single server
I’ve been trying to set up a single virtual machine for a proof of concept using SQL Server Denali CTP3, Sharepoint 2010, and PowerPivot. I…
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…
Quickly script permissions in SQL 2005+
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…
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…
SQL 2008 Merge and PK/FK Constraints
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…
Powershell for Database Developers
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…
DDL Schema Change Auditing on SQL Server 2005 / 2008
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…
Learning to work around DB Pro
I’ve been trying to get a multi-database solution working correctly with MS Visual Studio Team System for Database Professionals (aka DBPro or DataDude). Anyone who…
SSIS and XML Output
I was pretty surprised by this and am in pretty good company. SSIS 2005 and 2008 do not have an XML Destination adapter. We have…