Posts tagged as:

database

Adam Machanic’s T-SQL Challenge

February 27, 2009

For you T-SQL experts out there, Adam Machanic just posted a challenge with a great prize. The best submission wins a full MSDN subscription valued at around $10,000.
Check it out!

Read the full article →

SQL Server Uniqueifier Values and the Number of the Beast

February 13, 2009

Reading Gail Shaw’s post All indexes are unique, reminded me of an interesting piece of trivia I discovered back in SQL Server 7. The error message for running out of uniqueifier values is 666.

SELECT TEXT FROM sys.messages WHERE message_id = 666

Returns:
The maximum system-generated unique value for a duplicate group was exceeded for index with partition [...]

Read the full article →

Oregon SQL Developers Meeting Tomorrow

February 10, 2009

If you are in the Portland area, you won’t want to miss the OSQL-d meeting tomorrow. We have two great sessions planned.
Wednesday, Feb 11th, 2009 at 6:30 pm (Pizza and networking start at 6:00 pm) Microsoft Portland Office – 10260 SW Greenburg Rd, Suite 600
Using SQL Server Management Studio, Intellisense, and SQL 2008 [...]

Read the full article →

FizzBuzz in T-SQL

February 3, 2009

Pinal Dave posted yesterday about how to solve the Fizz Buzz problem using T-SQL.
Definition of FizzBuzz Puzzle : Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are multiples of both [...]

Read the full article →

The Top 10 SQL Server 2008 Features for the DBA

February 2, 2009

The SQL Server Customer Advisory Team (SQLCAT) just posted a great article listing some of the best new SQL Server 2008 features for the DBA. Here they are:

Activity Monitor
SQL Server Audit
Backup Compression
Central Management Servers
Data Collector and Management Data Warehouse
Data Compression
Policy-Based Management
Predictable Performance and Concurrency
Resource Governor
Transparent Data [...]

Read the full article →

SSIS Resources

January 29, 2009

***UPDATED 2/10/2009 – Added links***
***UPDATED 2/23/2009 – Added MSDN SSIS Forum and Jeff Wharton’s link list.***
Last Thursday I gave a talk at the Oregon SQL Server Developers Professional Association and promised to post some Integration Services resources.
SSIS Best Practices
SQLCAT – Top 10 SQL Server Integration Services Best Practices
Matthew Roche – SSIS Best Practices, Part 2
Jamie  [...]

Read the full article →

SQL Server Interview Blunders

January 16, 2009

I just read Jason Massie’s new Capt. Varchar(MAX) comic. If you have spent much time interviewing SQL Server candidates I’m sure this will bring back some memories.
I was helping a company phone screens candidates for a Senior DBA position a while back. We went through such a bad string of candidates that the three of [...]

Read the full article →

SQL Server Blogs I Read

January 7, 2009

I was playing around with Google Reader and found that you can publish a list of feeds in a specific folder. I thought it might be useful to share the list of SQL Server blogs I’m subscribed to. Since the list is being pulled from Google Reader is will stay up to date as I [...]

Read the full article →

PASS Community Summit 2008 Events Calendar

November 14, 2008

The Professional Association for SQL Server Community Summit is next week. I’m will be there, presenting three exam prep sessions. This will be my first time presenting at a conference so I’m a little nervous, and very excited!
There are quite a few events happening surrounding the conference, but information is pretty spread out. I decided [...]

Read the full article →