SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

How do you keep yourself from burning out?

Today we have a guest editorial as Steve is out of town.

This piece is essentially about work / life balance, but I wanted to discuss the signs of being burned out at work. If we can recognize things that cause us to burn out, perhaps we can do something different to avoid it. I find it interesting that often people that are burning out at work, don’t always recognize that burnout is happening.

First, let’s talk about things that can lead to becoming burned out. I would say first and foremost is working too much. Sometimes our jobs demand that we go over and above our normal “working” hours, but when we are always working more hours, nights, weekends, the load can be too great. Some companies are good about comp time and let you take time off in compensation for the extra time you work. Others are not so gracious and use the, “well you are a salaried employee,” excuse. Also, never or rarely taking vacation days can lead to burn out.

Next, the work you are doing can be burning you out. If you get no enjoyment at all from the work you are doing you can burn out. Every day at work becomes drudgery, there is nothing to look forward to except lunch and quitting time.

Finally, there are co-worker or boss relationships that can cause you to feel burned out at work. When you have to work with someone every day and they always seem to get under your skin. Or your boss is more of a task master or micro manager, they never seem to listen to you or show any appreciate for the work you put in. I am sure there are other things that can and do cause you to feel burned out at work.

So, why don’t we recognize that we are burning out at work? Sometimes, it is because we are just too tired to realize what is going on. Other times, we don’t feel like we have other employment options. Many of us are kind of "grin and bear it" sort of people. We push on even though it is miserable.

In my previous position, I was burned out. My wife noticed it way before I did. She noticed how stressed out I was about work. Working relationships that were once good had turned sour. I really didn’t enjoy the work I was doing, but I felt trapped. The pay was good and I had been with the company nine years.

So I would suggest asking the people around you, your friends or family. Ask them if they think you are burned out at work? If you are tired from working too many hours. If you are stressed about work and dread having to go to work, you might be burned out.

Now in some cases, you are causing yourself to burn out. You are pushing yourself to work extra hours and aren't taking vacation/holiday days. The conflict you are having at work is as much about you as your co-workers or boss. So take stock of your situation and ask yourself honestly if there are things you can do to turn the situation around and avoid burn out. If there is nothing you can do, or if you are unwilling to do something different on your part, then it might be time to move on.

Let us know if you are or have been burned out at work? What caused you to feel burned out?

Ben Kubicek from SQLServerCentral.com

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

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

SQL Prompt

Write, format, analyze, and refactor SQL fast 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 code analysis you get suggestions to improve your SQL as you type. Download your free trial

Featured Contents


Using SQL Server as a Source with for an Excel Application

Thomas Stricker from SQLServerCentral.com

I am presenting an MS Excel VBA project which automates the display of SQL Server data tables. More »


Artificially Intelligent - Text Sentiment Analysis

Additional Articles from Microsoft MSDN

One of the truisms of the modern data-driven world is that the velocity and volume of data keeps increasing. We’re seeing more data generated each day than ever before in human history. And nowhere is this rapid growth more evident than in the world of social media, where users generate content at a scale previously unimaginable. More »


Welcome to Redgate tools for SQL Operations Studio

Built on top of Visual Studio Code, SQL Operations Studio is a free lightweight tool for modern database development and operations that runs on Windows, macOS and Linux. It’s been designed for developers without a deep knowledge of database administration, so that they can manage databases and maintain them. More »


From the SQLServerCentral Blogs - Visual Studio Code Live Sharing Set-Up

Rob Sewell from SQLServerCentral Blogs

There was an announcement on the Visual Studio Code blog about the public preview of Live Share. This enables you... More »


From the SQLServerCentral Blogs - Automate SQL Server Database Restoration using bacpac with PowerShell or Batch techniques

Prashanth Jayaram from SQLServerCentral Blogs

Data is the key to your organization’s future, but if it’s outdated, irrelevant, or hidden then it’s no good. Maintenance... More »

Question of the Day

Today's Question (by Steve Jones):

