Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2011-02-17 : 12:29:21
|
Just a quick question, sorry if it's a bit off topic for this section of the forum.Which department would you place a single MS SQL Server Administrator / Developer within a company without a dedicated department?1) Development (developing for SQL Server, .Net and ASP.Net)2) Infrastructure (Networking, hardware etc)3) Business Process Management (well.. Business Process Management)Thanks in advance for any replies. |
|
Ifor
Aged Yak Warrior
700 Posts |
Posted - 2011-02-17 : 12:48:54
|
It depends!Development DBAs would normally go in with the developers and production DBAs with infrastructure.(A Development DBA and a Production DBA can do very different jobs. eg A development DBA often spends a lot of time working on data access while a production DBA can spend a lot of time managing large DBs with thousands of users.)You need to work out how much time your DBA is going to spend on development and how much time on production. |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2011-02-18 : 07:35:31
|
Thanks for the replies.The kinds of things are access problems - new logins permissions etc, performance tuning new and current queries, database backups, monitoring database mirroring, developing new stored procedures / views etc, responding to incorrect data imported, importing / exporting data and controlling roll-outs of new TSQL code to production. |
 |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-02-19 : 05:30:09
|
Based on what you're outlining -with Developers ,but possibly with regular meeting with infrastructre. Or a new department called Data Administration?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2011-02-23 : 09:43:16
|
Thanks for the replies. That's what i was hoping. |
 |
|
|
|
|
|
|