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 find out which SP is updating data in a specific table?

Can you create an UPDATE TRIGGER and use some type
of code to figure out which SP just updated the current table?

If not how can i achieve what i want?

I tried to run SQL Profiler and i don't understand why i can't
simply have the Profiler filter events only for the specific database id
and the table's object id i chose?

What am i doing wrong with SQL Profiler? I was testing this
through SQL EM. I had the filters chosen for a specific database id
and a specific table's object id, yet when i open another table SQL
Profiler captures that information too.

Thank youIn a correct design, why would it matter? The event or conditions
rather than the agent should be what is important. Do not think in
terms of HOW, but in terms of WHAT.|||serge (sergea@.nospam.ehmail.com) writes:
> Can you create an UPDATE TRIGGER and use some type
> of code to figure out which SP just updated the current table?

No. At least not without changing all stored procedure to write their
name somewhere. That can be done in a general way, as the global variable
@.@.procid holds the object id of the currently executing SQL module.
But there is no way to get the entire call stack. Definitely a missing
a feature in SQL Server.

> I tried to run SQL Profiler and i don't understand why i can't
> simply have the Profiler filter events only for the specific database id
> and the table's object id i chose?

The problem with Profiler is that if there are entries that do not
populate the columns you filter on, the NULL values pass the filter
and give you a lot of noise.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Any tutorials (confused!)

Hi,
I'm new to this reporting services technology, but done a far bit of C#
and web services. In the current system I work on we have a complex
typed dataset which I want to use as the source for a reporting
services report.
using c#, can you let me know if the following is possible and point me
in a direction;
Populate the typed dataset in the main c# application.
Call reporting services, passing in this dataset (or XML) as a
parameter
All I've done with reporting services so far is to create a static
report and render this as a PDF and output the result to a physical
file on the local hard drive.
Many thanks
MatMat, have a look at www.gotreportviewer.com
HTH,
Ed
<matpublic@.ntlworld.com> wrote in message
news:1140550512.461086.100440@.g44g2000cwa.googlegroups.com...
> Hi,
> I'm new to this reporting services technology, but done a far bit of C#
> and web services. In the current system I work on we have a complex
> typed dataset which I want to use as the source for a reporting
> services report.
> using c#, can you let me know if the following is possible and point me
> in a direction;
> Populate the typed dataset in the main c# application.
> Call reporting services, passing in this dataset (or XML) as a
> parameter
> All I've done with reporting services so far is to create a static
> report and render this as a PDF and output the result to a physical
> file on the local hard drive.
> Many thanks
> Mat
>

any stored procedure to report all the databases' information

Hello everyone,
We're going to migrate our SQL 2000 server from one domain to another. I
need to get a better idea of how our current databases are structured and
utilized. What I want is a report showing each database's:
name
data size
log size
users
if backed up or not
Before I dive into it in my own way, just wondering if there is any stored
procedure that can help collect the above information? I'd appreciate any
help.
Thanks,
Bing
sp_helpdb does most what I wanted.
"bing" wrote:

> Hello everyone,
> We're going to migrate our SQL 2000 server from one domain to another. I
> need to get a better idea of how our current databases are structured and
> utilized. What I want is a report showing each database's:
> name
> data size
> log size
> users
> if backed up or not
> Before I dive into it in my own way, just wondering if there is any stored
> procedure that can help collect the above information? I'd appreciate any
> help.
> Thanks,
> Bing

any stored procedure to report all the databases' information

Hello everyone,
We're going to migrate our SQL 2000 server from one domain to another. I
need to get a better idea of how our current databases are structured and
utilized. What I want is a report showing each database's:
name
data size
log size
users
if backed up or not
Before I dive into it in my own way, just wondering if there is any stored
procedure that can help collect the above information? I'd appreciate any
help.
Thanks,
Bingsp_helpdb does most what I wanted.
"bing" wrote:
> Hello everyone,
> We're going to migrate our SQL 2000 server from one domain to another. I
> need to get a better idea of how our current databases are structured and
> utilized. What I want is a report showing each database's:
> name
> data size
> log size
> users
> if backed up or not
> Before I dive into it in my own way, just wondering if there is any stored
> procedure that can help collect the above information? I'd appreciate any
> help.
> Thanks,
> Bing

any stored procedure to report all the databases' information

