Browse by Tags

• agile
• Continuous Integration
• DBPro
• juneau
• msbuild
• msi
• mstest
• naming conventions
• Powershell
• Security
• SQL Azure
• sql server
• SQL Server 2012
• SQL Server Data Tools
• sql server integration services
• sqlpackage.exe
• sqlserver
• SSAS
• SSDT
• ssis
• SSRS
• TDD
• Test-Driven Development
• t-sql
• unit testing
• Visual Studio
• Visual Studio 2010
• vsdbcmd.exe
• VSTS Database Edition
• wix
• XML

• 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

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

• “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”, Read More... Posted Friday, January 04, 2013 3:15 PM by jamiet | 5 Comments Filed under: sql server, Datadude, 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 | 11 Comments Filed under: sql server, Datadude, SQL Server 2012, SQL Server Data Tools, SSDT, sqlpackage.exe

• Thoughts on Test Driven Database Development

  Test-Driven Development (TDD) is a software development practise that has been around for a few years. Wikipedia describes it as: Test-driven development (TDD) is a software development process that relies on the repetition of a very short development Read More... Posted Thursday, January 26, 2012 9:30 AM by jamiet | 15 Comments Filed under: Datadude, unit testing, DBPro, Test-Driven Development, TDD, agile

• 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 Read More... Posted Sunday, January 01, 2012 7:13 PM by jamiet | 29 Comments Filed under: sql server, Datadude, Visual Studio 2010, Continuous Integration, DBPro, SSDT

• Workaround for datadude deployment bug - NullReferenceException

  I have come across a bug in Visual Studio 2010 Database Projects ( aka datadude aka DPro aka Visual Studio Database Development Tools aka Visual Studio Team Edition for Database Professionals aka Juneau aka SQL Server Data Tools ) that other people may Read More... Posted Monday, November 21, 2011 9:56 AM by jamiet | 3 Comments Filed under: Datadude, Visual Studio 2010, juneau, DBPro, SQL Server Data Tools

• Building a database installer with WiX, datadude and Visual Studio 2010

  Today I have been using Windows Installer XML (WiX) to build an installer (.msi file) that would install a SQL Server database on a server of my choosing; the source code for that database lives in datadude (a tool which you may know by one of quite a Read More... Posted Thursday, February 10, 2011 10:45 PM by jamiet | 20 Comments Filed under: VSTS Database Edition, Datadude, Visual Studio 2010, sqlserver, vsdbcmd.exe, msi, wix

• Generate multiple SqlCmdVars files in your database projects

  Earlier today I was doing a little work using datadude/DBPro/Visual Studio Database Tools/pick your name and had a need to write a Powershell script that I think might be useful to other folks so I’m sharing it here. Often when you’re putting together Read More... Posted Wednesday, January 19, 2011 9:24 PM by jamiet | 5 Comments Filed under: sql server, Datadude, Powershell

• Querying Visual Studio project files using T-SQL and Powershell

  Earlier today I had a need to get some information out of a Visual Studio project file and in this blog post I’m going to share a couple of ways of going about that because I’m pretty sure I won’t be the only person that ever wants to do this. The specific Read More... Posted Monday, January 17, 2011 10:11 PM by jamiet | 4 Comments Filed under: t-sql, Datadude, XML, Visual Studio, Powershell

• Maintaining version history in your database using Visual Studio 2010

  I have written a few blogs lately explaining how my current project is employing the use of datadude (aka the database development tools in Visual Studio 2010) in order to manage our database code, deployment of that code and also testing of it. In this Read More... Posted Tuesday, October 19, 2010 9:26 PM by jamiet | 4 Comments Filed under: t-sql, sql server, Datadude, Visual Studio 2010

• Enforcing naming conventions using database unit testing

  My naming convention obsession Anyone that has ever worked with me will tell you that I am a stickler for naming conventions. I have a somewhat obsessive reputation for it; I can’t help it – I seem to have a deep seated uncontrollable desire to ensure Read More... Posted Wednesday, October 06, 2010 12:42 AM by jamiet | 6 Comments Filed under: sql server, Datadude, unit testing, naming conventions

• Experiences from writing sp_CascadingDataViewer – DB unit testing and code distribution

  Its now been a month since I introduced sp_CascadingDataViewer and I wanted to take the opportunity to talk about a couple of my experiences while writing it.   SQL Server needs packages Version 1 of sp_CascadingDataViewer is an 899 line stored procedure Read More... Posted Saturday, September 18, 2010 6:41 PM by jamiet | 3 Comments Filed under: sql server, Datadude, Visual Studio 2010, unit testing