Last Rites for a Beloved Server

Humor is a hallmark of a creative mind, and SQL Server Magazine Innovator Award runner-up Michael Metcalf has discovered value in using humor in his work. When Mike was learning about SQL Server 2005 in preparation for migration, he realized that the new release was lacking one important feature: SQL Server Funeral Services (SSFS). As Mike explains, “All hard-core techies I know have an almost personal relationship with certain servers, especially ones they first cut their teeth on. This is a way to say goodbye to that now-ancient server.”

Mike says that SSFS consists of a database, a few tables and procedures, db_Mail, SQL Server Reporting Services, 1 percent inspiration, and 99 percent perspiration. “To kick off a funeral, I send an email to users who used the server most, supplying them with a procedure to run against the database. They run the procedure, including parameters such as the name of the server they’re paying respects to, a message to go in a guest book, and donation of CPU cycles to help less fortunate servers.” The procedure returns a brief eulogy, a 21-query salute, and an email message thanking them, plus a link to a Guest Book delivered in Reporting Services.

Mike admits he initially conceived the SSFS database as a fun diversion, but says he learned some cool new features of SQL Server 2005 by doing the project. Plus, he says, it’s great to “bring levity to the workplace when people are bogged down, stressed, or otherwise sucked too far into the grind, but without causing anyone harm or laughing at anyone’s expense.”

Discuss this Article 1

rpanigas@hoopp.com
on Jan 4, 2007
What a great idea!!! How abou including more details and code?

Please or Register to post comments.

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Mike Otey & Tim Ford in Person!

Early Registration Now Open

From the Blogs
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
Vision road sign
May 6, 2013
blog

Cheaters Never Win, Even in TPC Benchmarks

In this portion of the series on database benchmarking, I want to tell you about one of my favorite aspects of the TPC benchmarks – CHEATING....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.