SQL Implementations

GhostlyPea

GhostlyPea

GhostlyPea

Soldato
Joined
30 Dec 2004
Posts
4,681
Location
Bromley, Kent
How many of you at work implement and manage some sort of SQL system? I don't mean writing queries or table design etc. just management.

Cheers Guys/Gals

- Pea0n
 
Lots.

Many products use SQL back ends these days from Backup to Web Filtering.

It's all pretty straightforward from a management point of view tbh. Starts getting more complex as you scale it up and performance becomes an issue.

Walking onto client sites and needing to work out SQL SA passwords my favorite command comes into play:

osql -U sa

\o/ :D
 
Last edited:
Aye, most of our clients use SQL in some form or another, just wondering whether its worth studying 70-431 (SQL) rather than Exchange module as the last one for my MCSE.

- Pea0n
 
I would personally do Exchange over SQL.

Larger likelihood of working with Exchange than SQL. SQL is pretty resilient. Backing it up and restoring to it is cake. Took me 30 seconds in the 2005 Manager to work it out having never touched it before.

Is it a 2003 or 2007 Exchange exam, if its the latter then do the Exchange course. It has changed significantly whereas SQL really has not (at least as far as my knowledge expands)

Perhaps some of the guys who deal far more in SQL can advise some.
 
Do exchange and SQL, it sounds like you have something to learn from both and really the extra knowledge wont do you any harm

Good luck with whichever you choose
 
I use both. We use NetApp SnapManger tools for backup it up, it normally takes around 30 seconds to take a full back of the DB and Logs. However, it takes a little longer to verify it.

Id personally choose Exchange over SQL, as its more of a widely used product. However, thats just IMO.

Andy
 
Do lots of SQL management every day. I personally hate SQL so I try leave it to other people as much as possible :p
 
You must log in or register to reply here.
Back
Top Bottom