Hello everyone,
We're going to migrate our SQL 2000 server from one domain to another. I
need to get a better idea of how our current databases are structured and
utilized. What I want is a report showing each database's:
name
data size
log size
users
if backed up or not
Before I dive into it in my own way, just wondering if there is any stored
procedure that can help collect the above information? I'd appreciate any
help.
Thanks,
Bingsp_helpdb does most what I wanted.
"bing" wrote:

> Hello everyone,
> We're going to migrate our SQL 2000 server from one domain to another. I
> need to get a better idea of how our current databases are structured and
> utilized. What I want is a report showing each database's:
> name
> data size
> log size
> users
> if backed up or not
> Before I dive into it in my own way, just wondering if there is any stored
> procedure that can help collect the above information? I'd appreciate any
> help.
> Thanks,
> Bing

Any good whitepapers on security/deployment for entire SQL Server BI solutions?

At my current employer we are struggling with the best way to manage security and deployment of a project that contains databases, SSIS, SSAS and SSRS components, using configurations.

Environment (Dev):

3 SQL Server databases, all using mixed-mode security, using SQL Server security credentials.

12 SSIS packages; one master package, eleven child packages, 3 shared data sources

1 SSAS database; one cube, 15 dimensions, three referenced data sources from the SSIS project (in same solution)

6 SSRS reports, one data source to cube (not shared- doesn't appear SSRS can share datasources among other projects in the solution? Why?)

Everything runs fine in development. Now comes the tricky part.

Deploying SSIS and SSAS into production environments:

-Packages use XML config files for connection strings to three relational data sources.

-Deploy to SQL Server storage. Deploy wizard copies package dependencies (including XML config files) to default location set in INI file. When I do this, no config file shows up in remote server (remote server not set up identical to local, so directory does not exist. Need UNC path?) So, being a developer with no "special" permissions on the PROD server, what security permissions is allowing the deployment wizard from copying files to this location on a production server?

-Using a deploy script using dtutil doesn't copy the SSIS dependencies. Is this matter of using COPY or XCOPY to copy the configuration files to the dependency location? Again, in real-world practice, do developers typically change this location in the INI file to another location, or stick with the default. In either case, how does security work that allows files to get copied to the remote folder? (i.e. manual, or SQL Server manages this file folder permission through some other magic)

When using SSMS and running the package after being deployed on the remote server, if the config path is the default (e.g. C:\program files\Microsoft SQL Server\90\DTS\Packages\...) it appears to be read from the local machines directory rather than the remote machines directory path (do I need to use UNC paths? The wizard doesn't give this option it seems)

-When scheduling the job from SQL Agent, does the proxy account need permissions to the folder the config files sit in?

-What about the roles security on the packages themselves? Where does the server roles come into play (dtsltuser, dtsadmin)

-Because the SSAS project uses connection references to the SSIS project in BIDS, and SSIS project uses configurations, will SSAS pick up on these connections?

-What about impersonation levels for SSAS? Leave all data sources set to default, and set the database impersonation level to "UseServiceAccount"? What if the developer is not the same as the OLAP administrator on the production server? In this case, Use Service Account isn't an option, and neither is the current users credentials.

-SSAS database also has security for Full Control, but still doesn't prevent security at the data source level within the database (talking about impersonation level, not source db credentials)

-How can SSRS connections leverage other shared connections?

As you can see, there are a ton of security considerations, none of which are intuitive and can be configured multiple ways and actually work (and a ton of ways that won't work).

I need a simple cheat-sheet about each step to take to configure this so multiple developers can work without interruption, hot-deploying SSIS, SSAS, and SSRS changes into different environments (QA, PROD).

-Kory

It is still on my list to read so I'm not sure it contains the information you need but check http://www.microsoft.com/technet/prodtechnol/sql/2005/sql2005secbestpract.mspx

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

I've already read this- not much on the BI tools side, mostly for the RDBMS.

-Kory

ANSI NULLS setting in 6.5

How can I find the current ANSI_NULLS setting in 6.5?
thanksThere no such setting in 6.5 at the server level. This is something you set
in the client app, using the SET command. (In fact, the setting at the
database level in 7.0 and 2000 is mostly useless as the client will override
anyhow, and some API's and tools will set this regardless whether the
developer want to or not.)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"peter feakins" <anonymous@.discussions.microsoft.com> wrote in message
news:92E1AC2B-3162-43AF-A04B-71CD6533CB37@.microsoft.com...
> How can I find the current ANSI_NULLS setting in 6.5?
> thanks