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

Too Large a Workload?

This editorial was originally published on Jan 30, 2015. It is being republished as Steve is traveling.

I often hear the technical staff in many organizations complaining about the amount of work they are tasked with managing. Plenty of technology professionals view their jobs are stressful, and I've had no shortage of people say they would never recommend their job, or even this industry, to others as a career choice.

That's unsurprising to me, which is a little sad. I've felt that we face a dilemma in this industry. Our skills are easy to acquire, with any of us able to learn new skills and gaining knowledge as quickly as we are able. Often, our ability to learn is limited only by the time and effort we put into understanding a skill, not any external factor.

However that also means that our employers seem to expect that we can learn without training, quickly, on our own, and that we can instantly be experts that make computer systems do our bidding. When we can't respond quickly enough, or as quickly as we did for the last request, our managers feel that we're just being lazy this week.

Perhaps we do respond quickly, and get tasked with even more work. This might not be the case for most of you, or even many of you. I'm sure plenty of you are in situations where your managers understand the complexity of your jobs, but I wanted to ask about your situation:

Do you have too large a workload at your current job?

By this I mean, do you feel you're not able to get enough work done in a reasonable work week and you feel pressure to work longer hours. Are your managers asking you to do more than you think they should? Or do they appreciate that, like many endeavors, working with technology takes time.

Certainly I think many of us could work more efficiently by automating tasks, but depending on the variety and complexity of tasks, as well as the amount of time you can invest in completing future work quicker, you might be stuck in situations that just require more hours. If that's the case, I hope your workload isn't too large, but let us know.

Steve Jones - SSC Editor

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

 
Redgate SQL Monitor
 Featured Contents

Ordering T-SQL Scripts with Git and PowerShell

pauls 72822 from SQLServerCentral

Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.

Insert Statement Without Column List (BP004)

Additional Articles from Redgate

Many production databases have failed embarrassingly as a result of INSERT code that omits a column list, usually in mysterious ways and often without generating errors. Phil Factor demonstrates the problem, and advocates a 'defense-in-depth' approach to writing SQL, in order to avoid it.

From the SQL Server Central Blogs - Deploying SQL Server to an Azure Container Instance using Terraform – Part Two

dbafromthecold@gmail.com from SQLServerCentral

In a previous post I went through how to deploy SQL Server running in an Azure Container Instance using Terraform. In that post, I used hardcoded variables in the...

From the SQL Server Central Blogs - CREATE DATABASE failed on SQL Server FCI cluster: Only formatted files on which the cluster resource of the server has a dependency can be used

Basit Farooq from SQLServerCentral

Problem Today, I have a request to create a new database on two-node SQL Server 2016 failover cluster instance, which is in an active/passive configuration. I connected to the...

 

 Question of the Day

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

 

Remove the Grant

I create a new role, called Sales, in my database. I run this:
GRANT SELECT, INSERT, UPDATE on dbo.CustomerDiscount TO Sales
After adding other permissions, I realize that we don't want users to change data already in this table. What code do I run to remove this ability from the group?

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)

Memorial Day

Completely unrelated to databases, but since I like sports: which of these takes place on Memorial Day in the US (Since 1986)?

Answer: NCAA Division I Men's Lacrosse Championship

Explanation:

The Men's Lacrosse Championship for Division I always takes place on Memorial Day. The  Women's Championship for Lacrosse is the day before.

