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

Daily Coping Tip

Be willing to share how you feel and ask for help when needed

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.

Labor Day 2020

Most of this year has been a labor for me, just moving from day to day. The year started out well, and I was excited at first. I didn't think much of COVID-19, assuming this would go the way of SARS, H1N1, etc., with relatively little impact to me. I laughed about it with family on a trip to Las Vegas in February.

Was I ever wrong.

Today is Labor Day in the US, a holiday for those of us here. This was a holiday to celebrate those that work in trades and unions. While those of us in technology aren't often considered labor, as many of us as salaried individuals, we do toil away in what has become a daily grind, albeit a creative one. In the US, this is also the unofficial end of summer, marking the time when many are starting, or about to start, another year of schooling.

I started the coping tips on my blog partially to help the community, but also as a way for me to find ways to deal with the massive changes in life. Despite being an introvert, I do enjoy small doses of meeting other people, being in society, and traveling. All of those have ended for the time being, and finding different ways of coping have helped me during the last six months.

Today, whether you're working along, or reading this on a Tuesday when you get back, I hope you take a moment and reflect on how life has changed across this year. Whether you like or dislike things, you've struggled or sailed through, I'm sure there is a lot of emotion.

I'd ask that you consider having empathy and compassion for others. None of us experiences this the same way, and what might feel like a burden or a trivial event could be tremendously different for others. Even those in my household have all had vastly different reactions to the same event, news, conversation, etc.

I appreciate seeing different points of view and try to respect why others might see the world in a different way from me, but mostly I appreciate the positive messages. I like seeing Chris put out positive ways to start the day. I appreciate Hamish' message of kindness, something I hear during every cherished opportunity to shake his hand. I appreciate Anthony's joy of cooking for his family. Meagan's singing brightened my day. Mala's quick messages and pictures on FB make me smile. There are many more moments of thought, positivity, and joy that I've found, even while struggling.

We are all having good and bad days, up and down times, but most of us are here for each other. Reach out, say hi, check in, and remember that you have friends, even if you can't celebrate with many right now.

Steve Jones - SSC Editor

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

 
 Featured Contents

Downloading a CSV File from an API Using Azure Data Factory

Meagan Longoria from SQLServerCentral

In this article, learn how to use Azure Data Factory with a REST API to download files.

Introduction to Analyzing Waits using SQL Monitor

Additional Articles from Redgate

Phil Factor sets out with the modest aim of giving you enough of an introduction to waits to better understand the wait information you get from a SQL Server monitoring tool like SQL Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events.

How to Use Parameters in PowerShell Part II

Additional Articles from SimpleTalk

PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more.

From the SQL Server Central Blogs - Information Measurement with SQL Server, Part 6.1: Information Gain and Tree Structures

SQLServerSteve from Multidimensional Mayhem

By Steve Bolton …………Like many of my other series of amateur mistutorials, the section of my blog devoted to the broad topic of Information Measurement is ultimately meant to...

From the SQL Server Central Blogs - Cosmos DB for the SQL Professional – Referencing Tables

James Serra from James Serra's Blog

I had a previous blog comparing Cosmos DB to a relational database (see Understanding Cosmos DB coming from a relational world) and one topic that it did not address...

 

 Question of the Day

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

 

Avoiding the transaction

I have this code:
DECLARE @salary INT = 1000
 BEGIN TRAN
 SELECT @salary = @salary * 2
 ROLLBACK
 SELECT @salary
What is the value of my salary at the end?

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)

Syncing Git Files

Which command will send the changes I've made in a local git repository to a remote system?

Answer: git push

