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

Daily Coping Tip

Write down your most important goals for this month

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.

Pulling Together

When the COVID-19 Pandemic grew rapidly in early 2020, medical supplies were in short supply. Different areas and organizations struggled with different types of issues, and one of the higher profile issues was with ventilators. In March, the projections were dire and quite a few hospitals were worried about the supplies of these devices. This was especially disconcerting given how many people were being placed on them and how long it takes to produce them.

I met someone at that time that said getting a car company to produce these wasn't possible. The factories were specialized and converting machinery and people wasn't something that could be done in months. This was someone that claimed to have over 30 years of manufacturing experience.

I had no basis to argue, though my instinct was that we have mobilized large industrial efforts in the past. When I read this article recently, it made me think about that conversation. Microsoft worked with a number of manufacturers to produce ventilators quickly, up to 400 a day in the UK. The story is interesting, and it shows that engineers at companies like Ford, McLaren, Unilever, Rolls-Royce, and more can not only work together, but also focus their efforts in a crisis. With the help of technology and data, they transformed a manufacturing process from the ground up to meet the needs of the UK.

If you watch the video of the effort, it is amazing to see just how knowledge and data are brought together to ensure these devices can be built quickly, and at a very high level of quality. Certainly some PR is involved here, but the keys to success in producing something are the knowledge and skills being applied to a task. Products like dashboards and the Hololens help to move knowledge around where it is needed. In building software, tools like Live Share help to move knowledge from one person to another.

The coordination of people working together, driving to a common goal, is critical as well. DevOps asks us to practice this, choosing to be a team, with the goal of increasing quality while we focus on delivering software to customers. This is a great story, but one that highlights things that many of us could strive for in our daily work.

Steve Jones - SSC Editor

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

 
  Featured Contents

PowerShell Day by Day: Filtering Objects

Frank Dolan from SQLServerCentral

In my last article, The Basics of PowerShell Day By Day, I covered some basics of getting started. These articles aren't intended to replace some of the getting started information in things like the Stairway to PowerShell. Instead, I am covering some of the tips, tricks, techniques, and bits of knowledge that I wish I'd […]

How We Ended up with Git

Additional Articles from SimpleTalk

Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and how git became the popular tool it is today.

From the SQL Server Central Blogs - Running Express Edition in a Container–#SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was looking through the forums and...

From the SQL Server Central Blogs - Microsoft Ignite Announcements 2020

James Serra from James Serra's Blog

Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related...

 

  Question of the Day

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

 

Container Memory

What is the default max memory for a Linux container running SQL Server?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by BTylerWhite)

Unpacking a List in Python

I have created the following list in Python 3:

languages = ['C#', 'Python', 'R']

I decide I want to assign variables to each element in the list by unpacking it.

a, b, c, *d = languages

What is the expected output when I execute the following?

print(b)

Answer: Python

Explanation: Python would be printed. We can unpack arguments out of a list or a tuple using the * iterable unpacking operator and ** dictionary unpacking operators. This works well when we're not sure what the length of the list would be. The d variable will be set to an empty list. If we were to leave out the asterisk on our d variable assignment, we would receive the following error message.

ValueError: not enough values to unpack (expected 4, got 3)

