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

Daily Coping Tip

If you find yourself rushing, make an effort to slow down a little

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.

How Quickly We Forget

I work for Redgate Software, and over the last few years, we release software often. Like some of you, I'm slightly annoyed at the pace at times. I think almost every time I restart SSMS, which really is about once a week, I find an update message for one of our tools. Often I find the interruption distracting and I delay updates often.

I see the same thing in VS Code, ADS, Chrome, Firefox, etc. I get update notices, and I delay or accept them, usually the latter after the former. My phone updates many apps automatically, mostly because I don't care enough, the updates have proven stable the vast majority of the time, and I don't want to make decisions. I've also had the issue of an update being required as I'm trying to do something, like pay for goods or bring up a reservation during travel.

Recently I was on a Zoom meeting with a colleague and I saw they had blurred their background. I've done this in Teams, and I wanted to do it in Zoom. I have a window behind me, and my wife, animals, etc. sometimes interrupt lightly, so I'd like to not distract from the meeting. I searched online, and saw people say there were filters to do this, but I couldn't find it in Zoom.

Then I saw this post, which reminded me to update my system, including Zoom. I needed 5.5+, and when I looked, I had 5.4. Easy fix, but I also looked around Zoom, and I didn't see a check for updates, though it's under the profile. I missed it, and apparently, had missed notifications for updates. I don't often log in, so this is probably me.

However it struck me as interesting is that I've become used to software getting updated automatically. I expect most websites to do this, but also many applications. I don't want drastic change, but I do expect most of my client apps to manage themselves. I don't know I'd want SQL Server to upgrade, but I do think I'd want to have CUs applied. Dealing with those is a pain, even when I only keep 3 local instances for testing.

The thing I've somewhat forgotten is the need to check for updates. Most of the software I use lets me know an update is around, and I can choose to install, delay, or skip. I like that model, and I've gotten used to it, which is a huge change from the experience for most of my career. Moving from actively worrying about updates to passively accepting or delaying them. I suspect this is a trend for the future, for many of as both developers and customers.

Steve Jones - SSC Editor

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

 
 Featured Contents

System-Versioned Temporal Tables - A Case Study

wagner crivelini from SQLServerCentral

A short look at temporal tables and how to deal with the system generated historical tables.

Combine Multiple SQL Server Query Results with Registered Servers

Additional Articles from MSSQLTips.com

Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.

Customizations in SQL Prompt

Additional Articles from Redgate

In this brand new course on the Redgate University Grant Fritchey walks you through the many ways in which SQL Prompt can be customized to suit your specific needs.

From the SQL Server Central Blogs - Query Store as an Upgrade Tool

Grant Fritchey from The Scary DBA

There are a lot of uses for Query Store, but one of the most interesting is as an upgrade tool. We all know that upgrades in SQL Server can...

From the SQL Server Central Blogs - SQLpassion Online Training about Statistics & Plan Caching

Klaus Aschenbrenner from Klaus Aschenbrenner

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...

 

 Question of the Day

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

 

Secure Connections

I have SQL Server 2017. I want to encrypt connections to SQL Server from clients. What option should I use?

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)

Global Git Ignore

If I want to globally ignore certain types of files in my local git install, what easy thing should I do?

Answer: Use git config with the --global and core.excludesfile parmameters to set the global .gitignore file.

