SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

Lessons for all of us

I write a fair amount about career issues. It's one of the largest tags in my word cloud, and I'm proud of that. I've seen too many people in bad jobs for too long, had a few myself, watched my wife work far too hard at times, and lost friends because of a lack of time. All of those experiences have caused me to really think hard about life and how I approach work. 
Don't get me wrong. I like work, I enjoy what I do, I have a great time writing code and queries and think technology is a great career choice. That being said, it can be a hard job. There are demands to work long hours and holidays, often to deploy changes when the workload is low. Some years, I've worked as many holidays and weekends in this business as I used to when working in restaurants.
That being said, we often think of this as an "easy" job in many ways. We work in offices. We're well compensated. We don't have a lot of physical demands, and we can do this job will into our later years if we choose. If you've ever worked in a job that requires more physical effort such as construction, you appreciate the ease with which our days pass. If you've ever had a boring job, such as staring at the x-ray screen in airport security, you'll likewise realize most of us are lucky that we get to exercise our brains.
That doesn't mean this job isn't hard. In fact, burnout and high stress are real problems in technology. While some industries might worry about their people getting enough done when working remote, our industry has too many people that don't know how to stop working. I thought about this as I was reading a post on burnout and looking out for yourself.
Many of us that work in technology are too sedentary. We sit at desks, we work odd hours and often subsist on poor diets that we've built during a lifetime of late night coding sessions. We also accept more blame, demands, stress, and accountability than we should. While I don't know too many people that have had serious health issues from this work, I do know a few. I also know far too many people that have passed away before they reached 50.
The downsides of this work can creep up on you. I know I felt a little burned out last year, from too much travel, too many balls being juggled, too much pressure. I made a conscious effort to slow things down and I'm much happier this year. I try to exercise and eat (slightly) better on a regular basis, balancing that out as best I can.
We work to live, not the other way around. Whether you need fewer responsibilities, more exercise, new hobbies, better connections with friends and family, strong mental health care, or something else, make sure you take care of yourself in this life. It's the only one you get.
Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.0MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

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
Database DevOps

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

SQL Monitor

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

Featured Contents

 

Using FORMAT() for Dates

Steve Jones from SQLServerCentral.com

Learn how the FORMAT() function works for dates. More »


 

SQL in the City Streamed – Compliant DevOps: June 20 2018

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey, and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, HIPAA and SOX. Find out more and register for free More »


 

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

Additional Articles from MSSQLTips.com

Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance. More »


 

How DevOps can automate the repayment of technical debt

Looking to DevOps automation to try to create the breathing room needed to break out of the vicious cycle of technical debt. More »


 

From the SQLServerCentral Blogs - Cosmos DB for the Data Professional

DataOnWheels from SQLServerCentral Blogs

Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced... More »


 

From the SQLServerCentral Blogs - Back to basics: What is a HEAP table?

Daniel Janik from SQLServerCentral Blogs

Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more... More »

Question of the Day

Today's Question (by Steve Jones):

Which languages can be used with Machine Learning Services in SQL Server 2017?

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: Machine Learning Services (MLS).

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

XML and JSON Recipes for SQL Server: A Problem-Solution Approach

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I build this function that takes multiple parameters.

 def AwardRibbons(first, second, third, fourth): print("Thanks for participating", fourth) print("The bronze goes to ", third) print("The silver goes to ", second) print("The gold goes to ", first) 

When I decide to call this, I include parameters, but some I name and some I do not. What is the order that I must follow for the parameters in my function call?

Answer: All positional arguments come first, then named arguments

Explanation:

In Python, positional arguments must be passed in first, and then named arguments can be passed in. If there are default values, then the arguments need not be included. If all arguments are named, they can be passed in any order.

This is valid:

 AwardRibbons("USA", "Canada", "Germany", "Austria") 

As is this:

 AwardRibbons(third="USA", first="Canada", fourth="Germany", second="Austria")

And this:

 AwardRibbons("USA", "Canada", fourth="Germany", third="Austria") 

This is not

 AwardRibbons(third="USA", "Canada", fourth="Germany", first="Austria") 

Ref: Fun with Python Function Parameters - 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.

SQL Server 2017 : SQL Server 2017 - Development

Need help with derived column expression - Hi All, I have a requirement for derived column expression as if ColA ="AB" then display else if ColA = " BC"...

Cursors - In what situations should i use cursors over joins. I know that joins are much more faster than using cursors,...


SQL Server 2016 : SQL Server 2016 - Administration

Backup - Hi , Daily database backups are running, but there is no sql job. And backups are saving in physical drive. How to find...

AlwaysOn AG Listener IP Adress from diffrent Subnet / IP Range - Hi All, My AlwaysOn Config is like this 2 Nodes 3 AGs with Listener All are in the net for example 10.10.1.x Now the IP...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

A better way than multiple subqueries? - I have a table that contains a single record for each of the (several thousand) devices we manage, and a...


SQL Server 2014 : Administration - SQL Server 2014

delete the backup file according to a definite date - Hello everyone To answer the need GDPR  I must precede to delete the backup put on the sharing according to a date...


SQL Server 2012 : SQL 2012 - General

Providing a password to an SSIS package - I have a need to provide a password to an SSIS package so that the package can be deployed to...

Adding a SQL Server instance to existing 2012 cluster - I have a 3 node, active-active-passive cluster. Node A host 2 SQL Server instances, node B 3rd instance. All are...

Restoring database A also tries to Restore database B - Hi Guys, Had a very strange is happen to me, I was required to restore our production db to a specific...


SQL Server 2012 : SQL Server 2012 - T-SQL

Execution time is taking longer - Hello Friends, I have a query which is taking too much time for execution. I am trying to fine tune the...

No alternative but row-by-row processing? - I know how to do this with a loop or cursor, but wondered if there was a brilliant mind out...


SQL Server 2008 : SQL Server 2008 - General

SQL Query potential - Hi not sure if this is the correct section but I've got to start somewhere, I've got a general SQL...

updating sql via excel. - 3rd party provider has a requirement = user needs to update sql tables via excel.  Possible it seems with some VBA...

lost permissions to execute stored proc - In running an app in a test environment that used to work, I am now seeing the error "The EXECUTE...


SQL Server 2008 : SQL Server Newbies

detect if previous record is higher or lower ? - In it's simplest form if I had a table that stored a persons name, date that the record was entered,...


Reporting Services : SSRS 2012

Report design where number of columns is unknown - Hi, I have a query based on pivot and dynamic SQL that results in the number of columns returned being...


SQLServerCentral.com : SQLServerCentral.com Website Issues

A user you are following, "...", has posted new content: but I'm not following this user - Today I received an email A user you are following, "...", has posted new content:but I'm not following this user "Thom A", has...


SQLServerCentral.com : Articles Requested

TRY_PARSE - A look at this new T-SQL function, along wiht some examples of where this can help prevent errors in code


SQL Server 7,2000 : T-SQL

MS SQL - Extract number to the right of text - I am trying to extract either a 2 digit or 3 digit number to the right in a product description. Here...

How To Check if Job is Running? - Does anyone know how to write the T-SQL that checks if a job is still running?  I need to make...

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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com