THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » SSDT   (RSS)
Showing page 2 of 2 (20 total posts)
  • 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: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 1 The ALTER TABLE ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 3, 2013
  • 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 Tools. This release incorporates a an updated version of the SQL Server Data Tier Application ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 16, 2012
  • 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 and script that table out: you see this: ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 19, 2012
  • 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 scripts and that is exactly what we are doing. Our requirement is a little different though, our ...
    Posted to Jamie Thomson (Weblog) by jamiet on June 11, 2012
  • 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 adding a NOT NULLable column to an existing table that has got data in it – previous to SSDT you ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 31, 2012
  • 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 with SQL Server Development Tools (SSDT) in SQL Server 2012 and its main purpose (amongst other ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 30, 2012
  • 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 MSDN for an article that explains Publish Profile files but it seems no such article exists so ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 8, 2012
  • 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 was to make the venerable Northwind database available too so I am pleased to say that ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 10, 2012
  • 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 desired behaviour. Hence why yesterday I submitted the following suggestion to ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 12, 2012
  • Implementing SQL Server solutions using Visual Studio 2010 Database Projects – a compendium of project experiences

    Over the past eighteen months I have worked on four separate projects for customers that wanted to make use of Visual Studio 2010 Database projects to manage their database schema.* All the while I have been trying to take lots of notes in order that I can write the blog post that you are reading right now – a compendium of experiences and tips ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 1, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement