— New online course!  Azure App Services & App Service Security with ASP.NET Core — Special launch price 50% off —
Posts Currently viewing the tag: "SQL Server"

I ran into a really weird problem on one of my machines while trying to connect to SQL Server using SqlCmd. SqlCmd commands have been running just fine on all my machine for month if not years and suddenly on just one machine, SqlCmd commands started failing with the following error: Sqlcmd: Error: Microsoft ODBC…(Read More)

I’d like to introduce some utilities that I wrote to help SQL Server developers that I’m calling “Shovel”. You can install it by going to the Microsoft Store or by downloading a ZIP. In version 1, there are two collections of features: Database Schema Search and Data Export. I’ve created a couple…(Read More)

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)