anyone find being an sql admin boring?

Hi, I was just wondering if anyone here finds being an sql admin somewhat
boring? I am just about to finish my current sql admin contract in a few
weeks. I've been doing sql administration since last year with a string of
contracts one after the other. I just seem to be backing up, restoring,
fixing replication problems, consolidating databases, designing backup
schemes etc all day long. I just find the work mundane and routine. I have
no problems getting the work done. I am thinking of getting back into my
previous role in comms. But actually im currently doing a masters of science
in IT and am finding application development loads of fun. I use to be a
c/c++/java programmer when i first finished uni. I guess I miss the
mathematics i studied at uni and am moving back towards development (i did a
degree in electronics engineering and a degree in mathematics). Maybe its
just IT in general that i find mundane and boring. Maybe i should go to
medical school. Or maybe IT has just made me somewhat depressed :P I seem to
be doing a lot of contemplating lately hehe. No wonder im also doing some
uni courses in psychology to self assess my situation lol
JCsounds like you might enjoy .net programming against databases instead,
using VB.NET or C#. It challenges more, and the logic of it is good. it's
more fun, too, than old c or C++ because the programming IDE is much cooler.
but if you're comparing against medical school, it sounds like you've got
some bigger macro issues to address. some people don't get excited about
any job. if you're excited about something and young enough to restart, go
with what excites you.
"j.clarke" <j.clarke@.nospam.com> wrote in message
news:9BGMb.7146$xm.336889@.nasal.pacific.net.au...

quote:

---

> Hi, I was just wondering if anyone here finds being an sql admin somewhat
> boring? I am just about to finish my current sql admin contract in a few
> weeks. I've been doing sql administration since last year with a string of
> contracts one after the other. I just seem to be backing up, restoring,
> fixing replication problems, consolidating databases, designing backup
> schemes etc all day long. I just find the work mundane and routine. I have
> no problems getting the work done. I am thinking of getting back into my
> previous role in comms. But actually im currently doing a masters of

---

science

quote:

---

> in IT and am finding application development loads of fun. I use to be a
> c/c++/java programmer when i first finished uni. I guess I miss the
> mathematics i studied at uni and am moving back towards development (i did

---

a

quote:

---

> degree in electronics engineering and a degree in mathematics). Maybe its
> just IT in general that i find mundane and boring. Maybe i should go to
> medical school. Or maybe IT has just made me somewhat depressed :P I seem

---

to

quote:

---

> be doing a lot of contemplating lately hehe. No wonder im also doing some
> uni courses in psychology to self assess my situation lol
> JC
>

---

anyone find being an sql admin boring?

Hi, I was just wondering if anyone here finds being an sql admin somewhat
boring? I am just about to finish my current sql admin contract in a few
weeks. I've been doing sql administration since last year with a string of
contracts one after the other. I just seem to be backing up, restoring,
fixing replication problems, consolidating databases, designing backup
schemes etc all day long. I just find the work mundane and routine. I have
no problems getting the work done. I am thinking of getting back into my
previous role in comms. But actually im currently doing a masters of science
in IT and am finding application development loads of fun. I use to be a
c/c++/java programmer when i first finished uni. I guess I miss the
mathematics i studied at uni and am moving back towards development (i did a
degree in electronics engineering and a degree in mathematics). Maybe its
just IT in general that i find mundane and boring. Maybe i should go to
medical school. Or maybe IT has just made me somewhat depressed :P I seem to
be doing a lot of contemplating lately hehe. No wonder im also doing some
uni courses in psychology to self assess my situation lol
JCsounds like you might enjoy .net programming against databases instead,
using VB.NET or C#. It challenges more, and the logic of it is good. it's
more fun, too, than old c or C++ because the programming IDE is much cooler.
but if you're comparing against medical school, it sounds like you've got
some bigger macro issues to address. some people don't get excited about
any job. if you're excited about something and young enough to restart, go
with what excites you.
"j.clarke" <j.clarke@.nospam.com> wrote in message
news:9BGMb.7146$xm.336889@.nasal.pacific.net.au...
> Hi, I was just wondering if anyone here finds being an sql admin somewhat
> boring? I am just about to finish my current sql admin contract in a few
> weeks. I've been doing sql administration since last year with a string of
> contracts one after the other. I just seem to be backing up, restoring,
> fixing replication problems, consolidating databases, designing backup
> schemes etc all day long. I just find the work mundane and routine. I have
> no problems getting the work done. I am thinking of getting back into my
> previous role in comms. But actually im currently doing a masters of
science
> in IT and am finding application development loads of fun. I use to be a
> c/c++/java programmer when i first finished uni. I guess I miss the
> mathematics i studied at uni and am moving back towards development (i did
a
> degree in electronics engineering and a degree in mathematics). Maybe its
> just IT in general that i find mundane and boring. Maybe i should go to
> medical school. Or maybe IT has just made me somewhat depressed :P I seem
to
> be doing a lot of contemplating lately hehe. No wonder im also doing some
> uni courses in psychology to self assess my situation lol
> JC
>