References:

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
Profiler and Tuning Advisor Stats Recommendation - I ran SQL Profiler and did a trace, and after handing the file off to the Tuning Advisor, it had some Index recommendations which is understandable. However, there are a ton of statistics recommendations. The capture I did was only for about 20 seconds. The recommendations were very numerous, but the main thing is that […]
display cluster alwayson in windows - hello , I need your help please in my server SQL on  ssms I can display my avaibility group always on and the nodes and the listen so if I connect through failover cluster manager I have nothing thanks    
SQL Server 2017 - Development
Email CSV file - We have a stored procedure and job that will email out invoices daily. It all works great, however, we are trying to get the current date in the CSV filename. Here is the line we are using now for the filename: @query_attachment_filename = 'test.csv' We are thinking of 3 different formatting options: MMDDYYYY.csv Wynne-MMDDYYYY.csv MMDDYYYY-Wynne.csv […]
SQL Server 2016 - Administration
Rebuliding a WSFC with availability groups - We have been having issues with nodes loosing communication on a underlying WSFC that we have our Production Always on Availability Groups on. The Server provisioning team seem to reckon that the cluster, that they built, is not in the best of shape and are talking about rebuilding all the cluster servers.  Being a DBA […]
SQL Server 2016 - Development and T-SQL
SSRS Int64 Multi Select Report Parmeter error - I have a SSRS report in VS2017 that pulls Int64 values into a Report Parameter named "pCampusEquipment" but fails at runtime with a "The property "ValidValues" of report parameter "pCampusEquipment" doesnt have the expected type" error. The parameter works fine if I changed parameter Data Type to "Text" instead of "Integer" but the SQL Call […]
Pivot with Ranges - This is my table BSEG_ID    DST_ID      BILL_SQ        AUDIT_CALC_AMT                Remarks 12334           REV-WSC      62                   6.40667                                For 0 - 60 (Next 62.000 cubic meter) @US0.10 per cubic meter 12334           REV-WSC      62                  64.06667                               For 60 - 120 (Next 62.000 cubic meter) @US1.00 per cubic meter 12334           REV-WSC      3.6                 11.16                                       For 120 - 180 (Next 3.600 cubic meter) […]
Development - SQL Server 2014
How to get all the column name and data type a table variable - there is a parameter in stored procedure, and this parameter is table variable, How to get all the column name and data type for a table variable? thanks!
SQL 2012 - General
How to select data based dynamically based on start and end of AffectedProduct ? - I work on SQL server 2012 I need to get data from #partsdata table where part number matches Affected Product both start and End as Example where I have Affected Product as APAMS-***G then I will get Parts That have start APAMS- and End by G start must be end with dash (-) this roles […]
SQL Server 2019 - Development
Create string from broken hierarchy - Hi I have a broken hierarchy where I need, for each row, to create a string that contains all possibæe combination ordered by creationdate (id column) So for the 1st row it would be: |96811577|2959885|5825374| as row 3 and 5 contains the same values then the result here should be the same as above. I […]
Issue with Foreign Keys - So recently I began to start a personal project to push my limits and try to gain an edge on database work. I have been using MySQL and I am using IonnDB to make use of the Foreign Key relational system. I wrote a long document of tables that I could copy and paste to […]
Reporting Services
Report acting Differently in SSRS Report Editor and on the Server - Having a really interesting problem.  I've added a subreport to an existing report, by adding a second detail row, merging the columns and putting the subreport there.  Originally I had the subreport set to hidden and visible by toggling a group button (in y case, Division).  Works, but when I run the report the row […]
Integration Services
SSIS : How to export data into Excel from Stored Procedure - I might be barking up a wrong tree,  but hope someone can advise on the forum. I have an established stored procedure, which returns a list of records, e.g. EXEC my_stored_procedure returns idColumn (INT) and descColumn (VARCHAR(50)). Now I have a new task to write SSIS to export same result set into an Excel file […]
Error running simple SSIS package - I have a simple package that loads a small staging table from a CSV file. I create the table (succeeds), truncate it, then reload it via OLE DB.  It fails on truncate table SQL task. [Execute SQL Task] Error: Failed to acquire connection "WIN-3SVP8BUQIEM_SQL_2016.AdventureWorksDW.sa". Connection may not be configured correctly or you may not have […]
PowerPivot
Default values for power bi slicer - In most any data analysis tools a fundamental function is the ability to set a default value for a slicer or report parameter. Power BI being the exception. I know there are dozens of semi effective results in a simple google search to circumvent this glaring deficiency in Power BI. I realize that this post […]
SQLServerCentral.com Website Issues
Changing my username email - Apologies if this has been posted but I did a search on email and profile and didn't find anything similar. I have changed jobs and consequently need to change the my email username. When I go to "Edit Profile" under "Profile" on my user account, I am able to do the changes and it says […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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