Information From DBAs - For Database Developer (SQL Server 2005)

Question

Hello Everyone

What kind of information a database developer should be asking from DBA after the database has been deployed on SQL Server 2005?

If anyone can point me to any artical, that will be help full.

Thanks

Answer 1

Here are some to get you started:
What is the backup strategy?
Is a source code system in place? 
Does the database connection string require extra arguments (eg specific network libraries or mirroring failover servers)
What permissions do developers have?
What permissions don't developers have?
Can indexes be created by developers (or this is a DBA only area)?
Do any SLAs (Service Level Agreements) exist?
Is there downtime (maintenance period)?

Hope this helps


Rob

Answer 2

A few others:

What kind of maintenance is being performed ongoing? (Index Rebuilds/Reorganization, Statisitics Updates, Datafile/Logfile size management)
If you code your scripts correctly, they should output information that can be captured into a text report by the DBA when they run the script.  I always asked for that report back after deployment so I could tell if there were any issues during the deployment.
If the deployment involved changing or loading data, getting a row count using SELECT COUNT(*) from the affected table using filter criteria will tell you if the changes completed correctly.

---

Jonathan Kehayias
http://sqlblog.com/blogs/jonathan_kehayias/
http://www.twitter.com/SQLSarg
http://www.sqlclr.net/
Please click the Mark as Answer button if a post solves your problem!