SQL Server Database Administration

What’s Unique About SQL Saturdays: Nearly Everyone Interacts with Other People

My friend and colleague, Kathi Kellenberger, taking questions in her SQL Saturday session on Machine Learning for beginners Today I was looped in on an email thread about the pros and cons of attending a specific event. One person on the thread asked if any of us had attended the event in the past, and whether or not event attendees were engaged with presenters and vendor representatives. My immediate thought was: of course the attendees were engaged, because the event is a SQL Saturday.  I’ve never been to a SQL Saturday where the attendees weren’t engaged. But, I realized that it’s a fair question. This level of interaction isn’t a given for events, much less tech events I’ve been to other tech events — from free events to very expensive ones — where attendees didn’t interact much with anyone else. Mostly people worked away on their laptops/phones/tablets quietly (maybe taking…
Read More

How to recognize the early stages of burnout, and my treatment plan

I recently realized that I’m in the early stages of burnout. This isn’t an unfamiliar place for me, but it is new for me to recognize the early signs of burnout in myself before it becomes a full-fledged disaster. This time, I’m thinking about how I got here, and making an explicit plan to change course. In the hopes of helping someone else out there, I thought some public journaling might be in order. How do you recognize if you’re in the early stages of burnout? I have recognized two symptoms which I identify as unusual for me. Together they indicate I’m heading towards burnout. Symptom 1: Lately, I get frustrated and angry by small things One warning sign of burnout is when small inconveniences start causing a disproportionately large emotional response. For example, on a recent weekend I was traveling for work. I was in the Detroit area, about…
Read More

Paying down technical debt

One of the cool things that I do as an Evangelist at Redgate is to periodically visit company headquarters in Cambridge. The other Evangelists and I get to meet with every software developer, product manager, and UX designer at Redgate over a series of meetings. That’s really cool. We talk about things that they’ve released lately, what they’re looking at doing in the near future, and we get to give feedback based on what we hear from the community and from folks in the sales process. We also get to share what we personally think should happen in these products now. As you might imagine, I have a wish list for features in a variety of different Redgate products Our products are great, and one of the things about great products is that users are always inspired to want to use them in new ways, so I never lack for…
Read More

Upcoming full day training: “How to Architect Successful Database Changes”

I’m excited to be teaching a full day session with Steve Jones at the SQL PASS Summit on Tuesday, November 5, in Seattle. Steve and I will be discussing proven patterns to version and deploy changes successfully Read more about this precon session, or check out the video below where I give a brief overview of what Steve and I will cover. Will you teach me how to use Redgate tools? Nope– not in this session. While Steve and I both work for Redgate, we will be showing patterns and approaches that work with both vendor and custom tooling, and we’ll do demos with a variety of tools, including free tools when possible. This is absolutely not a product-specific session, and the patterns discussed have been proven in the industry by developers and DBAs using a wide variety of tooling. If you’d like to learn more about Redgate tools, check…
Read More

Why to Avoid Using the Current Database Name in Object Definitions in SQL Server

I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. Hello, my name is FINE In the article, I discuss: Why referencing the current database name creates a dependencyWhat ‘deferred name resolution’ is, and why the dependency may be more noticeable in views and some functions (rather than stored procedures)Which activities are most likely to break if you place dependencies on the current database name Read the full article here.
Read More

PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas

Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three sessions between now and March 31, 2019. I’m currently in the process of sketching out my ideas for what sessions that I’d like to submit, and I thought I’d share my process here. Generating ideas: what am I interested in spending six months thinking about? I’m a bit selfish when it comes to topic selection, and I think that’s fine: it needs to be something that I’m interested in thinking about for more than half a year. That does NOT mean that it needs to be super-advanced rocket science content. Figuring out how to present introductory level content clearly, in an easy-to-understand way takes a lot of time. The topic simply needs to compelling enough for me to stay interested. A…
Read More
Menu