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

Daily Coping Tip

Explore a new area today, however small

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

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.

Essential Operations

It would seem obvious, but IT Operations staff are often essential to ensuring that systems and business can keep running. From websites to email to VPNs, many of the companies in which I've worked don't have systems that will run without someone keeping an eye on them. Sometimes many eyes on a daily basis if we want to ensure that clients can log into applications and use them.

The pandemic of the last year has shown many organizations that workers can get their jobs done from any location. Very few of us actually touch the physical hardware that we might manage, but we do need access to those systems across networks, in a secure way. That might not have been as big a challenge as getting the rest of a company online, but it was a lot of work.

I don't know how many people prioritize or consider IT operations an essential worker. This article makes a case that anyone working in IT Ops ought to be classified in the same way that health-case workers, teachers, and more. These workers were needed to keep the world moving forward, so why not recognize the importance of IT Ops along with these other types of workers.

I do agree that Operations staff need to be treated as important pieces in an organization. Even if you use a lot of DevOps automation, GitOps, Infrastructure-as-Code, and cloud resources, you need staff to track, configure, manage, monitor, and adjust the way things work. There likely isn't any organization that has an infrastructure they can run without any humans involved on a weekly basis. Likely something would break in that time and you need some staff.

While you might consider the operations staff to be more replaceable and less valuable than developers or others, keep in mind that bringing someone up to speed on existing systems and ensuring they can run without service interruption isn't as simple as just grabbing a new worker from some temp agency.

If you use computer services from your company, remember that someone is ensuring they continue to run smoothly for you, even if you don't realize what they are doing. Remember there is someone that is behind the scenes, often during nights and weekends, patching, upgrading, and monitoring equipment. Thank them, send some appreciation, and acknowledge their effort the next time you have the opportunity. I've done that job, and I know it can be thankless. I'm going to take a moment and drop a note to my own staff, who really make my life much easier.

Steve Jones - SSC Editor

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

 
 Featured Contents

Dynamically Add a Timestamp To Files in Azure Data Factory

diponkar.paul from SQLServerCentral

This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example, if the input Source file name […]

SQL Server Security – Fixed server and database roles

Additional Articles from SimpleTalk

Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.

From the SQL Server Central Blogs - The Diverse Data Platform–Dativerse.io

Steve Jones - SSC Editor from The Voice of the DBA

The other day I got a note from Ben Weissman the other day that he was running a new event,  http://dativerse.io/. Not much information, but I liked this list...

From the SQL Server Central Blogs - Extended Events and Azure SQL Database

Grant Fritchey from The Scary DBA

Knowledge of how your system behaves is vital to better control, maintain, and grow the system. While Azure provides all sorts of wonderful assistance within Azure SQL Database, you’re...

 

 Question of the Day

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

 

Comparing Execution Plans

I am trying to work on tuning a query. I want to look at the two execution plans for the two versions and compare them. What should I do in SSMS v18.6?

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)

An Empty Integer Numpy Array

I am creating an empty numpy array, but I want the values stored in here to be integers. What do I add to this code:

import numpy
a =

Answer: numpy.empty(shape=[0,0],dtype=int)

