Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate Database Devops
The Voice of the DBA


Today we have a guest editorial from Kathi Kellenberger as Steve is away on his sabbatical.

My colleague, Steve Jones, is taking a six-week paid sabbatical from his job at Redgate, and while he’s gone, I’m keeping the lights on at SQL Server Central with the help of Grant Fritchey and Kendra Little. Being away from a job with lots of responsibilities for that amount of time seems daunting to me as I worry about being away even for a week. Six weeks is not that long as people often take off that much time or longer for recovery from an illness or for the arrival of a newborn. The great thing about a sabbatical is that you can spend the time doing whatever you want, for example traveling. I’m looking forward to my turn in about three years.

Steve’s sabbatical got me thinking about benefits in general. Most companies give their employees smaller amounts of time off in the way of vacation, sick time, flex time, and bereavement time. I've worked at jobs that had very little vacation time and at other places that had more that I could even use. Companies often let employees roll over or even cash in unused days at the end of the year. (When management at one company where I worked for several years realized that most of the people in the IT department cashed in lots of days, they took this benefit away.)

Companies can get very creative when it comes to benefits. Some of my favorite benefits involve giving to charities by way of matching contributions. I've used this to my advantage for stair climbing events where I've had to meet a specific goal to participate. I hate asking people for money, so by self-donating half of what was required and then having the custom company match the other half worked well. Some companies also donate money to the nonprofit or give some extra time off to the employee for volunteering.

Some benefits, such as remote work, gym membership, health fairs, and health insurance, improve the wellbeing of their employees, but companies can also invest in the knowledge and skills of their workers with training classes, conferences, and tuition reimbursement. For database professionals who love to learn, these opportunities to enhance their skills also improve job satisfaction.

Bonuses, profit sharing, free legal services, department lunches… The list of possible benefits is endless. Generous benefits may seem expensive, but happy employees are likely to stick around longer, and lower employee turnover ultimately improves the bottom line.

Kathi Kellenberger

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

Redgate SQL Source Control
  Featured Contents

Should I Type * or 1 With the EXISTS Logical Operator

v.malyutin from

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.

Monitoring SQL Server with Splunk and SQL Monitor

Additional Articles from Redgate

Splunk is a search engine for collecting and analyzing all sorts of "machine data", including log data and metrics for SQL Server. SQL Monitor gives you the detailed diagnostic view of all your SQL Server instances, and databases. If you have Splunk to monitor your applications and server infrastructure, and SQL Monitor to help you understand the behavior of a complex database system such as SQL Server, then you have a powerful and capable monitoring tool set.

Prevent SQL Server Blocking using Lock_Timeout

Additional Articles from

In this tip we look at a way to minimize the length of blocking using SQL Server lock timeout.

From the SQL Server Central Blogs - How I passed the 70-761 certification exam

DesertDBA from The Desert DBA

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...

From the SQL Server Central Blogs - Azure Storage tips

James Serra from James Serra's Blog

As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...


  Question of the Day

Today's question (by Steve Jones - SSC Editor):


SQLCMD Variables

I am writing a SQLCMD script in SSMS with SQLCMD mode. I want to set a variable in the script. How do I do this?

Think you know the answer? Click here, and find out if you are right.



  Yesterday's Question of the Day (by Thomas Franz)

Switching Database context in transaction

Which database are you using, after executing the following statements?

USE tempdb
USE master

SELECT DB_NAME() AS current_database

Answer: master

