Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Thursday, October 29, 2009 8:01 AM

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
Posted by dtjones | 0 Comments
Filed under:
Tuesday, October 27, 2009 10:04 PM

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.
Posted by dtjones | 0 Comments
Wednesday, October 21, 2009 4:53 PM

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
Posted by dtjones | 0 Comments
Saturday, September 19, 2009 7:24 AM

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: http://summit2009.sqlpass.org/
Posted by dtjones | 0 Comments
Sunday, August 30, 2009 10:20 AM

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
Posted by dtjones | 0 Comments
Saturday, August 22, 2009 11:53 AM

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: http://social.msdn.microsoft.com/Forums/en-US/sqlkjappmsmgmt/thread/03506a9b-e9b1-4d77-a3e1-28627e8f4867
Posted by dtjones | 0 Comments
Wednesday, June 10, 2009 10:15 AM

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
Posted by dtjones | 0 Comments
Filed under:
Sunday, April 19, 2009 5:22 PM

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
Posted by dtjones | 1 Comments
Filed under: ,
Saturday, March 21, 2009 2:42 PM

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
Posted by dtjones | 3 Comments
Tuesday, January 13, 2009 7:13 PM

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
Posted by dtjones | 1 Comments
Filed under: ,
Saturday, January 10, 2009 4:38 PM

What Has 2 Thumbs & Is Excited About Windows 7?

Answer: This guy! I’ve been following very closely the press and reviews on the early peaks of Windows 7. I’m not as big of a Vista hater as some people out there. In fact I like the OS. I recently had to reinstall XP on another machine and was absolutely
Posted by dtjones | 3 Comments
Filed under: , ,
Saturday, January 03, 2009 1:53 PM

Vista Parental Controls Slows Down Zune Marketplace

I’m a huge fan of my Zune and the Zune Marketplace. I have a Zune and my two daughters do as well. I’ve owned several iPods but I just love my Zune more; especially the subscription option for music. $15/month for all the music I want is fantastic. Yes,
Posted by dtjones | 3 Comments
Filed under: , ,
Tuesday, December 16, 2008 11:08 PM

What’s In Your Database?

How many different database objects are there? I don’t know the answer either but off the top of my head I’d guess somewhere between 50 and 100, depending on how you count them. Yes, I could go count them but I’m writing this on a Saturday and between
Posted by dtjones | 3 Comments
Filed under: ,
Sunday, December 07, 2008 9:34 AM

Getting Started in the Community

As an under-grad student @ Cal Poly San Luis Obispo, some 18 years ago, I first experienced the power of the technical community. I was working on a group project to build a little app for the Mac. The class was Software Engineering, CSC440, which covers
Posted by dtjones | 1 Comments
Filed under:
Thursday, December 04, 2008 2:36 PM

Register for the SQL Server Application and Multi-Server Management Private CTP!

As you probably heard, on Wednesday, November 19th, during Ted Kummert's keynote at the PASS Summit Conference, Microsoft announced future capabilities for application and multi-server management as part of the SQL Server code-name "Kilimanjaro"
Posted by dtjones | 3 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker