I'll hear people constantly say they don't have time to work on their career. They can't attend a UG meeting to network. They can't spare a minute to go through a Stairway Series. They have family commitments, kids, hobbies, volunteer activities, spiritual needs, and more. That's not even counting all the work they need to get done as a part of their job. When can they spend time on R or Machine Learning or CosmosDB or anything else?
I get it. My life is chaotic as well, with deadlines and a pile of work that never goes away. I sometimes dread travel and vacation because that means my work piles up on either side of those events. This is on top of commitments to keep up on chores at home (I have cooking and laundry), fix things at the ranch, spend time with kids, get date nights with my wife, and still get to the gym. Most weeks feel like a crazy treadmill for me.
In my life and career, I've learned a few things. One of which is that I need to prioritize what's important to me. That often helps me decide when to do X instead of Y. I regularly make choices between opportunities, but I also try to evaluate the relative importance of events. I rarely miss family events or kid activities, but sometimes I do. I know that there are times that I feel my work is more important in the moment. However, I try to balance those out to be sure I remember that family is more important overall.
I've also learned that I can find time for things that are important. I have to adjust priorities and scheduling. It is important to not just overload myself with more work, which is easy to do. I find that if I try to get more done in a week, I can't do that for long. Like a big project at work, I'll burn out without balance. Instead, I've learned to let something go a bit, or cut back on some part of my life to make a little time.
Everyone can spare some time. Especially those of us in the technology industry. We need to learn and grow, even if it's just for ourselves. We need to keep our brain's active, and on a regular basis, we should try something new. Other professions can do this, and we should as well.
I know you can't dedicate a half a day a week to a class, but maybe you can spend 30 minutes or so working through a book. I know you can't make the user group every month, but you can make one or two meetings a year if that's something you enjoy. You can't go through all our Stairways, or maybe not even all of the Indexing levels in that series, but you can start learning a bit more with one. Perhaps you can't make SQL Saturday this year in your area, but is it worth a bit of your day to watch a presentation from the SQL Bits archives?
I bet it's possible, and I bet you can find a little time every month or two to grow a bit as a technology craftsman. Make sure you take care of yourself, and actively work on your career, in balance with the rest of your life.
The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.
Write, format, and refactor SQL effortlessly with SQL Prompt
Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial
Database migrations inside Visual Studio
Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free
SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job. More »
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". More »
If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll see how SQL Clone cuts out the pain of provisioning development databases. More »
Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure. More »
Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all... More »
Question of the Day
Today's Question (by Steve Jones):
I've got this dataframe:
characters movies releaseyear
1 Iron Man Iron Man 2008
2 Spider-Man Spider-Man Homecoming 2017
3 Thor Thor: The Dark World 2013
4 Hulk Hulk 2003
5 Doctor Strange Doctor Strange 2016
6 Captain America Captain America: Civil War 2011
7 Black Widow The Avengers 2012
8 Hawkeye Avengers: Age of Ultron 2015
9 Ant-Man Ant-Man 2015
I want to just return the row of data for Spider-Man. How can I do this?
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: R Language.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Automate your workload and manage more databases and instances with greater ease and efficiency by combining metadata-driven automation with powerful tools like PowerShell and SQL Server Agent. Automate your new instance-builds and use monitoring to drive ongoing automation, with the help of an inventory database and a management data warehouse. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
The event counter target is used to count the number of times each specified event occurs. How does this processing occur?
The event counter target processes synchronously, but this is usually not an issue as there is little processing that occurs.
Bulk load architecture
- Hello SQL Guys,
I am working on a project where in a file location I will be getting daily files like...
expecting ID or quoted_ID. Help!
- error i'm getting from the below query: Incorrect syntax near '@DatabaseName'.
DECLARE @DatabaseName as NVARCHAR(200);
DECLARE DatabaseCursor CURSOR FOR
SELECT Name FROM sys.databases
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.