Browse by Tags

• AdventureWorks on Azure
• Continuous Integration
• Dac Framework
• DacFX
• dacpac
• 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

• Dacpac braindump - What is a dacpac?

  In this week’s earlier blog post First release of my own personal T-SQL code library on Github I talked of how one could use a dacpac to distribute a bunch of code to different servers. Upon reading the blog post Jonathan Allen (of SQL Saturday Exeter Read More... Posted Saturday, January 18, 2014 11:31 PM by jamiet | 2 Comments Filed under: Dac Framework, DacFX, dacpac, sql server, SSDT

• Schema Compare or Publish [SSDT]

  Yesterday on Twitter Ryan Desmond asked Is there a good read for # SSDT regarding deploying changes via schema compare vs solution deployment? I don’t know of any article that covers this so in this blog post I offer my opinion on the subject. First some Read More... Posted Thursday, December 19, 2013 9:11 AM by jamiet | 5 Comments Filed under: sql server, SSDT

• Don’t learn SSDT, learn about your databases instead

  Last Thursday I presented my session “Introduction to SSDT” at the SQL Supper event held at the offices of 7 Digital (loved the samosas, guys). I did my usual spiel, tour of the IDE, connected development, declarative database development yadda yadda Read More... Posted Monday, November 11, 2013 6:45 PM by jamiet | 5 Comments Filed under: SSDT

• SSDT gotcha – Moving a file erases code analysis suppressions

  I discovered a little wrinkle in SSDT today that is worth knowing about if you are managing your database schemas using SSDT. In short, if a file is moved to a different folder in the project then any code analysis suppressions that reference that file Read More... Posted Thursday, October 10, 2013 6:42 PM by jamiet | 3 Comments Filed under: SQL Server Data Tools, SSDT

• Learn from me about SSDT in London, March 2014

  Microsoft released SQL Server Data Tools (SSDT) along with SQL Server 2012 in the Spring of 2012. Since then I’ve noticed an upward tick in both the number of organisations that are using SSDT and the number of questions that are getting asked about it Read More... Posted Thursday, September 05, 2013 9:01 AM by jamiet | 0 Comments Filed under: SQL Server Data Tools, SSDT

• June 2013 release of SSDT contains a minor bug that you should be aware of

  I have discovered what seems, to me, like a bug in the June 2013 release of SSDT and given the problems that it created yesterday on my current gig I thought it prudent to write this blog post to inform people of it. I’ve built a very simple SSDT project Read More... Posted Monday, July 01, 2013 8:54 AM by jamiet | 15 Comments Filed under: sql server, SQL Server Data Tools, SSDT

• Creating your own SQL snippets in SSDT

  SQL Server Data Tools (SSDT) has a neat feature where you can add snippets into your scripts via the right-click context menu: I’m finding it very useful indeed. The same feature exists in SQL Server Management Studio (SSMS) as well by the way: One thing Read More... Posted Monday, April 22, 2013 11:33 PM by jamiet | 1 Comments Filed under: SQL Server Data Tools, SSDT

• Detecting Database Drift using SSDT

  One of the nice things about doing user group presentations is that when you’re putting the presentation together you invariably learn about features that were previously unbeknown to you; so it proved as I stumbled upon SSDT’s database drift detection Read More... Posted Thursday, April 04, 2013 11:31 AM by jamiet | 5 Comments Filed under: Database Drift, SQL Server Data Tools, SSDT

• SSDT naming confusion cleared up. Somewhat.

  In March 2012 I published SSDT - What's in a name? where I lamented the mistakes that Microsoft made in the naming of SQL Server Data Tools. …official documentation stating that SSDT includes all the stuff for building SSIS/SSAS/SSRS solutions (this is Read More... Posted Wednesday, April 03, 2013 9:49 AM by jamiet | 5 Comments Filed under: SQL Server Data Tools, SSDT

• Considerations when starting a new SSDT database project

  As you may have realised from much of my blogging over the past year or so I’m an advocate of using SSDT database projects for building database solutions on SQL Server. I have been using SSDT database projects a lot in that time and have come up with Read More... Posted Thursday, March 21, 2013 12:58 PM by jamiet | 12 Comments Filed under: Datadude, SQL Server Data Tools, SSDT

• Connected development in SSDT versus SSMS

  When you install the database projects template of SSDT you get SQL Server Object Explorer (SSOX) installed as well. SSOX is a pane within Visual Studio and is the main enabler of the Connected Development experience that the SSDT team have attempted Read More... Posted Tuesday, March 19, 2013 6:28 PM by jamiet | 11 Comments Filed under: sql server, SQL Server 2012, SQL Server Data Tools, SQL Server Object Explorer, SSDT, SSOX, Visual Studio

• 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 , Read More... Posted Sunday, March 10, 2013 3:24 PM by jamiet | 14 Comments Filed under: sql server, SQL Server Data Tools, SSDT

• SSDT database projects were not always going to output T-SQL…

  Interesting the stuff you pick up from reading forums… “The BATCH seperators [in SSDT deployment scripts] are used to provide scoping when resolving object shapes. SSDT or VSDB scripts for that matter serve a different purpose, they provide the blueprint Read More... Posted Wednesday, February 13, 2013 10:15 AM by jamiet | 5 Comments Filed under: Datadude, SSDT

• 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 Read More... Posted Friday, February 08, 2013 10:15 PM by jamiet | 2 Comments Filed under: Datadude, sql server, SQL Server Data Tools, SSDT

• Video accompanying my SSDT article is now available

  A couple of weeks ago in Get to Know SQL Server 2012's SQL Server Data Tools [article published] I stated that an article that I wrote about SSDT had been published and was available for reading online at http://www.devproconnections.com/ . The article Read More... Posted Tuesday, January 29, 2013 12:52 AM by jamiet | 0 Comments Filed under: SQL Server Data Tools, SSDT, video