SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

When Work Gets in the Way of Work

This editorial was originally published on October 21, 2014. It is being republished as Steve is on vacation.

It seems I find myself in this situation more and more. I've got work to do at SQLServerCentral. There's a constant stream of articles to edit, content to review and schedule, questions to build, and of course, writing these pieces on data related topics. That goes on 220+ days a year, as we keep the site going and send a newsletter every weekday of the year.

However the last few years I find myself crunched to get work done in my work week with the addition of other tasks to my routine. I've moved from 2-3 events and 5-6 presentations to 20+ events and closer to 40 talks a year that I deliver. Not only is there a high frequency of events, but there's also a number of new presentations to build. It seems I have 3-4 (at least) new talks to assemble, which can be quite time consuming. That's in addition to keeping SQLServerCentral moving.

This isn't different than many of the jobs I've had in the past. Often I've had a set of tasks that I need to work through regularly. Whether these were admin tasks, or development projects, I usually have found that I can develop a routine throughout most weeks. However things crop up. Bug fixes are reported, or hardware fails, or some other project takes some priority, but I need to somehow fit this into my week, along with everything I normally do.

It's tough, and I think far too many people with salaried jobs try to just work harder and longer to complete their work. That makes some sense for a short period of time (2-4 weeks), but after that it's a mistake. Productivity declines and people burn out. They become cranky, and more importantly, they lose a substantial portion of their life over time.

I've learned to push back when things become too busy, and while I've had managers that weren't thrilled, even angry, almost all of them understood the problem and worked with me and others to change things.These days that means I cancel or skip events. More often I decline to accept engagements in the future to bring balance into life.

This month is tough, with a lot of commitments made months ago, and flying to the UK this week doesn't help. However I've learned a few things about scheduling my time this year and hopefully I'll do a better job next year.

Steve Jones from SQLServerCentral.com

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

ADVERTISEMENT
ReadyRoll

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

GDPR

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

Featured Contents

 

Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3

Phil Factor from SQLServerCentral.com

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them. More »


 

Free eBook: SQL Server Execution Plans, Second Edition

Press Release from Redgate

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? More »


 

Scale-Out SQL Server Integration Services Environment: A Sample Pattern

Additional Articles from Microsoft MSDN

This white paper illustrates how Microsoft SQL Server Integration Services (SSIS) can be used in conjunction with commodity hardware or virtual machines running in Microsoft Azure to build elastic, highly available, and highly scalable ETL solutions. More »

Question of the Day

Today's Question (by Steve Jones):

What's the default file encoding for Python 3 files?

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: Python.

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

Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What two types of collations can be specificed when SQL Server is installed?

Answer:

  • SQL Server collations
  • Windows collations

Explanation:

The type types of collations that can be specified are SQL Server and Windows collations. 

Note:Windows collations should be used for all development.

Ref: Windows Collation Name - click here

SQL Server Collation Name - 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

Lock on SQL data rows - Hi, Can some one please help how can I acquire lock on rows while it is being worked by some one. My...


SQL Server 2016 : SQL Server 2016 - Administration

TempDB - Hello.  i have a doubt about the file size and the autogrowth. I read that is good to initializate the files with...

Mirgrating SSRS 2005 to SSRS 2016 - Greetings and Salutations! I was just wondering if anyone has had the distinct pleasure of Migrating SSRS reports from 2005 to...


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

Strange linked Server problem - I have no problem running this via linked Server, and get a good result set EXECUTE .master.dbo.xp_sqlagent_enum_jobs 1,'' But when I try...

Warning: No Join Predicate (Nested Loop) - Morning Guys, The following query is complaining about having no join predicate on a nested loop EDIT: The Operator Cost is 0%...


SQL Server 2014 : Administration - SQL Server 2014

Excessive Paging Continues... - We've been experiencing "excessive paging" for a while (per perfmon review).  Application is sluggish. Added memory to the server (virtual machine), there's...


SQL Server 2014 : Development - SQL Server 2014

Insert a duplicate copy of any record that meets certain criteria - Sorry for this dumb question but I am very new to SQL. Could someone help me write a SQL code?

General query intended to be Stored Prodedure using optional parameters - I intend to make a stored procedure that accepts several parameters and that has an option not to accept any...

SSIS data truncation. - I have a csv file which I am processing through SSIS. But there are companies in the list which have...


SQL Server 2012 : SQL 2012 - General

HELP ME WITH THE WHERE CLAUSE ( Select records based on a variable value ) - My Issue: I want all the records or ( The ones where  INCLUDE_ME = 'Y' ) to show up based on the value in...


SQL Server 2012 : SQL Server 2012 - T-SQL

Compression - Hi All, If I enable PAGE COMPRESSION on an empty table, when I insert the data (using INSERT INTO command), does...

Help in writing query for update - Can some one please help in writing query. My requirement is I am having 2 columns where I want to load...


SQL Server 2008 : T-SQL (SS2K8)

How to read list of files in folder using T-SQL? - Does anyone know how to read files from spesific folder/path using T-SQL? Regards, Eko Indriyawan


SQL Server 2008 : SQL Server 2008 Administration

SQL SCript for Backup Compression - hi, i am planing to implemnet new backup plan for my databases with compression. can any one share the script to shedule...


Cloud Computing : SQL Azure - Administration

switching to Azure, how to keep dev and prod schema up to date if we plan to use external tables - Hi,  I am creating proof of concept for migration of  db application to azure databases (we plan to take advantage of...


Programming : General

Odd results from WHERE in SQL - So I have a bit of VBA put together to manage the output of data based on selections made from...


Data Warehousing : Integration Services

Granting SSIS access to developers - I'm trying to give access to our developers to SQL 2012 Integration Services without granting server admin, following the procedure...


SQL Server 2005 : Business Intelligence

There is a data source column with no name.Each data source column must have a name. - Hi every body, I am trying to get data in SSIS dataflow task from a strore procedure, but strangly i...


SQL Server 2005 : SQL Server 2005 Strategies

LINQ to SQL and Entity Framework - What do DBAs think of these options? - I am a .NET developer working with a small team of developers who have to also double as our own...


SQL Server 2005 : SQL Server Newbies

SUM of 2 columns in 2 tables THIS IS REALLY SIMPLE - I want to SUM a column in one table and SUM a column of another table and have the two...

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