Best Practice: Naming Constraints

Within SQL Server there are a number of different types of constraints: CHECK DEFAULT FOREIGN KEY PRIMARY KEY UNIQUE The reference for CREATE TABLE can be found here. Now what’s interesting about constraints is when creating a constraint the name is optional. If you don’t provide a name the system will provide one for you….


Developing Data-tier Applications Using Visual Studio 2010

Check out this rocking video of Sanjay Nagamangalam demoing the Data-tier Application functionality within Visual Studio 2010. Sanjay is a GPM on the SQL Server team. Sanjay has sessions at SQL PASS and PDC.

PDC Session on the Data-tier Application Component

Are you going to this year’s PDC? Are you still on the fence? There’s a very cool session @ PDC on the data-tier application component called “Simplifying Application Packaging and Deployment with SQL Server 2008 R2”. Yes, that’s probably one of the longest session titles ever. Omri Bahat, a PM on my team, recently sat…

Perfect Conference Storm

November is shaping up to be the perfect storm of conferences. In a time when budgets are extremely tight it amazes me that we have 4 conferences to cover in November.   SQL PASS When: November 2-5, 2009 Where: Seattle, Washington Site: Sessions: 2 focused on SQL Server 2008 R2/Visual Studio 2010 SQL Connections…

PBM – it’s like liquid awesome!

Brent Ozar and Thomas LaRock do a 3 part video series on the power of Policy-based Management (PBM). Interestingly SCOM comes up several times in the discussion.   They cover the basics of PBM and Thomas goes into more depth on how he’s using it in his environment. The series is about 35 minutes in…

SQL Server 2008 R2 August CTP: Utility Bug

The August CTP of SQL Server 2008 R2 contains a bug in Management Studio when connected to a Control Point. You can find the details here:

SQL Server Web Developer Survey

The Microsoft SQL Server product team is undertaking a short survey to help guide potential new features and capabilities for web developers, please take a few minutes to take the survey and help shape the future of SQL Server. The survey will run for about a week (closing on 6/17 or there about) so don’t…

PCI Compliance and SQL Server 2008

Today compliance is a huge focus area for IT. Since compliance is written by lawyers for lawyers it takes a fair amount of translation to get it to the point where IT can understand what processes, policies, and configuration to implement to meet the requirements for a given compliance spec. If you are a SQL…


Using PowerShell to Get Data & Log File Sizes

I was playing around with PowerShell today (yes I’m was geeking out on Saturday afternoon) to learn how to access Performance Counters using PowerShell. My mission was to write a script that would return the Data File and Log File sizes for each database and a total for the instance. The good news is SQL…


Up & Running on Win7

Rock and Roll! Yesterday I did a clean install of Win7 x64 Beta on my Lenovo x301. Setup was fast and completed without any issues. In fact it had no problem with the SATA drive set in AHCI mode. The Vista RTM install couldn’t handle that. I had to use a custom driver or switch…