THE SQL Server Blog Spot on the Web

Welcome to - 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 3 (25 total posts)
  • Deployment of client-specific database code using SSDT

    Yesterday I attended SQL Saturday 194 in Exeter for which many people deserve credit but especially the organisers Jonathan Allen & Annette Allen and the sponsors Fusion-IO, Confio Software, Nexus, Big Bang Data Company, Purple Frog Systems, Redgate, idera, Pluralsight, Jurys Inn Exeter & Wrox.  I gave a ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 10, 2013
  • Which version of SSDT Database Projects do I have installed?

    SQL Server Data Tools (SSDT) is released on a very regular cadence (note that I’m talking about the database projects part of SSDT, this is nothing to do with SSIS/SSAS/SSRS). Since the first release in March 2012 there have been releases in September 2012, November 2012, & December 2012. I personally have found it difficult to keep track of ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 8, 2013
  • Responses to SSDT questions

    My recent article Get to Know SQL Server 2012's SQL Server Data Tools prompted two questions to come to me via email and in the interests of sharing knowledge via search engines I thought I would answer them here rather than by simply replying by email (I hate that so much useful information gets trapped inside closed inboxes). Question: How ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 11, 2013
  • Get to Know SQL Server 2012's SQL Server Data Tools [article published]

    I recently wrote an article on SQL Server Data Tools for SQL Server Magazine and it has now been published online at Get to Know SQL Server 2012's SQL Server Data Tools. In the article I offer my thoughts and opinions on SQL Server Data Tools as it exists in SQL Server 2012. Note that the article refers to SSDT database projects only, there ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 9, 2013
  • “Add as object” or “Add as script”? [SSDT]

    In SQL Server Data Tools (SSDT) one way to create a new object is to right click on a folder in Solution Explorer and point to Add. Doing so will display this menu: A number of options are offered for creating a brand new object (“function”, “table”, “stored proc” etc…) and one of them is “Script”. If your preference is to handcraft the DDL ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 4, 2013
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement