SSDT: External Database References
If your database references other databases, you’ll need a *.dacpac file for each external database referenced in your code. For example, if you reference AdventureWorksDW2008…
SSDT: SQL Project Options
To set the properties for your SQL Project, right-click the Project and select Properties. You’ll see a window containing several tabs to define your project….
SSDT: Importing an Existing Database
To Import From an Existing Database Import Database into your project by right-clicking the project name or selecting the Project Menu and selecting the Import…
SSDT: Creating a New SQL Project
Download the latest SSDT package if you do not have the product installed already: http://msdn.microsoft.com/en-us/data/tools.aspx To create a new SQL Project, you can either…
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…
Tales of a Lazy DBA–MySQL, SSIS, and “0” Dates
We’ve recently been tasked with converting a lot of MySQL Data into our system from a multi-tenant MySQL Database. We don’t have a fixed schedule…
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…