SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Holidays as Benefits

Today we have a guest editorial from Andy Warren as Steve is traveling away from the office.

Here in the US federal employees will get ten paid holidays this year. Many in the private sector will get the same because they do business with local, state, or federal agencies and if the customer is closed, then they can close also. Many in the private sector won’t get the same ten days, some will get fewer, and some may get a day or two more. For some companies the day after Thanksgiving is an ‘unofficial’ holiday that doesn’t require taking a vacation day.

Those holidays are part of our benefits and combined with sick leave and vacation are how we get a break from work to recharge and enjoy family. We tend to take those holidays for granted – did you ever ask on an interview about the holiday plan? Does the office close on holidays? Are employees expected to work on certain holidays? Is the end of year a quiet time or when all the work gets done (because the customers are on vacation)? I was reminded of this when a friend changed jobs last year, making his last day at the old job a Friday, and only finding out that week that the following Monday was a paid holiday for the old employer but not for the new employer!

A team I work with now has converted four holidays to floating personal days – essentially vacation – and removing four minor holidays from the holiday schedule. That’s an interesting strategy for a company that needs to provide coverage. Employees don’t lose net days off because the company wants to be open on certain holidays and employees are unlikely to argue over who gets to take the day off for Washington ’s Birthday.

Are holidays job trivia? No. It’s all about the value of the day, something you learn quickly as a consultant when you bill by the hour and the client is closed for a holiday. Everyone else gets paid, you try to find something else billable to do for the day. That’s not unfair because the fee charged by the consultant includes something towards netting out at an amount earned per year that covers those “non-working” days.

Holidays are part of the benefit package and while you probably can’t negotiate them, you can make sure you understand what the company offers before you take the job. Are they ever a deal breaker? I bet rarely, but maybe – I’m disinclined to work anywhere that requires me to work on Thanksgiving. Holidays are part of the benefits package, so make sure you look at more than just salary the next time you change jobs.

Andy Warren from SQLServerCentral.com

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

ADVERTISEMENT
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

Webinar

The single question to predict success for DevOps, and what it means for change control

In this 30 minute session, Microsoft MVP Kendra Little will share and discuss her three key insights from the 'Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report' webinar, and show why these insights make a compelling argument for rethinking your organization's change control process.
Register now

Featured Contents

 

Always On - Endpoint Ownership

Ginger Keys Daniel from SQLServerCentral.com

Whoever creates an AlwaysOn group is, by default, the owner of the endpoint. This is generally not a problem…unless that person leaves the company and you need to delete the login. More »


 

Adaptive Query Processing in SQL Server 2017

As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new in 2017, represents a new direction. This set of features provides some flexibility for varying join types, multi-statement table valued functions, and memory grants. In this article, Robert Sheldon explains the three features that make up Adaptive Query Processing More »


 

Spotting Unauthorized Configuration Settings in SQL Server

In this article, Phil Factor explains how to detect any changes in server or database configuration settings, using Extended Events, and a custom metric, in SQL Monitor. He’ll then refine the technique to report on unauthorized drift in the value of these settings, by storing the officially agreed values in an extended property and comparing them to the current values. More »


 

From the SQLServerCentral Blogs - Query Memory Grants and Resource Semaphores in SQL Server

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 »


 

From the SQLServerCentral Blogs - A Play Around With Table Variable Deferred Compilation in SQL 2019

david.fowler 42596 from SQLServerCentral Blogs

Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right? ... More »

Question of the Day

Today's Question (by Steve Jones):

Beginning in SQL Server 2017, we can enable strict CLR security to better protect our systems. If this is enabled, which levels of assemblies are treated asable to call unmanaged code or access external resources?

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

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

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 this data frame in R:

 > HR.hitters rank players Hr 1 23 NA 784 2 25 NA 778 3 25 NA 736 4 26 NA 718 5 27 NA 682 6 23 NA 647 7 29 NA 641 8 30 NA 634 9 27 NA 627 10 31 NA 607 

