Posts tagged as:

SQL

Oregon SQL Developers – April Meeting

April 7, 2009

Please join me at the Oregon SQL Developers Meeting, tomorrow, April 8th. Free pizza, lots of giveaways, and 2 great sessions planned. Many people will walk away with either a TechNet Plus Direct annual subscription (Estimated Retail Value $349), or a voucher for a Microsoft Certification exam of your choice (Estimated Retail Value $125). Logistics: […]

Read the full article →

Who Should Write Database Code?

March 20, 2009

This week, I ran into a query that did 770 GB worth of logical reads…on a 3 GB database!!! Kimberly Tripp asked “Who’s job is it anyway?” Should database design and database coding be done by the Application Developer, the DBA, or should there be a separate “Database Developer” role? There are many variables that […]

Read the full article →

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 […]

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 […]

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 […]

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 – […]

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 […]

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 →