I decide that the 20 workers that are added when I installed SQL Server Machine Learning services are not enough. How many can I have in total? What's the limit?

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.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload.

Pick up your copy of this great book today at Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have a simple vector that is created by 

x = c(1:20)

I decide to break this into 4 intervals with this:

cut(x, 4) 

What is returned for the levels?

Answer: Levels: (0.981,5.75] (5.75,10.5] (10.5,15.2] (15.2,20]


The CUT function will divide the range of the parameter into the specified number of intervals. In this case, I choose 4 intervals. The calculation of these intervals is somewhat strange, but essentially R will pad the spaces a bit to ensure all values fall into the buckets it has created.

Ref: cut - 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

SQL Query to pull data - Hi,  i have two table named "Objects" and "Attributes".  Object Table Structure and Data: Attributes Table Structure and Data:

Performance Question - Hi there,  I have a performance question here: how can I rewrite below highlighted area?  I am getting Lazy spool in execuation...

Normalization and Third Normal Form - Hello. I was watching a video that covered Normalization. It explained that a database is in third normal form when...

SQL Server 2016 : SQL Server 2016 - Administration

DeadLock --trying to figure out what resource-list is telling me? - trying to figure out what resource-list is telling me? I get the ownerd id, but I am not seeing what...

SQL 2016 Optimization ... - Hello, I have two SQL 2016 Always On nodes - (VMware Virtual Machines). Each node has 250GB RAM, 46 vCPU @2.5GHz. Each...

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

Creating Filters like Previous Week, from Tuesday to Monday - Hi, If I needed to create some kind of filter that would get the data between the previous week's Tuesday, to...

Return rows where value doesnt exist - Hello Everyone,      I have a slight problem so I hope you can help. I have a table with orders joined to...

Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...

SQL Server 2012 : SQL 2012 - General

Question about agent jobs - Hi, All of my jobs have stopped running, and I noticed something in security. If I go to my agent login properties...

Log shipping and database backups - Hi all We've got a few databases that we want to start log-shipping from. Normally, we'd use replication but the 3rd-party software...

SQL Server 2012 : SQL Server 2012 - T-SQL

Conversion Error and Language Settings - Hi Experts,  I am facing a strange issue where casting varchar to date throws conversion error but if I change the...

SQL Server 2008 : SQL Server 2008 - General

Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis - Hello, techies, I have a table in my database named HR_Employee_Data, which has everything about particular employees like his/her first...

Stored procedure running in loop is taking time to load . Is there any alternate way to run in a single execution ? - Hi All, I have an application where we will be showing the invoice and Plan backup reports for each recipient in...

Cannot open database "couch_db" requested by the login. The login failed... - I have this ASP.NET website running on my laptop (IIS 5.1/Win XP SP3/VS 2008 - .NET 3.5 SP1), and, I...

Reporting Services : Reporting Services

Pass Multi Value Parameters to SSRS Report Using URL - Hi , I've a URL below with 5 multi select parameters (Branchcode, Branch, Niche, Team & Consultant) and 3 single select parameters...

Embedding ssrs report in email body - Hi, Can some one help me to embed a SSRS report in email BODY instead of attaching it via subscriptions? Thanks

Data Warehousing : Integration Services

SSIS Data Conversion Failed for Flat file to SQL table ? - Hello  I  have around 40 flat files to move to my sql  database   My destination table look like this  while importing from flat...

Data Warehousing : Data Transformation Services (DTS)

Cannot Open Database "xxx" requested by login. Login failed - I created a DTS package using remote desktop to the server.  I'm logged in as me and I'm an administrator. ...

SQLServerCentral.com : Articles Requested

TRY_CONVERT - A short look at this T-SQL function, and where it can help write better code. Practical examples preferred.

SQL Server 2005 : SQL Server 2005 Integration Services

Exporting Multiple SSIS packages from MSDB - If we need to export a package from MSDB into the file system we can do it using the SQL...

This email has been sent to {user_email}. 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