I now want to add in the years player. I have created this vector:

 > yrs.played <- c(22,23,22,22,22,17,22,22,18,21) 

How do I add my vector to the data frame?

Answer: HR.hitters <- cbind(HR.hitters, yrs.played)

Explanation:

I use the cbind() function to combine the data frame with a vector as a new column.

Ref: cbind() - click here


» Discuss this question and answer on the forums

Featured Script

Mechanism To Dynamically Build Pivot Table

Gaby Abed from SQLServerCentral.com

This code provides a mechanism to generate dynamic pivot tables.  In this case, we're checking backup history to X months, checking average backups each month.
There is a @basequery that can be anything, so long as you place two tags for columns and list, surrounded by << >>.
In this example, if you change @numMonths, you will see those values evolve in the loop if you uncomment the DEBUG: lines.

More »

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

ambiguous column name in delete statement - Inside a stored proc for an ETL process is the following code declare @whereclause_1 nvarchar(400) DECLARE @sql_stmt

Find average of child records within date range - hi, I am working with three different tables: headerTable lineTable and saleDateTable I am trying to figure out average saleAmount (lineTable) for each of the...

check date range for previous year within same table - hi, I have following sample data set: SaleID    SaleMarkdown    StartDate(yyyymmdd)    EndDate(yyyymmdd)  SaleInPreviousYear    previousyearsaleID 1            20%              &nb

How to build an app with GUI that works with SQL Server? - I have to create a project which should have a GUI because people who gonna use it don't know TSQL....


SQL Server 2016 : SQL Server 2016 - Administration

Move old DBs to new existing servers. - I have bunch of DBs I am trying to migrate from old DB serves (2005, 2008, 2008R2) to 2016. We...

Listner - Can I use same listner  when I am have 3 nodes in always on

BACKUPTHREAD wait type - Hi, I'm trying to restore on a SQL Server instance a backup that exists on a different network share (i.e., \\server\share\mybackup.bak)....


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

Need some help/ direction - I'm having a little troubles here. I know I should be able to do this rather quickly, but I cannot...

increment months for two dates combination as a new label column - I have to calculate a new Label column for each combination of Start Date and End Date. If start Date...

Running Concatenation (like running totals) - Hi I have table with the following content ColA   ColB  RowNumber 100      X        1 100      Y        2 200      K        1 200      L         2 200     M         3 From this...

Identifying the 3rd qualifying record - I have a scenario where the client wants to identify the 3rd successful attempt at contacting a customer within 5...


SQL Server 2014 : Development - SQL Server 2014

string to DATE failing when appending to a table. - Hi All,  I ran and import from a flat file with a string date format 'dd/mm/yy', and converted to 'Date' type...

Item category details - I have a below tables and want to get the result as per updated price of items in a query. CREATE...


SQL Server 2012 : SQL 2012 - General

Were are the email addresses stored for SSRS Subscriptions ? Also how can I modify them via code - The following code is the furthest I went on digging in to Report Server. Can anyone help me to find...


SQL Server 2012 : SQL Server 2012 - T-SQL

EXCEPT operator problem - I'm trying to update a set of rows and exclude several, but my EXCEPT operator is erroring: UPDATE a SET a.Address1...

NOT IN vs NOT EXISTS - A little while a go I was told that NOT EXISTS will "never perform better" than NOT IN, and that...

CASE to table conversion - This may be a fool's errand, but I have to try... I have a CASE in my code that checks...


SQL Server 2008 : SQL Server 2008 - General

How to do a basic loop in SQL - Hi all, I have a need to read every record in a table and compare a name in that table to...


SQL Server 2008 : T-SQL (SS2K8)

Split comma delimited field? - Hi I have a field that is comma dellitted (text1,text2,text3) Id like to split the field into separate columns, but not separate...


SQL Server 2005 : Administering

Decrypting program name from sysprocesses for agent job - Hey all, Are there any known ways to decrypt the hex shown in sysprocesses on program name when the process is...

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