Author Archive
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 -> Database option. Note that you can also import from SQL Scripts
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 start by creating a new Project or create a new project from
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
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 to actually execute the imports because they’ll be on a “per customer”
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
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
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
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
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
(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