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

Daily Coping Tip

Notice 5 things that are beautiful in the world around you.


For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Next Person Up

I have a friend that has had a lot of success in technology. This person was a consultant when I met them, working hourly as I was. Over the last few decades, they have found new opportunities and joined a few large corporations. Eventually this person became a vice president, managing a division. It's an impressive job, with a big salary, lots of travel and perks, and a lot of work.

I had dinner with this person recently and they lamented all the hours and stress that comes from a high profile job. Working lots of hours, constantly in touch with others, and pushed to do more. In some sense, this person felt this wasn't different than some IT jobs they'd had, with less pay but similar hours.

I thought about that for myself. I've certainly worked 100 hour weeks while on salary. I've slept with a beeper on my chest while on call because I knew it would go off multiple times at night and I'd shut it off quickly without waking my wife. I've had the stress and pressure of management pushing and pushing.

I've learned to say "no" quite well in my career. I've also learned to find another job when I felt abused. It's worked well for me, and I think it's the better way to handle things. That being said, I have never made a huge salary, certainly not anything close to what my friend makes. At the same time, I haven't felt trapped in a long time, and when I did, it was my fault.

The thing to remember is that you have to ensure your work and your compensation make sense for you. The trade has to feel fair, because many organizations don't care if you don't. I've not met many companies that would let me work half as much for half pay, even if I cut some benefits. They aren't set up to adapt there, and they usually have options.

For every great job, or at least any well paid job, there are often plenty of other people willing to do the job. For employers that don't value individuals, either you deal with it, or they will remove you and pick someone else. The higher you go into the org chart, the more true this is, and often this is where the sociopathic tendencies of some executives take over.

I wouldn't judge anyone else for choosing their situation, but I do caution you to think about what jobs you take and make the conscious decision to do them. Don't let yourself get caught into a bad situation, which can sometimes be easy to do, especially when a larger paycheck is dangled. Pick the work that suits you and your family and that you enjoy doing each day.

Steve Jones - SSC Editor

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

 Featured Contents

Check Your Backup Compliance Against a Data Management Provider

Pablo Echeverria from SQLServerCentral

As a database administrator, it's your responsibility to ensure the customer data won't get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two options, you have full control over your environment so you can know exactly […]

How to Track Performance of Queries That Use RECOMPILE Hints

Additional Articles from SQLServerCentral

Say we have a stored procedure that has two queries in it, the first query will always get the same plan, but the second query will get different plans and return different numbers of rows depending on which reputation we pass in.

From the SQL Server Central Blogs - Moving to a New SqlClient

Steve Jones - SSC Editor from The Voice of the DBA

DotNet developers, if you’re using the System.Data.SqlClient, stop. Move over to Microsoft.Data.SqlClient now. It’s easy to do, well, it’s relatively easy to say that. The actual work isn’t that...

From the SQL Server Central Blogs - Stress Cases and Data Visualization

Meagan Longoria from Data Savvy

Times are stressful right now. There is an ongoing pandemic affecting people’s health and livelihoods. Schedules are messed up, kids are home. People who aren’t used to working remotely...


 Question of the Day

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


Even More Memory Optimized Table Limitations

In SQL Server 2017, can I truncate a MOT table?

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



 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Wargames Quotes

What is the famous quote from Wargames that the computer says to the young human (through the speech box) when he first connects?

Answer: Shall we play a game?