Explanation: The core.excludesfile setting is how you set a global set of excludes for your install. Ref: gitignore - https://git-scm.com/docs/gitignore

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
Availability Group - Planning to setup AG group between 4 replica's and 3 are located in the same DC and a DR node in different DC. Between Primary and SR1 it would be synchronous commit for Automatic failover and HA option. Primary Replica - Full, Diff and Log backups & Maintenance Jobs etc. Secondary Replica 1(Synchronous commit) - […]
SQL Server 2017 - Development
Substract 2 values - Hello, I would like to minus from rows. 'Other Cost' minus the rest of the rows. select 1 Period,'Main' Category,100 Value union all select 1 Period,'Cost' Category,5 Value union all select 1 Period,'OtherCost' Category,20000 Value I tried like this but is not working. Can someone guide me. select Period,Category , SUM(CASE WHEN Category='Main' THEN [Value] […]
SQL Server 2016 - Administration
SQL Server Agent issue - I am running into an issue and hoping to get some help. Every time I reboot my server, SQL Server service and agent starts automatically. I see that the Agent is running but when I run a job or any job, I get this error (See screenshot below). I then restart the SQL agent and […]
SQL Server 2016 - Development and T-SQL
Return incorrect numeric value - Hello, I have make this query to return the max numeric value from the right for adding +1 : SELECT CAST(Isnull(MAX(REVERSE(SUBSTRING(reverse(Ltrim(Rtrim(cod))),0,CHARINDEX ('-',REVERSE(Ltrim(Rtrim(cod))))))),1) + 1 as varchar)[NextNumber] From QNC (Nolock) Where qnc.cod LIKE 'NCREC-CL'+'.'+'CMP' + '-'+'%' --This Return : 10 that is incorrect, the correct value must be 11 --if i modify my query and Group […]
Counting Instances in TEXT - Hello Community, I have been presented with the following SQL challenge Find the number of times the words 'bull' and 'bear' occur in the contents. We're counting the number of times the words occur so words like 'bullish' should not be included in our count. Output the word 'bull' and 'bear' along with the corresponding […]
Administration - SQL Server 2014
how to checkf if SQL Server CPU/RAM has bottleneck - how to checkf if SQL Server CPU/RAM has bottleneck? thanks!
service broker endpoint in disabled or stopped state - I had posted a thread some time back and since that didn't lead anywhere, trying to find answers again. Have a alwaysOn group to host sharepoint (SP) databases. SP was set up to use the cluster name for connection. But we noticed that when the failover occurred SP still pointed to the previous primary. So, […]
Development - SQL Server 2014
SELECT Name column from Name Table from either of 2 columns in main table - I have a table that selects an ID Username from the user's Loginname and another ID that gets that info from a program dropdown. The original design saved only the LoginName. Later the additional filed was added for users that login with a generic login. My problem now is how do I display the actual […]
CASE Statement with Dates in WHERE clause - I have a column [BatchDate] that contains dates in text format: 032221 032121 032021 031921 etc.... For days Tuesday, Wednesday, Thursday, Friday, I'm trying to get results on just those days. However, on Monday, I want results from Friday, Saturday, Sunday, Monday, to catch weekend orders. I'm not getting the syntax correct. As well, there […]
SQL 2012 - General
how to do the following operation while the tables under different schema? - how to do the following operation while the tables under different schema? for example, there are two tables with same name but under different schema in the same database, one table saletable under schema A and the other table saletable under schema B, how to do this operation , such as sp_helpindex , sp_spaceused and […]
SQL Server 2019 - Administration
Unable to force Queryplan in QueryStore, failure 8695 - The queryplan looks forced but it's not used. Looking in "sys.query_store_plan" it says last_force_failure_reason = 8695 and last_force_failure_reason_desc = 'GENERAL_FAILURE'. The code 8695 doesn't seem to be documented anywhere (not even MS as far as I can see). Anyone knows better? Thanks alot in advance  
Amazon AWS and other cloud vendors
use SCT to synchronize schema - Hello , I did a SQL database migration to RDS AWS DMS there were missing objects (index, foreign key, founction) Can I use SCT AWS Schema Conversion to add these objects? thanks
General
How can I let system use more CPU and RAM of SQL Server ? - I have a system, when I perform one function (nobody uses this server), it works very slow, but I check the SQL server database(SQL server is 2005 ) CPU Utilization rate is about 15%, and RAM usage is low 6.5GB, the total RAM is 16GB. why the CPU and RAM utilization rate is so low? […]
SQLServerCentral.com Announcements
Email Issues - 23 Mar 2021 - We are experiencing some email issues with our provider, apparently from SPAM reports and filters. Since we are entirely opt-in and do not purchase any emails, we hope this is a misconfiguration that is resolved quickly.
MySQL
Time n Date(Metrics) - I have the following code for time and dates metrics: SELECT DATE(o.created_datetime) as Date, o.store_uid as 'Store UID' , o.uid as 'Order' , o.rating as 'Rating' , IF(o.accepted_datetime < o.driver_ready_datetime, TRUE, FALSE) as 'Switch' , timestampdiff(minute, o.created_datetime, o.accepted_datetime) as 'Accepted Order' , if(accepted_datetime < driver_ready_datetime, timestampdiff(minute, o.accepted_datetime, o.driver_ready_datetime), timestampdiff(minute, o.created_datetime, o.driver_ready_datetime)) as'Invoiced Order' , timestampdiff(minute, […]
 

 

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

 

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