Join the Best Worst Code Contest Today at 5pm BST / Noon Eastern #BestWorstCode
Category:
tsql-programming
I have an idea! Let’s have a “Worst Code Contest.”
Make Database Code Reusable in SQL Source Control with Deployment Filters
Category:
devops-automation
, sql-server
When I first began working with databases, I was lucky to land a job at a little start-up which had solid development and operations processes: all our code, including database code, was in version control. We had a strong database architect who instilled good coding practices into the way we managed database code as well: code was expected to be reusable whenever possible.
Connecting to the SQL Server Community Online: Uplifting Folks
Category:
database-administration
We’ve got a session coming up in the free Redgate Streamed virtual conference on, “How database DevOps levels up remote work.” When thinking about that session I began thinking about other ways to improve remote work.
While I worked remotely for nearly ten years until recently and have established practices which work well for me , moving to another country and the general chaos and uncertainty right now as the world tries to cope with a global pandemic have increased my feelings of worry and loneliness.
Outlining My Session: Index Tuning in an Agile World
Category:
indexing
, sql-server
I’m giving a session on index tuning at the upcoming Redgate Streamed free online conference. The conference will be held April 1-3 2020, register here and join us!
I love talking about index tuning and I know this area well, so I’m excited to put together this new session. I thought it would be fun to share my process of outlining and creating the session, leading up to the event.
Announcing Redgate Streamed, April 1-3 2020
Category:
community
We’re thrilled to announce Redgate Streamed: a 3 day online virtual community conference, to be held April 1-3, 2020. Register at Redgate.com/RedgateStreamed
About the Event
In this 9 minute livestream, I give you a rundown of the event schedule and tells you why I’m excited about each session.
Support COVID-19 Response
For every registration that attends Redgate streamed, live or on-demand, we’ll donate $1 to the World Health Organization’s COVID-19 response fund (in addition to a separate donation we’ll be making. Even if you can’t join us live, be sure to register and you’ll receive the recordings to watch on-demand, plus you’ll help us raise our gift level!
The Learner's Guide to SQL Server Performance Triage
Category:
monitoring-troubleshooting
, sql-server
I’m introducing a series of “learner’s guides”: overviews of a given topic, chock full of links and references. For this first post, the information is based on what I learned when I was part of the team at Brent Ozar Unlimited who put together the original First Responder Kit and built a related consulting practice using those tools.
Why Re-teaming Is Good
Category:
career
🔥 NOTE: This post is based on an editorial I originally published over at SQL Server Central.
Years ago, I worked on a fabulous team of eight database administrators
We supported more than a hundred developers who worked in an agile fashion. When I first joined the DBA team, we had a shared on-call rotation, but each DBA specialized in a certain area of the environment and regularly met with the development teams working on that area. DBA specializations rarely shifted.