Explanation: Of course you can change the database context when a transaction is open. And since a USE [database] is nothing that would be written in any transaction log, it can't be rolled back. If it would be rolled backed or was forbidden to switch database context while in a transaction it would be very hard to work when you have e.g. enabled implicit transactions in your SSMS (query options). If you were wrong, you may have been confused, because we usually use BEGIN TRANSACTION / COMMIT inside a stored procedure. And in a stored procedure it is not possible to switch the database context with USE [db] (dynamic SQL is an exception to this "rule").

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 - Development
Report Development - Hi to all. I have not worked with SQL for a few years and am not familiar with the new development tools. I have downloaded Visual Studio 2017. I wanted to create a Report Project but do not see this option. Can you point me in the direction of a tool that will allow me […]
Automate Import of LIBOR Rates - Does anyone have any recommendations for sites which publish the daily LIBOR rates in a form which is easy to consume and import? I want to automate this, ideally.
SQL Server 2016 - Administration
SSAS processing Cubes using DTExec vs. SSDT 2017 tools? - Hello We have Analysis Server cubes on SQL 2016/Windows 2019 environment. Using dtexec to process the weekly cubes often fails or if it succeeds then Last Update date is not stamped (Only Last processed date is refreshed) The Error from dtexec is: Description: Server: The current operation was cancelled because another operation in the transaction […]
SQL Server 2016 - Development and T-SQL
Replace cr/lf not working with Japanese characters - I tried many different ways and built a function to basically go character by character checking the unicode values of 13,10 but why doesn't this simply work. tried char(13/10), nchar(13/10), etc... SELECT REPLACE(REPLACE(txt,NCHAR(0x0D),''),NCHAR(0x0A),'') broke, REPLACE(REPLACE(wrks,NCHAR(0x0D),''),NCHAR(0x0A),'') wrks FROM ( SELECT NCHAR(65404) + NCHAR(13) + NCHAR(10) + NCHAR(65438) + NCHAR(65412) txt, N'test value' wrks ) data  
Administration - SQL Server 2014
Archive CLOB data - Dear All, How to archive a table having 10million records with one CLOB column? To select of 1 day records (approx~400) it takes around 5 minutes and without the CLOB column it completes under a second.  
Development - SQL Server 2014
substring + chrindex -   Good morning all i need your expertise to help me on a code the goal is to extract part of a chain create table DATACONTENT ( line varchar(max) ) insert into DATACONTENT values ('\\A1-SRV-05\REPRISE-sollyaza\Allian_ged\NOVAXEL\ALLIAN_1\C842183\CARREFOUR SANTE REPRISE\160010210006\documents entrants\Courriers divers_12470290.pdf') insert into DATACONTENT values ( '\\A1-SRV-05\REPRISE-sollyaza\Allian_ged\NOVAXEL\ALLIANZ_1\CAL000010\Volvo Allianz\VAZP100027\documents entrants\001-Doc 02 mars 2018 à 1640_22459358.pdf') insert into DATACONTENT […]
SQL 2012 - General
Facing connectivity issues - Hi All, I am seeing below connectivity error while executing queries on a database. how can we fix this. ERROR: Transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)   Brief background: If we connect to a jump server and […]
SQL Server 2012 - T-SQL
SPN troubles - once more... - HEllo, I've been looking trough the forums on topics about setting and removing SPN's In the end i've found a good tool that created a working SPN (Kerberos Configuration Manager - found it here But because i'm often trying stuff it sometimes gets fd up... sorry.. The ony thing i'm left with now is 2 […]
SQL Server 2019 - Development
Unix Timestamp to Datetime Conversion - Hi, I have a table with one of the column [last seen] nvarchar datatype and data imported from .csv file. Data in the [last seen] column is in Unix Timestamp in MilliSecs format [1575944000000] I need to convert it from unix timestamp to datetime format.   Tried changing the datatype of the column from nvarchar […]
Storing results in tables with dynamic names - Hello, I have this loop which creates a bunch of matrices based on the month_nbr (in this case 1-36). What i want to do is to store the 36 results from this loop into separate tables with the names Matrix_1, matrix_2 and so on. I need these tables stored as i will multiply them using […]
Help with SQL query - Hi Guys, Here is my "Sample" source data. ID,DKey,SKey,InvType ,PID,PAmount,CAmount,AAmount 1 ,123 ,456 ,Write-Off,789,$505 ,$767 ,$262 2 ,958 ,258 ,Invoice , , ,$621 , Here what I want or the end result ID,DKey,SKey,InvType ,PID,PAmount,CAmount,AAmount 1 ,123 ,456 ,Invoice , , ,$767 , 1 ,123 ,456 ,Write-Off,789,$505 , ,$262 2 ,958 ,258 ,Invoice , , ,$621 […]
SSRS 2016
calculated field based on values - My report is based on a stored procedure and the columns are outputted to a table in the report. I would like to create a expression as a percentage which I require help with? At the moment, I have a shared dataset pointing to the SP, so if possible, can this expression be created in […]
Dynamic Connection String for Dataflow Task - Hey Guys, I've been tasked with doing a task where I connect to a number of different sql servers, pull audit logs, and combine them into one table on our DBA instance.  I've seen MANY posts about this online, read through, followed the steps that I can mirror on my own here but it doesn't […]
Integration Services
Data Stage to SSIS Migration. I want to use the existing unix scripts in SSIS - Hi, I am working on a project migrating from data stage to SSIS. There are several scrips written in Unix that I want to reuse in SSIS (if it ca be and if it's a good idea). Is there any way I can use the same in SSIS task or what should be the way […]
SQL Server and Sharepoint
Usage of Performance Point report on Share point site - I dont use share point regularly so this could be easy but struggling to find the answer. I am trying to find out who is using our sharepoint sites and i can see how to get audit data. This includes who is accessing documents, links etc. but we have few performance point reports (.aspx). This […]


RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the This newsletter was sent to you because you signed up at
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -