I've met a few during my time, yes.

Ha! I'm probably near the bottom of people to trust on that type of question. I never look at...

I would take any and all licensing questions direct to Microsoft. Never trust any type of licensing answer you get from some nameless, faceless individual on the internet.

A geography type consists of both latitude and longitude. You're trying to store them seperately and you can't do that.

Getting the wait statistics gives you some idea of what is causing the server to run slow, on average. To understand what is causing the server to run slow over...

I wouldn't say there are new threats beyond what we've outlined here. SQL Server 2000 is good, as far as it goes. It's just grossly inadequate on a million levels,...

To know if it's the app or the database, you need to capture performance metrics from the database as it's running. There's a lot to that. I wrote about a...

chris.dunbar (5/29/2013)

---

Lots of cheating going on it seems:-(

Having looked round this site (mostly) and done a bit extra reading, there are many functions that I don't think we utilise. A...

The DTA works off of statistics and the indexes you have in order to make calculations to arrive at possible improvements. But, understand, statistics are simply a mathematical sampling of...

If you can, yes.

I've got 32gb on...

One suggestion, get a consultant who really knows SQL Server to do the final technical interview of anyone you think might be a good fit. There are published interview questions...

All of it.

On a side note, don't rely too much on certifications. Except for the advanced certification, Microsoft Certified Master (MCM), most of the certifications are extremely straight-forward tests that people can...

It looks like the basic restore operation is set up fine. It's mainly a question of getting the connections clear before you restrict access to the database. You're going to...

SQL Server Management Studio (SSMS) is the front end for managing SQL Server. It provides two things, a graphical user interface for managing your SQL Server instances, your databases, the...