Manage lookup data using SQL Server Data Tools (SSDT)

Posted · 1 Comment

So let’s say that you’ve managed to get your SQL Server database schemas — your tables, stored procedures, views, functions, etc — under source control using SQL Server Data Tools (SSDT) in Visual Studio.  Great.  That’s gotten you really far along towards having nice automated deployments and good DevOps practices for your application (because you […]

VSLive SF 2015: TFS Automated Build, Test, & Deploy

Posted · Add Comment

As promised, here are the slides and code samples from my Automated Build, Test & Deploy with TFS, ASP.NET, and SQL Server talk that I did today at VSLive San Francisco 2015. Here’s the abstract: Automatically building your ASP.NET code is easy. Create a TFS build and go. But what about the database code? How […]

Top 4 Reasons Why a Shared Development Database is Evil.

Posted · 5 Comments

It’s pretty common.  A development team will frequently have one instance of SQL Server — filled with data from production — that all the devs use to develop and test the next version of the application.  It’s one of those things in software development that feels like “common sense”.  Of *course* you’re going to have […]

Quoted in InfoWorld about Azure Storage

Posted · Add Comment

I got quoted in InfoWorld last week about Windows Azure Storage and how it relates to typical relational database development.  Here’s the link to the article: “Developing cloud apps: What’s different” by Paul Krill Also, if you haven’t seen it already, shortly after article came out, the SQL Server Data Services (SSDS) team announced a […]

BDC, Inc. Public Training Schedule for March & April 2009

Posted · Add Comment

After a numerous requests from potential students, I’ve finally gotten around to scheduling some open-enrollment classes here in the Boston-area.  I’m going to be teaching my Visual Studio Team System (VSTS) / Team Foundation Server (TFS) class, Test-Driven Development, and NHibernate classes in Cambridge, MA throughout March and April 2009.  Here’s the schedule: 3/23/09 – […]

Oracle For SQL Server Developers, Vol. 3

Posted · 1 Comment

Here’s another post in the Oracle For SQL Server Developers series (vol1, vol2).  The goal with this post is to help you get a feel for some common column data types in Oracle. Tip #16: Data Type Equivalents for Numbers SQL Server Oracle int NUMBER float, real NUMBER(precision, scale) In Oracle, a number can be […]