SQLServerCentral / Discuss Content Posted by Janet Wong / Article Discussions / Article Discussions by Author

The Data Warehouse DBA

Loner — Mon, 04 Dec 2006 21:32:00 GMT

Comments posted here are about the content posted at temp

What Makes a Good Programmer

Loner — Tue, 15 May 2007 11:12:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/3000.asp

What's a Good Manager

Loner — Tue, 19 Dec 2006 18:39:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2768.asp

My Projects Have Never Failed

Loner — Mon, 26 Feb 2007 08:05:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2892.asp

Developers and DBAs

Loner — Wed, 29 Nov 2006 14:37:00 GMT

Comments posted here are about the content posted at temp

Data Quality

Loner — Mon, 11 Sep 2006 11:38:00 GMT

Comments posted to this topic are about the content Data Quality

Are you ready for Data Warehouses?

Loner — Mon, 12 Mar 2007 10:45:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2914.asp

Problems In Building a Data Warehouse

Loner — Sat, 27 Jan 2007 12:12:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2832.asp

The Dynamic Process of Loading Data

Loner — Wed, 27 Dec 2006 11:39:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jchan/2781.asp

RE:

Andy Brons — Tue, 23 Jan 2007 09:45:00 GMT

you can write a script that changes all the dts connection properties and moves the packages over from test to production.

outined here:

from http://www.dbazine.com/sql/sql-articles/larsen8

RE:

Jewel-379316 — Tue, 16 Jan 2007 11:22:00 GMT

excellent article, I could not agree more!! I have had similar experiences and yes I think as the days have gone on there are more and more Managers definately not interested in the people, it seems the bottom line is more important.

RE:

Yomesh — Tue, 16 Jan 2007 07:08:00 GMT

I liked your way to put the managers habits i have gone through all this i my North american jobs.

But the way you critisize the inidian as bad programmer and racist that's way you not suppost to talk or write. I have gone through one very very racist chinese manager first job in this country he used to yelled at me in public even database was locked becuase of his chinese (Non speaking english) programmer fault.

So don't mistake writing the things about community bad things.

Take care

RE:

shaili — Tue, 05 Dec 2006 13:04:00 GMT

Hi Janet,

It sounds like that your previous work place really needs DBAs.

-Shaili

RE:

hkan008 — Tue, 05 Dec 2006 12:22:00 GMT

Sounds very familar with between application developers and "DBA". It was a pretty hot topic in the SQL Code Camp held in New Zealand few weeks ago (organised by NZ .Net User Group).

It comes down to the fact that it is a management / people issue, which has a serious impact on productivity of the *entire* company (well or at least, betweeen the DB developers and DBAss) and the quality of the work done.

I have been running the team for the last 5 years and it is the same similar problem between the application developers and the DBAs. Application developers have been writing SQL statements (not even SP) in the business layer and DBAs just responsible for the performance tunning. Guess how difficult for the DBAs to ask the app developers to rewrite the SQL!!, and more imprtantly, putting out the fire when the db is running slow!

From the app devlopers point of view, yes, they dun wanna to rely on DBAs to do their development. However, they don't want to konw whats go on with the database schema either. Yet, DBAs keep complaining app developers write inefficient (or bad) SQL. What should we do.

I value the skills and work DBAs. However lots of people tends to have a mind set, DBAs operates in silo and they never talk to other people in the company.

I realised the problem and I started restrcuturing both our dev processes (not just the app development but also db development) and working on people's perception on what DBAs really do.

Apart having the db developers actively involved in the app development (i.e. writing USPs etc.) so they have much feedback to each other, quicker, and at earlier stage in development.

I also trained all the db developers with DBA skills and DBAs are trained with DB development skills. This is a must for *everyone* to understand what they are doing and what impact of the developers to others (not just people who get frustrated with someones' codes but also for the system performance). It works fine from management perspective as I now got everyone crossed trained and I have more resoruces to do both db dev and DBAs stuff!

I have to say there is no easy way out (I was lucky as I oversee both the operations and db development) but the most important thing is somone in the company who KNOW the development (not just app, db development) and the DBA side. PS. its good to see M$ changed their certification from MCDBA to the new ones. MCDBAs actaully contains both the db development and DBAs stuff. However it is still called MC"DBA".

RE:

thabiso mokhosoa — Mon, 04 Dec 2006 23:48:00 GMT

Here, here Janet I feel you. I have been there and been done that manier times than I can care to remember. I am a DBA and have been around people who are supposed to be senior DBA's and are supposed to write decent SQL statements but nope nada, no speaka SQL. All you can do is the best you can, flip the rest.

SQL Server Adventures for the Oracle DBA

Loner — Fri, 13 Oct 2006 10:20:00 GMT

Comments posted here are about the content posted at temp

Dynamic SQL

Jared Still — Thu, 19 Oct 2006 10:52:00 GMT

Perhaps you should have spent more time perusing the manuals with Oracle.

Dynanic SQL comes in 2 flavors.

EXECUTE IMMEDIATE has been available since 8i.

eg.

beginexecute immediate 'create table x(x number)';end;