I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development go without load or performance testing?”
Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers.
Redgate is building a library of real-world stories about database development disasters.
One controversial topic in database development is how to properly store and deploy database changes.
This is generally described as choosing between two options, which are approximately as easy to understand as Greek philosophy:
- State based - A Platonic view of the database as a snapshot of a set of forms in a given state at a point in time
- Migrations - An Aristotelian view of the database defined as a series of scripts which generate change over time
Next week, I’m giving a free webcast for Redgate on DevOps fundamentals. DevOps is something I am a big proponent of for database administrators, developers, and company leaders.
I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter.
Watch our discussion about how to make three different teams successful at database DevOps.
I recently spoke at the GroupBy free online conference. It was loads of fun, and the recordings from the event are now available. Here’s the hour long session I presented.
This month’s #tsql2sDay is hosted by Steve Jones (blog | twitter), and the topic is “What the Business Says is Not What the Business Wants.” Steve asks the question:
What issues have you had in interacting with the business to get your job done?
Yeah, you heard me.
“But Kendra, why would we want to grant developers read permissions? And why would we automate it? And at what point did you lose your mind?”
Part of this past week I’ve spent doing a new SQL Server 2008 R2 installation and configuration on a Windows 2008 R2 cluster. I haven’t done an install end-to-end in quite a while– I have teammates who take care of it while following our installation checklist document.
OneNote in Office online makes it easy to create and share notebooks with many checklists. The checklists include version tracking.