Browse by Tags

• AdventureWorks on Azure
• Continuous Integration
• DacFX
• Database Drift
• Datadude
• DBPro
• Deployment
• msbuild
• MSBuild Extension Pack
• Publish Profile Files
• SQL Azure
• sql server
• SQL Server 2012
• SQL Server Data Tools
• SQL Server Object Explorer
• SQLBits
• SQLCMD
• sqlpackage.exe
• SSOX
• TFS
• t-sql
• unit testing
• video
• Visual Studio
• Visual Studio 2010
• Windows Azure
• Windows Azure SQL Database
• XPath

• Warning! Publish may fail on creation of a FOREIGN KEY constraint and then immediately succeed [SSDT]

  I have stumbled across a nuance of SSDT that other users should be cognizant of. I published an SSDT database project onto an existing database that already had data in it but that Publish operation failed: The error message was: (10036,1): SQL72014: Read More... Posted Thursday, January 03, 2013 1:15 PM by jamiet | 0 Comments Filed under: sql server, SSDT

• Database unit testing is now available for SSDT

  Good news was announced yesterday for those that are using SSDT and want to write unit tests, unit testing functionality is now available. The announcement was made on the SSDT team blog in post Available Today: SSDT—December 2012 . Here are a few thoughts Read More... Posted Friday, December 14, 2012 1:47 PM by jamiet | 4 Comments Filed under: unit testing, SSDT

• Editing sqlcmdvariable nodes in SSDT Publish Profile files using msbuild

  Publish profile files are a new feature of SSDT database projects that enable you to package up all environment-specific properties into a single file for use at publish time; I have written about them before at Publish Profile Files in SQL Server Data Read More... Posted Monday, December 10, 2012 2:42 PM by jamiet | 1 Comments Filed under: msbuild, MSBuild Extension Pack, XPath, SSDT

• Big label generator

  Sometimes I write blog posts mainly so that I can find stuff when I need it later. This is such a blog post. Of late I have been writing lots of deployment scripts and I am fan of putting big labels into deployment scripts (which, these days, reside in Read More... Posted Wednesday, September 26, 2012 2:45 PM by jamiet | 4 Comments Filed under: SQL Server Data Tools, SSDT

• Highlight Word add-in for Visual Studio 2010 [SSDT]

  I’ve just been alerted by my colleague Kyle Harvie to a Visual Studio 2010 add-in that should prove very useful if you are an SSDT user. Its simply called Highlight all occurrences of selected word and does exactly what it says on the tin, you highlight Read More... Posted Wednesday, September 19, 2012 1:56 PM by jamiet | 2 Comments Filed under: Visual Studio, SQL Server Data Tools, SSDT

• New version of SQL Server Data Tools is now available

  If you don’t follow the SQL Server Data Tools (SSDT) blog then you may not know that two days ago an updated version of SSDT was released ( and by SSDT I mean the database projects, not the SSIS/SSRS/SSAS stuff ) along with a new version of the SSDT Power Read More... Posted Monday, September 17, 2012 12:03 AM by jamiet | 0 Comments Filed under: sql server, SQL Server Data Tools, SSDT, DacFX

• CASTs become CONVERTs in computed columns with implications for SSDT

  I discovered a peculiar little nuance in SQL Server yesterday that I think is worth sharing. Execute the following CREATE TABLE statement: CREATE TABLE _t ( c INT , [S_Profit] AS ( CAST ( 1 AS DECIMAL ( 19 , 6 ))) ); If you then go to Object Explorer Read More... Posted Thursday, July 19, 2012 12:03 PM by jamiet | 3 Comments Filed under: sql server, SSDT

• Bitmask data insertions in SSDT Post-Deployment scripts

  On my current project we are using SQL Server Data Tools (SSDT) to manage our database schema and one of the tasks we need to do often is insert data into that schema once deployed; the typical method employed to do this is to leverage Post-Deployment Read More... Posted Monday, June 11, 2012 12:11 PM by jamiet | 0 Comments Filed under: t-sql, sql server, SQL Server Data Tools, SSDT, SQLCMD

• Smart defaults [SSDT]

  I’ve just discovered a new, somewhat hidden, feature in SSDT that I didn’t know about and figured it would be worth highlighting here because I’ll bet not many others know it either; the feature is called Smart Defaults. It gets around the problem of Read More... Posted Thursday, May 31, 2012 12:55 PM by jamiet | 2 Comments Filed under: sql server, SQL Server Data Tools, SSDT

• Redistribution of sqlpackage.exe [SSDT]

  This is a short note for anyone that may be interested in redistributing sqlpackage.exe. If this isn’t you then no need to keep reading. Ostensibly this is here for anyone that bingles for this information. sqlpackage.exe is a command-line that ships Read More... Posted Wednesday, May 30, 2012 4:15 PM by jamiet | 1 Comments Filed under: sql server, SQL Server Data Tools, SSDT, sqlpackage.exe

• Publish Profile Files in SQL Server Data Tools (SSDT)

  I have been using SQL Server Data Tools (SSDT) both at work and on some hobby projects for quite a few weeks now and of all the new features I have to say the one that I am appreciating the most is Publish Profile files. I have been searching around on Read More... Posted Wednesday, May 09, 2012 12:07 AM by jamiet | 9 Comments Filed under: sql server, SQL Server 2012, SQL Server Data Tools, SSDT, Deployment, Publish Profile Files

• Folders in SQL Server Data Tools

  Recently I have begun a new project in which I am using SQL Server Data Tools (SSDT) and SQL Server Integration Services (SSIS) 2012. Although I have been using SSDT & SSIS fairly extensively while SQL Server 2012 was in the beta phase I usually find Read More... Posted Sunday, April 15, 2012 4:35 PM by jamiet | 8 Comments Filed under: SQL Server 2012, SQL Server Data Tools, SSDT

• Northwind now available on SQL Azure

  Two weeks ago I made available a copy of [AdventureWorks2012] on SQL Azure and published credentials so that anyone from the SQL community could connect up and experience SQL Azure, probably for the first time. One of the (somewhat) popular requests thereafter Read More... Posted Tuesday, April 10, 2012 11:08 PM by jamiet | 5 Comments Filed under: sql server, SQL Azure, SSDT, AdventureWorks on Azure

• SSDT - What's in a name?

  SQL Server Data Tools (SSDT) recently got released as part of SQL Server 2012 and depending on who you believe it can be described as either: a suite of tools for building SQL Server database solutions or a suite of tools for building SQL Server database, Read More... Posted Tuesday, April 03, 2012 2:44 PM by jamiet | 17 Comments Filed under: SQL Server Data Tools, SSDT

• SQL Server Data Tools does support required variables

  Over the past few years of using datadude (aka DBPro aka Visual Studio Database Projects) I have fallen prey to a peculiar little nuance – if you forget to supply a value for a sqlcmd variable then it will simply use a default and often that is not the Read More... Posted Sunday, February 12, 2012 12:58 PM by jamiet | 9 Comments Filed under: sql server, Datadude, SQL Server 2012, SQL Server Data Tools, SSDT, sqlpackage.exe