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

Daily Coping Tip

Go outside, play, walk, run, exercise, relax

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.

Rough Consensus

The IETF has a document, RFC 7282, also called " On Consensus and Humming in the IETF", in which they describe how the body makes decisions. This is their philosophy:

We reject: kings, presidents and voting. We believe in: rough consensus and running code.

That is a process that I can get behind. Overall, I don't like authoritative leaders. I don't like to be one, though I do recognize as a manager there are times I need to make some decision. Overall, however, I like consensus.

Someone was discussing how to choose approaches when developing software and brought my attention to that quote. With us being remote now, and unable to hum, this person talked about how to solve problems without humming.

This individual talked about identifying solutions in a team, but not taking a vote, or rather, no immediate vote. Instead, they devised a rating system allowing everyone to look at all solutions and rate them from 5 (best solution ever) to 1 (this would be a terrible mistake). They then produce a histogram of the results for each solution.

Once they've done this, they can then have people raise issues and debate them. I assume time limited, which is important, but often when we see different levels of support, we may rethink our rating or the merits/detractions of an approach. At some point, they re-rate the solutions and try to develop consensus.

We won't always agree completely with an approach, but I do think that we can often come to some decision we can support, especially with some rational arguments and reasoning. I'd like to think that I rarely had to overrule an entire group. Building a team means finding ways to discuss, debate, and decide together.

Steve Jones - SSC Editor

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

 
  Featured Contents

Getting Informative SQL Agent Notifications from Failed SSIS Packages

Steve Rezhener from SQLServerCentral

Getting informative error messages when something goes wrong with an SSIS package is critical, especially if you are not in front of your computer.

Get involved in the 2021 State of Database DevOps survey

Additional Articles from Redgate

We’re inviting you to take part in the 2021 State of Database DevOps survey! Now in its 5th year, the leading research on Database DevOps will also explore how DevOps strategies have contributed to the resilience of the database during the pandemic. Complete the survey to get exclusive access to the final report and the chance to win a $500 Amazon gift card. Take the survey here.

Visualizing Azure Resource Metrics Data in Power BI

Additional Articles from MSSQLTips.com

Learn the five steps to perform Azure resource reporting with Power BI in order to embed the reports in dashboards for stakeholders.

From the SQL Server Central Blogs - A quick and dirty scan of a list of instances using a dynamic linked server.

Kenneth.Fisher from SQLStudies

Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently ... Continue reading

From the SQL Server Central Blogs - Serious Thoughts About PASS

Andy Warren from SQLAndy

Back when Covid started I guessed that this might be yet another live-or-die challenge for PASS. PASS is heavily dependent on Summit revenue and uses it to fund all...

 

  Question of the Day

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

 

The ADF Case

How do I structure a CASE statement Azure Data Factory?

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)

sp_query_store_flush_db

What does sp_query_store_flush_db do?

Answer: Flushes the in-memory portion of Query Store to disk

Explanation: This stored procedure is part of the Query Store management procs and flushes the in-memory portion to disk. Ref: sp_query_store_flush_db - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-query-store-flush-db-transact-sql?view=sql-server-ver15

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
Create DB List of latest Cumulative Updates - Hi. How can i webcrawl the internet to get the latest CU details and store them in a database. Instead of me tediously manually doing this, i want to automate it, is this possible? I can use either .net, jquery or can it be done in
Stored procedure that runs quickly in SSMS hangs up in SSRS - I'm attaching a WORD document that lists the T-SQL code in the stored procedure that runs in SSMS, but gets "stuck" in SSRS.  I don't see the problem.  Most of the stored procedures I write for my reports are similarly written with 1 or more #temp tables and I don't have problems with them.  Any […]
How do you convert a timestamp into a date - Hi all Can anyone help me turn a timestamp that looks like this: "1994-10-07 00:00:00.0000000" into "10-07-1994",  then into 10-94? I tried cast(DOB as date) and it came back as 1994-10-07.   Any assistance would be appreciated.  
SQL Server 2016 - Administration
Replication sending same change over and again when doing a batch update - Good morning, I recently set up replication on my sql server - Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) going via AWS DMS, which is then sending the data to a […]
Fragmentation & Statistics - Hi All Was approached with a slow running query. First thing I did was update statistics on the entire DB which improved the performance drastically. The problem is that the performance starts to degrade after about an hour or so at which point I update stats again - I've set up a job to update […]
Sql error log - We have job which is configured to recycle the sql error log on daily basis and its failing with the error DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) SQLServerAgent Error: 32. [SQLSTATE 42000] (Error 22022). The step failed. we renamed the sql error log out file […]
Development - SQL Server 2014
Can I use UNPIVOT - Hi I have a table which I would like to turn columns into rows. create table Customer ( CID int not null, WholeSaler bit not null, ReSaler bit not null, Retail bit not null ) insert into Customer values (1, 0,0,1), (2, 1,1,1), (3, 1,0,0) I would like to get this output CID CustType 1 […]
Table Alerts - I would like to build something as described below. An Insurancetable which has InsurerName, PhoneNumber, InsureAmount and InsureRenewalDateTime I would like to send reminder text messages to Insurer phones everytime they are due on their Insurance at EXACTLY the datetime they are due. What is the best possible way to achieve this from the database […]
How to reduce lock or avoid lock while encoding SQL statement - under active monitor, I found there was very amount of cumulative wait time(sec) for Lock,  now I want to know how many ways to reduce lock or avoid lock while encoding SQL statement, and if there is any way to reduce lock for the database or SQL server setting. many thanks!
Docusign API different UI - We have Apttus via which we use docusign and they use the classic UI of docusign. Now we have enabled embedded signing for certain users and when we invoke the docusign URL, the UI is of the new docusign which is not a consistent User experience. We are using the same account so wanted to […]
Addition of values from two fields - I have an inventory usage table that holds values for different locations and periods. The values are calculated by the ERP so I cannot change the SQL values, but in certain instances, I want to combine the values for two locations into one location and zero the usage for the original location. This would be […]
Azure Data Factory
Data masking using Azure Data Factory Data flows in Pipeline - Does any one have any good videos articles links to on how to do  Data masking of PII information while using ADF V2 though Data flow
Reporting Services
LookUp function weird issue - I AM experiencing a weird issue with the LookUp function. I have a list grouped by certain field. For example employees grouped by city. For each employee i have a columna of the list where i use the LookUp function yo retrieve more info from another dataset. So far everything works as expected. But i […]
? on Setting default value to Year of previous month - Hi, I know =Year(Today) will get me the current 4 digit year. What I need is the Year of the previous month. So if the report is run in January 2021, then the default value is 2020, if it is run in December of 2020, then its 2020   Thanks  
Suggestions
Adjust Canonical url to point to original article - I post on here via my RSS feed. In reviewing the source for the page I noticed the canonical URL is set to the SQLserverCentral website. The canonical URL pointing to my original post is how Google analytics lets me know how many views I've had. Only recently learned about this because Dev.to allows that […]
 

 

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

 

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