Posts Currently viewing the tag: "SQL Server"

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…(Read More)

As promised, here are the slides and code samples from the Real World SQL Server Data Tools (SSDT) talk that I did this week at VSLive Orlando 2015. Here’s the abstract: SQL Server Data Tools (SSDT) help you manage your database schemas and let you do it under source control.  Great.  Got it.  But…(Read More)

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…(Read More)

Are you a big user of the SQL Server database projects?  You know…what used to be known as ”data dude”?  Did you get way into doing command line deployments of your databases using vsdbcmd.exe?  Well, if you are one of those developers and you’ve upgraded to the latest version…(Read More)

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…(Read More)

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…(Read More)

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…(Read More)

Picking up where I left off in my previous “Oracle for SQL Server Developers” posts (one, two, three)… In SQL Server, we commonly have a primary key column that is a integer and this number gets incremented, created, and inserted automatically by the database. This is a SQL Server identity column and it makes our…(Read More)

I spoke at VSLive Dallas 2008 last week.  Here are my slides. Win and Web Installers with WiX code, slides, more  Windows Azure Tour code, slides Architect Applications End-to-End with LINQ to SQL code, slides Visual Studio Team System Web Testing slides, code/discussion -Ben — Want to run one of these talks at…(Read More)

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…(Read More)