Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
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:
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:
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, 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: ,
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: ,
Tuesday, November 25, 2008 7:03 PM

Application & Multi-Server Management

@ the SQL PASS Summit on 11/20 we announced our plans to release new capabilities for improving the collaboration between Data-Tier Developers and DBA and to address Multi-Server (or multi-instance) manageability for SQL Server. Anthony Carrabino has
Posted by dtjones | 0 Comments
Sunday, November 23, 2008 9:54 AM

Scripting DBA Actions

Last Thursday morning @ the PASS Summit I participated in a panel discussion on automating DBA tasks. It was a great discussion and I was humbled by the other panel members. During the discussion I jotted down a few notes that I didn’t get to mention
Posted by dtjones | 4 Comments
Filed under: ,
Saturday, November 01, 2008 1:22 PM

SQL PASS Summit

SQL Pass is coming up this month, November 18-21 @ the Washington State Convention Center. You can find details here . Aside from the multitude of sessions covering SQL Server there are a couple fun and interesting things that I’ll call your attention
Posted by dtjones | 2 Comments
Filed under: ,
Wednesday, October 15, 2008 8:24 AM

SQLH2 on CodePlex

The SQL Server Health & History tool, also known as SQLH2, has been posted on CodePlex. You can find the project home page here . SQLH2 is the precursor to the Data Collector feature added in SQL2K8.
Posted by dtjones | 2 Comments
Filed under:
Monday, September 15, 2008 6:59 PM

Blogapoluzza

The list of blogs run by the SQL Server product group keeps growing. Here I offer merely a snapshot in time of the current blogs. At the bottom there's also two links that list blogs by MS employees and SQL Server MVPs; these are not complete but offer
Posted by dtjones | 3 Comments
Filed under: ,
Monday, June 30, 2008 10:40 AM

Guarding Against SQL Injection

Securing the database is only part of the security equation, a very important part, but still not the entire picture. DBAs need to educate their developer counterparts on developing secure applications which access the data tier. I would go as far as
Posted by dtjones | 1 Comments
Friday, June 13, 2008 1:44 PM

TechEd 2008 is Done!

I'm writing this on the plane from Orlando back to Seattle. I have lots of thoughts on TechEd that I'll try to get through before I run out of battery or the guy in front of me snaps my laptop display. I also want to answer a few of the questions that
Posted by dtjones | 0 Comments
Saturday, March 01, 2008 11:10 AM

New Podcast for the Real-world DBA

Buck Woody, a PM on my team, has launched a new weekly Podcast entitled "Real-World DBA". You can find out more information at his Blog . Here's a link to the first episode . I encourage you to take a listen and provide feedback. This is not a marketing
Posted by dtjones | 0 Comments
Filed under: ,
Friday, January 11, 2008 11:01 PM

Getting Your "Favorite" SQL Server Bug Fixed

As a PM in SQL Server I read through just about every bug entered for the components my team owns. Given the surface area of what my team owns this translates into a lot of bugs. I don't characterize it that way to disrespect the team or the quality of
Posted by dtjones | 10 Comments
 
Page view tracker