Ref: https://en.wikipedia.org/wiki/NCAA_Division_I_Men%27s_Lacrosse_Championship

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
error Output File cleanup does not delete files script d'olla - Hello everyone, I use olla scripts in my backup and maintenance operations there is a step that overwrites the old log file Output File Cleanup this and it comes out with an error Message Run as user: xxxxx \ SQLAGENT2K8QUA. ... 20190214_220307.txt "Access denied." Q: \ Backup \ log "\" DatabaseBackup_FULL_0xBEE0AC49E7982D49842F71412C701125_1_20190228_220234.txt "Access denied." Q: \ […]
SQL Server 2017 - Development
Primary Keys - What is a good way to determine which combinations of fields should make up a primary key?
Reading data from 0x05 - Hi We currently have a table, with a column of a varbinary(MAX). This contains data which precedes with 0x50 – from what I understand means that the data has a ZIP format and I believe it has been compressed. We need to be able to read this data.  I know that this is a .docx […]
SQL Server 2016 - Administration
Linked server error 18456 - Hello Team, Iam getting the below error while creating the Linked server with windows authentication. Msg 18456, Level 14, State 1, Line 88 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.    
Lock Request Timeout period Exceeded Error 1222 - A long running job is doing a SELECT INTO a table, so the table gets created at the same time as it's being populated. If I try to expand the DB's list of tables, I get the error "Lock Request Timeout period Exceeded Error 1222"   Is there a way to get around this ?
Error: Nonqualified transactions are being rolled back - Every morning, the Prod Backup file is copied to the Reporting server, and restored. This morning, the restore step seems to have completed, but the step shows the following error, causing the overall job to fail, so subsequent steps did not run. Thoughts on the cause(s)  for this on a just restored DB ? Error: […]
Restore DB - what is the procedure to restore a database of size 2 TB with a  minimal down time ?
Migrating from (mostly) 2K8 to 2016 - HI all, About to start this project and would be grateful for any good comprehensive articles rated highly by the good folks here at SSC TIA  
SQL Server 2016 - Development and T-SQL
Organizing and cleaning up AS400 DB2 data in SQL server - I've been dealing with data migration out of ancient AS400 piece by piece through linked server connection and I'm having hard time figuring out the best way to structure everything into more or less decent way.  I'm joining multiple tables into views to get a piece of data I'm looking for and then creating tables […]
Development - SQL Server 2014
TLS 1.2 configuration with MS SQL 2014 - Dear Gurus,   I have MS SQL 2014 Installed with following configurations. Windows 2016 SS. MS SQL 2014 + SP3 64 Bit EE. TLS 1.0 Client : Disable Server Disable TLS 1.1 Client : Disable Server Disable TLS 1.2 Client : Enable Server Enable ODBC Drivers : 64 Bit: 11(2014.120.6024.00) MSODBCSQL11.DLL Below query works fine […]
Fetching unique record within a stored procedure - I have a table "Mytable" containing a list of IDs. There is a web application and the user logging into the web application is assigned an ID from the table mentioned above. So if 2 users are logging in concurrently, an ID from this table is given to each of the user. The ID and […]
SQL Server 2012 - T-SQL
Net Earned in Triangles without a Triangular Join? - Something I've been trying to figure today is can I achieve a figure for net earned in our insurance triangles without using a triangular join. I'm sure I could do this with a Window Function, but I can't seem to think of a way to do so. The way the figures work is to do […]
SQL Server 2008 - General
Encyrption and change field as same time - Hello all. I am doing this to modify a field and encrypt data in that field: --Update EncryptedName  field with a new name UPDATE dbo.Tbl_Table SET EncryptedName = 'My Name' Where dbo.Tbl_Table .ID = 1234 Go --Encrypt the field. OPEN SYMMETRIC KEY MySymmetricKey DECRYPTION BY CERTIFICATE MySymmetricCertificate; UPDATE dbo.Tbl_Table SET EncryptedName = EncryptByKey(Key_GUID('MySymmetricKey'), EncryptedName ) […]
Duplicate title - Duplicated post. plz ignore
Analysis Services
Need to perform leaf level aggregation - So I have a DW with  a table with some pre-aggregated scores (not my choice) and the counts of animals separated by breed and a date. To calculate the average score across breeds, I need to the following calculation: ([AverageScore]*[CountOfAnimalsForBreed])/TotalCountOfAnimals The problem is that when the cube rolls up for a specific date, it is […]
 

 

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 webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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