Any way to run a invisible trace on Security Audit?

Is there anyway I could run an Audit trace on SQl Server which records SQL Server System Admin Login/Logout , failed login and machine names I don't want the trace window to show on screen however would like a file generated for later viewing. Also due to Firewall issues we have, We don't have SQL tools enabled to connect to that server.Yes, you can configure SQL 2000 Auditing (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2ard.asp), up through the C2 level. Unfortunately there isn't a "cookbook" approach for doing it, you really need to understand what you are doing, and the consequences and benefits of each decision.

-PatP|||I found out . Thanks for reply. C2 auditing however is not needed . I found out that from SQL Profiler , you can script the whole trace as SQL and execute it in ISQLW . This gives back a Trace ID . Next you have to run sp_trace_Setstatus @.traceID, 1 to run it .

Thanks for responding . I appreciate that

AntiVirus Software on SQL Server?

As a DBA, I was taught that running Anti-virus software on a database server
was not a very good thing to do. My network admin is planning a Windows 2000
migration and would like all machines across the domain to run AV software.
Can anyone tell me about their experience running AV software on their
database server, and whether this is a good idea or not.
The box runs SQL 6.5sp5a (soon to be 2k) and does not touch the outside
world at all.
Thanks for your help,
CurtisAs much as you may want to keep anti-virus software away
from a SQL box, you'll soon realize that that's a lost
battle. When there is a virus crisis, whatever arguments
you may have to avoid anti-virus on your SQL box, you'll
end being defeated badly.
My experience is to simply give up on avoiding virus scan
completely, and ask for the SQL files being excluded from
the virus scan. I typically ask the security folks to
exclude the following files from being scanned: *.MDF,
*.LDF, *.NDF, *.BAK, *.TRN, and *.BKP.
The primary reason you don't want anti-virus scanning is
that the virus scan software may get hold of a SQL
data/log file and prevents SQL Server from opening it,
resulting in the database being put into the suspect mode.
Usually, these data/log files are open all the time, and
therefore not an issue. But sometimes we may need to shut
down SQL Server instance or detach a database. Before we
restart SQL Server or attach the database, if the virus
software gets ahead of us, we are screwed.
There are also some issues with SQL Server running in a
cluster.
Check out: Q309422 and Q250355
Linchi
>--Original Message--
>As a DBA, I was taught that running Anti-virus software
on a database server
>was not a very good thing to do. My network admin is
planning a Windows 2000
>migration and would like all machines across the domain
to run AV software.
>Can anyone tell me about their experience running AV
software on their
>database server, and whether this is a good idea or not.
>The box runs SQL 6.5sp5a (soon to be 2k) and does not
touch the outside
>world at all.
>Thanks for your help,
>Curtis
>
>.
>