| A community of more than 1,600,000 database professionals and growing |
| | Time is Precious 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. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.4MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. | |
|
|
| ADVERTISEMENT | | 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 |
|
|
|
| | | Richard Waymire from SQLServerCentral.com 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 » |
| Press Release from Redgate 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 » |
| Additional Articles from Database Journal 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 » |
| Klaus Aschenbrenner from SQLServerCentral Blogs (Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the... More » |
| Richie Lee from SQLServerCentral Blogs Hello! Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all... More » |
|
|
| | Today's Question (by Steve Jones): I've got this dataframe: > print(marvel) 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 Contribution Center. |
|
|
| |
ADVERTISEMENT | 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 |
| Yesterday's Question (by Steve Jones): The event counter target is used to count the number of times each specified event occurs. How does this processing occur? Answer: Synchronously Explanation: The event counter target processes synchronously, but this is usually not an issue as there is little processing that occurs. Ref: Targets for Extended Events - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. The cluster IP address is already in use error while installing SQL 2016 Failover Cluster - We have 2 nodes, both were running SQL 2014 cluster. We had to upgrade the windows OS to 2016, the... Delete DB, where physical files are missing - Got a situation, the storage location where the physical DB files existing is been deleted by storage team. Now, i'm... SSMS version for SQL Server 2016 - We are in the process of upgrading our servers from SQL Server 2008R2 to 2016. What version of SSMS would... Order by issue - All, I have the following CTE: DECLARE @SQLStr How to find Relationship between Tables ? - Hello I have an SQL database with more than 500 tables. How to find the relationship between tables and the associated... Having clause - Hi, Need to add having clause as tansaction_count>1 after group by clause in below query . Transaction_count is exist in table dbo.TABLEW Any... CREATE LOGIN from Windows... leaves hasaccess=0 sometimes? - Hey folks- thanks in advance if you can help with this. I run several SQL Server 2014 SP1 clusters. When we... Alter LDF File Max Size - Hi, The product I support does a FULL backup nightly as well as log backup every hour. The ldf file is... No Management Studio After Installation - Hi I Installed SQL Server 2014 SP2 Evaluation. Have not received any error during installation, but when i try to run... Package execution from SSIS Catalog - Failed to execute when running from remote SSMS - I am able to run the package from the server (manually run from SSIS Catalog ). But it fails when run... Comparing 2 functions for any differences in the result set. - Recently, we've done some optimizations to the functions and now the BI Manager has tasked me with a request to... Options to run BCP in SQL Server - Hi All, the question might be stupid but as a quick fix want to know if there is a way... Connection Encryption - Protocols not showing the certficiate - Following https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine to setup SSL connections. Have got through to the part when you need to enable the certificate in the... 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 WHERE... Indexing strategy on a highly transient table - Hi, I'm just looking for a disscussion about the best indexing strategy for a table I have that's in a... Clustered Index on datetimeoffset? - Hi! The Question: Is it a good or bad idea to use Clustered Index on a datetimeoffset(7) on the Created Column that... Stored procedure to pass date ranges - I would like to write a stored procedure that use the date range for the different sum and count functions.... Long-running script with IE11 - Hi guys, I am currently facing an issue with SSRS 2008 and I will like to get your support regarding this. I... Cursor variable losing data - Hi, I have an SQL Server agent job which essentially fetches the names of databases to be backed up into a... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. | 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. | This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|