Explanation: The empty() function in the numpy module will do this. If the first parameter is named, the second must be as well. The dtype parameter will set the type. The default is float64. Ref: numpy.empty - https://numpy.org/doc/stable/reference/generated/numpy.empty.html

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
Delete data - Just to get some thoughts. I am looking to delete data from a large table in  SQL Server database that is part of availability group with 4 additional secondary replica's in Async mode. Other than performing delete in batches what other care should be taken. I am running against test databases and noticed the deletes […]
SQL Server 2017 - Development
MySQL To TSQL - Please assist in transforming this mysql code to tsq please?   SELECT date(o.created_datetime) as Date, od.product_uid as 'Product UID', p.manufacturer Manufacturer, p.bmc BMC, p.brand Brand, od.label as SKUs, p.selling_unit as 'Unit of Measure', ROUND(if(od.amended_quantity is not null, od.amended_quantity, od.quantity)) as 'Units Sold', ROUND((if(od.amended_quantity IS NOT NULL, od.amended_quantity, od.quantity))*p.content,2) as 'Sales Volume', ROUND((if(od.amended_quantity is not null, […]
SQL Server 2016 - Administration
Profiler Trace - Hi, I am aware of capturing the trace for a single user database by adding the DB name in the column filters. If I have to filter the trace only for 2 user databases, how can I add one more database name in the column filter which says LIKE 'TESTDB' ( example) ? or just […]
Help with detecting and sending alerts for lengthy blocking - Over the weekend we had 2 ETL jobs that were causing unresolved blocking with each other. One reading data the other inserting and updating. The jobs had been running for 45 hours in the blocked state. This was only resolved after one of the processes was killed. I'm looking for some help with the best […]
Sp_server_diagnostics for WorkerThread - Hi there, I am seeing excessively high number of worker threads when running Sp_server_diagnostics. My question is around the 3 figures: "queryProcessing maxWorkers="704" workersCreated="756" workersIdle="206""and how to interpret them. As you can see from the above we are certainly exceeding the maxWorkers  but I'm trying to understand if workerIdle comes into play here. Does this […]
Database going to Recovery, while accessible. - one of the 3rd Party DB's is going to recovery state. Whithout any reason I could find. The log shows one DBCC CHECKDB after another is running on that database. Strange, I can access and query the db in ssms. I did repair_rebuild and it is working again, but after some time the problem arises […]
SSIS package cant open and find - Hello when I log in get this error: What is another way find and open ssis package?
OPeratos from SQL Agent add extra email - Hello I have 2 operators and I need to send from sql jobs 2 times only that my jobs successful completd, is it any way add adtional email to operator or add 2 operators to sql job?
SQL Server 2016 - Development and T-SQL
ExecutionLogStorage Returns No Records - SSRS - Hello, I am trying query the log for SSRS. I queried ExecutionLog3 table but did not get any records. Logging is enabled and retention period is 60 days. The ExecutionLog3 / ExecutionLogStorage is expected to have the data logged into it. What could be the reason for it to return 0 records? Can it be […]
Development - SQL Server 2014
how checksum works? - Could you please me how checksum work in the SQL statement ? below is an example. SELECT * FROM Tablename1 WHERE CHECKSUM(*) NOT IN (SELECT CHECKSUM(*) FROM TableName2) 2. and there is page checksum and database backup checksum, and what does it do while page checksum and database backup checksum? thanks!  
SQL 2012 - General
How to make group to data on pivot sql server ? - I work on SQL server 2012 i need to make group by to pivot data repeated inside pivot so i need to make group by TO FINAL RESULT PIVOT this is my sql script meaning i need to group by to data result from excute @sqldata so How to do that please DECLARE @result NVARCHAR(MAX) […]
Availability Group Questions - Folk, I hope this message finds you well I have two issues with Availability Group that I am hoping to get some feedback on Issue One: Application not working when failed over to different server The issue here is that when SQLServerA is the primary node the application works fine.  When we failover to SQLServerB […]
SQL Server 2019 - Development
Archiving data to a read only file - Hi there I have a table for which archiving functionality is required. Now I have thought of writing sonmething in t-sql to use BCP to write to csv or caret delimited file There is a requirement that this file be made tamper proof and read only. Apart from setting the file attribute to read only, […]
Filtering a hierarchy-related query - I've got a table with LOTS of data. It's a tree-structure (using hierarcyId datatype) and I want a query to get all of them UNLESS they have a parent that's flagged as "Inactive" in the database, then I want to skip everything that's inactive and below. I hope you get it. If possible I want […]
Issue connecting to sql server 2019 - Hi All have been having issues connecting to Sql 2019 server this morning. Please see message I'm getting below. Any help would be greatly appreciated
 

 

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

 

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