I wrote this a couple of months ago. Not Haiku but poetical SQL:-

Once upon a database,

Some tables did aface,

A view or two,

it could be true,

improve the app with grace.

If upon...

I wrote it, but have posted it on a couple other sites. It's based on the poem by Clement Clarke Moore.

The Masters is a new one for SQL Server 2008. In order to get that, you need to pass MCITP SQL Server 2008 Database Developer and MCITP SQL Server 2008...

If, by "premier" you mean highest qualification, then for SQL Server that is an MCITP. But first you have to pass the MCTS.

I've read the "MCTS SQL Server 2005: Implementation...

This is a great list. A couple of utilities that I use:-

TreeSize - shows where hard disk space is being used.

Agent Ransack - searches content of certain file types.

As always, a great article by Phil. One thing that I like is the "Question of the Day". I've been trawling through the questions for the last 8 years to...

corneld (11/5/2008)

---

I concur with: :hehe:

SSMS > Tools > Options > Query Results > SQL Server > Results to Grid > 'Include column headers when copying or saving results'

Otherwise, good effort...

Hi Dan,

That URL is an RSS XML feed, not an MP3 link. I'm not on a Mac, but think this is the link you want - http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=268045050

If not,...

Don't delete the transaction log file!

You can shrink the log file using DBCC SHRINKFILE. If that doesn't shrink sufficiently, then you can use the TRUNCATEONLY option, but that's a last...

Carla Wilson (10/31/2008)

---

Abbs (10/31/2008)

---

Once upon a nightmare query, while I pondered, weak and weary,

Over many a quaint and curious part of code,

While I nodded, nearly napping, suddenly there came a...

In my first job, I was surprised that my predecessor had single-handedly staged a socialist revolution by killing off all the Lords in the database! It was, however, a bloodles...

Once upon a nightmare query, while I pondered, weak and weary,

Over many a quaint and curious part of code,

While I nodded, nearly napping, suddenly there came a hacking,

Someone gently hacking,...

Would a production DBA necessarily know enough about the individual database to be able to de-personalise it? I guess it should be a script that the developers include as part...

I'm a little disappointed that it doesn't put key words into upper-case. Apart from that, I'm just surprised it wasn't in 2005.

I'm sometimes told that I don't like change, which sounds like a strange thing to say to someone who works in the IT industry. But change for change's sake seems...