Browse by Tags

• Continuous Integration
• DacFX
• Database Drift
• Datadude
• DBPro
• Deployment
• juneau
• Publish Profile Files
• SQL Azure
• sql server
• SQL Server 2012
• SQL Server Object Explorer
• SQLCMD
• sqlpackage.exe
• SSDT
• SSOX
• TFS
• t-sql
• video
• Visual Studio
• Visual Studio 2010
• Windows Azure
• Windows Azure SQL Database

• 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 | 2 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 | 3 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 | 5 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 | 6 Comments Filed under: sql server, SQL Server Data Tools, 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

• Continuous deployment of SSDT database projects to Windows Azure using Team Foundation Service

  Continuous deployment is described by Wikipedia as: Most CI systems allow the running of scripts after a build finishes. In most situations, it is possible to write a script to deploy the application to a live test server that everyone can look at. A Read More... Posted Sunday, January 27, 2013 9:07 PM by jamiet | 11 Comments Filed under: Continuous Integration, SQL Azure, SQL Server Data Tools, SSDT, TFS, Windows Azure, Windows Azure SQL Database

• More SSDT naming confusion

  I have blogged previously at SSDT – What’s in a name? about the naming confusion that Microsoft have created by their inconsistent use of the term “SQL Server Data Tools” (SSDT) in SQL Server 2012. Is it a Visual Studio shell incorporating project templates Read More... Posted Wednesday, January 16, 2013 11:05 PM by jamiet | 10 Comments Filed under: SQL Server Data Tools, SSDT

• 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 Read More... Posted Friday, January 11, 2013 11:22 PM by jamiet | 1 Comments Filed under: Datadude, sql server, SQL Server Data Tools, SSDT

• 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 Read More... Posted Thursday, January 10, 2013 12:12 AM by jamiet | 2 Comments Filed under: sql server, SQL Server Data Tools, 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: SQL Server Data Tools, SSDT, Visual Studio

• 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: DacFX, sql server, SQL Server Data Tools, SSDT