Explanation: When he first connects, the computer asks him "shall we play a game?". Later, the more famous line is "Would you like to play a game?" Ref:

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 - Administration
SSIS Package on a different server - Hi, I have SSIS on server1 and the database on Sever2. When I try to run the package it runs successfully however when you run it from the web server it says sp_start_job 'job_name' does not exist as the package is on server1 but needs to connect to the databases on server2. What am I […]
SQL Server 2017 - Development
convert dynamic rows to columns in sql server - Hi i have one doubt in sql server how to convert rows to columns dynamically in sql server CREATE TABLE [dbo].[product]( [productid] [varchar](20) NULL, [productEventID] [varchar](50) NULL, [productTransID] [varchar](50) NULL, [productEffectiveDate] [datetime] NULL, [productInvestmentID] [varchar](20) NULL, [productBuySellCode] [varchar](10) NULL, [productClosingValue] [decimal](13, 2) NULL, [productClosingUnits] [int] NULL, [productChangeInUnit] [varchar](20) NULL, [productChangeinvalue] [varchar](20) NULL, [productNAVPriceDate] [datetime] NULL, […]
Workaround maximum length for a nonclustered index in SQL Server - Hi, hope everyone is well. I need to create a unique nonclustered index but that key lenght is 17oo bytes. I know the work around is to create the index with include. My question is: would that index with unique be unique? Will an insert fail if it is breaking the logic of the unique […]
SQL Server 2016 - Administration
Loading & downloading files to/from a Full-Text-Search database - Hello everybody, I come across full-text search (FTS) everytime I study for an MCP. It has some very specific uses which seem very useful. I have been asked as to whether making the user-created files on a particular server searchable is possible by means of FTS. In theory, yes, it is, from what I read […]
Change database owner - Hi All I would like to change database owner in databases which part of AG group and act as secondary replica so when i tried to change the owner , it give me error : "Failed to update database because the database is read-only" What should I do ? Your feedback is much appreciated Thank […]
Administration - SQL Server 2014
How is access (read,write) granted to NT user logins? - I have a user who is trying to edit a Crystal report. She is getting ODBC errors. When I investigate, I first log using her credentials. When I open OBBC32ad.exe and examine the System datasource, the database tied to this Crystal report is not listed in the drop down of Databases. If I log into […]
Index Optimize - Based on my understanding during the index optimize it will not take the whole database down. However, there would be impact on the performance. Do you agree with this? If yes, would you schedule any jobs during the index maintenance?
Development - SQL Server 2014
Search with Full Text Index vs "normal" search - Hello, i need your help because i am feeling bad with Full text index. I need to do a search for clients, so i have implemented a full text index on my table "b_utentes". My code is fine, is working very well. But, someone ask me to do a code without use of full text...ok, […]
SQL 2012 - General
Always on DB - Log huge and no free space - Hi, So I've got an Always on database that is 1.4TB in size, the Always on is working fine but the log file just keeps on growing, as of now is at 683GB in size with less than .1% free. We have regular log backups and I need to find out whats using all this […]
SQL Server 2012 - T-SQL
Adding another table to a query but only wanting the top 1 for each record - I currently have query that gives me the results i needs BUT i am needing to add a new table/column to the query. select name, state, id, (case when = 'GLG' then 'GASB' else end) as app, version, maddr, city, zip,, contacts.sort,, install_date, population, customers.notes, CASE databasetype WHEN 1 THEN 'Vision' […]
SQL Server 2019 - Administration
How to deal with SqlServer PS module - I understand that SqlServer has replaced SQLPS.  I experienced this with SQL 2017.  I'm now putting together a SQL 2019 with server 2019 and I see that SQLPS is still part of an install. PS C:\Windows\system32> get-module sqlps -ListAvailable Directory: C:\Program Files (x86)\Microsoft SQL Server\150\Tools\PowerShell\Modules ModuleType Version Name ExportedCommands ---------- ------- ---- ---------------- Manifest 15.0 […]
Reporting Services 2008/R2 Administration
Why can't I Manage Reports on SSRS site? - Hello, I'm an admin on this SSRS site and I can browse and upload reports with no issue, however, when I click on the report drop down option and select Manage, in order to assign the data source and properties, etc. I keep getting the HTTP 404 error Webpage cannot be found. This site was […]
Expression with multiple IFs - I am trying to create an expression to derive a data column value based off two other data columns.  In English If VARA is greater than three characters long an the first character is "1" then VARB = VARC + ".A" + the last two characters of VARA ELSE If VARA is greater than three […]
Analysis Services
DAX table joins - All, I'm trying to improve my understanding of cubes and DAX but I'm missing something. If possible I would appreciate being pointed in the right direction. My model has two tables - Post and PostTypes. Post is the fact tables and PostTypes is a measure table. There is a link, within the model, between Post.PostTypes […]
pulling multiple numbers out of a string - I need help pulling multiple number values out of a string field name is Details and here are some examples of the values DETAILS Maximum width is 13'2", maximum length is 30'. Minimum total size for all custom rugs is 25 sq/ft. Maximum width is 15', maximum length is 25'. Minimum total size for all […]


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.


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