Explanation: git push is used to send your changes to a remote repository. pull gets changes from a repository for those branches you  re working on. Fetch will pull the changes from remote branches without merging them. merge joins branches together. Ref: git push - https://git-scm.com/docs/git-push

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
Changing nvarchar to varchar - I have a table with millions of rows in it. The character fields are nvarchar. Currently its only got a clustered index on an autoincrementing Bigint field. There is a requirement to start reporting on the table's contents. If  I add new non-clustered indices for reporting, its size will increase dramatically and inserts will slow […]
SQL Server 2016 - Administration
Cant connect from SSMS. - Any help would be appreciated. So for two days now I can't seem to figure out why I can use SSMS to connect to the instance locally. But remotely I can't connect. I am getting a this error: Cannot connect to MYSQL1100. Additional information: A netowrk-related or instance-specific error occured while establishing a connection to […]
SQL Server 2016 - Development and T-SQL
allocate / deallocate table - I need to delete a lot of rows from some tables. There are millions of rows and only a few thousands should be left afterwards. Based on experience this takes a lot of time and impacts other jobs that use the table. So what I would like to do instead is to: Copy the rows […]
Administration - SQL Server 2014
Windows Failover Cluster - Vmware Snapshot - I am hoping someone can provide some insight into this subject I have been working with SQL Server for several years, but have not had the pleasure of working much with the Windows Failover Cluster Service and Availability Groups.  In my new role I am responsible for both WFCS and AG and have a question […]
unable to take backup - hello, just yesterday, we got an alert that our backup job that i created in maintenance plans failed, the error code doesnt give me nothing to work with, it says: Started: 7:44:32 PM Error: 2020-09-02 19:44:35.79 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [master] TO DISK […]
SQL 2012 - General
Select unique records between several tables - I am looking  for an example on how to query several tables, around 50 tables, to find all unique records between them. I cant find anything other than a join on 3 tables.
How to write update statement to table statusvalues where chemical id have more - How to write update statement to table statusvalues where chemical id have more than one chemical status ? I work on SQL server 2012 I face issue ; I can't update status on table statusvalues where chemical id have more than one status as example 1241 must update status "chemical id have multiple status" because […]
Server Properties: Maximum Server Memory - We have a SQL 2012 Server that had the Maximum Server Memory set about 8 months ago.  We started to receive timeout errors from our applications and when we looked at the Maximum Server Memory it appeared to have reverted back to the default setting. Is there any process, such as a patch, update, or […]
SQL Server 2019 - Administration
How good is SQL server developer Edition - Hi, our management has decided to go with SQL Server 2019 developer edition on test servers. My concern is will there be limitations on using SQL Server developer edition box, when production SQL Servers are having Enterprise edition?  I have already told to my management that backups from developer edition may not work while trying […]
SQL Server 2019 - Development
SSIS Package calling a rest api with JSON outpu - Hello forum.  I'm having to query some ESRI rest api and returning some JSON output.  I have the link and I'm using a data flow using a script component as a source.  I have some of my C# code pulling the data but I'm getting an error, it seems that the esri link is requiring […]
Reporting Services
Color Coding data based on values - Hi Folks: We have SSRS report (2016) with 2 columns Qty1 and Qty2 and want the record colored (red) If the Qty1 and Qty2 are matching. The Qty2 column has records in 5 decimal places and we want to round off to 3 decimal when comparing the values. I need help with formula. In the […]
Upgrading Power BI Report Server from an older release to May 2020 - Hello, I'm looking for some advice from people who have updated an earlier version of Power BI Report Server (August 2018) to a newer release. In this case, the May 2020 release.  I have hesitated to do the upgrade because people are not reporting any issues and I fear that some reports or visualizations will […]
SSRS 2016
How many nested folders does SSRS Report Manager allow? - Hello - Does anyone know how many nested folders does SSRS Report Manager allow? How many folders does the first level allow?  Second level?  Third level? Any help will be greatly appreciated. Thanks! juniormint
Integration Services
Flat File Destination - Displaying Umlauts and Accents - Hello, I have a couple of SSIS packages running, the first package exports data from SQL Server 2014 and saves it to a file share, the second package picks up the file and loads it into Salesforce using the data loader. One of my users has complained that Umlauts and Accent characters do not display […]
Articles Requested
Color code text in SSRS - We have this: https://www.sqlservercentral.com/articles/dynamically-change-background-color-in-ssrs-reports-using-custom-code   However, can I get an example of how to color code negative values as red, and maybe a value that is above some range, say 1000, as green?
 

 

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

 

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