SSWUGtv
With Stephen Wynkoop
Today Laura Rose is back again with great tips to help you be more effective in your career. Laura shares tips for easy communication with your manager – important for performance reviews!
Watch the Show
The Changing Role of the SQL Server DBA
Over the last Seven years my role as a SQL Server DBA has changed considerably. Before that time, the database code was the restricted domain of the DBA staff. All stored procedures were reviewed by DBAs. No database code was moved outside the DEV area unless performed by a DBA. All schema modifications were the responsibility of the DBA staff. Developers could make changes in the Dev database, but were subject to change and final approval of a DBA.
Seven years ago I joined an Agile software development team where these processes were no longer effective. No longer did we generate a complete schema prior to writing code. We were more likely to change the schema for each bi-weekly release than not. Moreover, the amount of database code necessary for a full featured application could not be written by a single person or team of DBAs.
In order to meet the needs of a fast pace development team, database code was treated like all other code. Every developer was the owner of the entire code base. Sure, we had a tendency to code where our skills were best. But, there were not areas of code restricted to a specific individual or group.
This policy resulted in a number of tools and processes enabling developers who were not necessarily SQL experts to be able to contribute to the SQL code base. I’ll be sharing some of those processes and tools later this week.
Do you have a preference for how the database code is created and managed. Share your thoughts by sending email to btaylor@sswug.org.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
SQL Server Database Consolidation
In this article, I will discuss the types of consolidation of databases, the key steps and the advantages and disadvantages of database consolidation.
Featured White Paper(s)
Top 10 Tips for Optimizing SQL Server Performance
read more)