Heaven forbid that you should leave it up to the application developers. They'll design you a database that makes a DBA job a nightmare! And there are people...

Clive,

They didn't introduce just one new cert. They introduced 4 of them. @=) All new SQL Server 2005 certification information can be found at the following link:

http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx

Hope this...

If you've been a DBA for 8 years already, go for the MCITP instead (SQL 2005 -and possibly 2008- certs). It'll look much better on your job history. ...

Glad we could help. @=)

The best thing you can do for yourself, Jigisha, is practice, practice, practice.

There are still a lot of shops which use SQL Server 2000, which might make it worth your...

Chethan,

I doubt it's an appended backup issue. Media families usually refer to the media the backup is stored on. I.E., tape, UNC disk drive, local disk drive.

Unless you've...

HTTP Endpoints are much more secure. You can actually dictate the type of traffic you get and, I believe, the network protocol used to access it.

Not to mention you...

I had originally heard February, but that was like 6 months ago, so I'm not surprised my info is out of date. @=)

I don't know about demos. Some are good, some are bad. But most of them are canned. Which means the demonstrator is going to show you all...

In addition to Security (and the auditing available with DDL triggers), the main reasons I would add are SSIS, Solution Explorer, Database Mirroring and Snapshots.

DM & Snapshots are wonderful...

Are you working in 2000 or 2005?

You posted to the 2k5 forum, but EM is a 2000 tool and in 2k5 you not supposed to be able to...

First, go into your SQL Server Configuration Manager and verify that NONE of your services are running under the Built-In Administrators account. It doesn't have to be the SQL...

All, I'm glad my article is generating such positive responses. For those currently going a similar Non-IT to DBA route, I hope my experiences help you along the way.

Nadeem7971,...

Hey, Jorg, the article Steve pointed out also has info on the 446 exam. You might want to check it out.

You can also use SUM(ISNULL(Quantity,0)) to do something similar. The difference is that ISNULL simply replaces any NULL values with zero instead of looking for the first non-NULL value.