SQL Server Archive
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 make changes directly to the database and if we’re good, we remember
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 want to get Project “Crescent” running through this as well to prove
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
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
DDL Schema Change Auditing on SQL Server 2005 / 2008
Posted by paschott in SQL Server On February 8, 2010
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 make DDL changes, additions, drops in order to get their job done.
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 has tried to tie multiple co-dependent databases together within DB Pro has
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 another “opportunity” from Microsoft to work out a way to export XML