Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge
Editorial
 

The SQL Community Steps up in Time of Need

Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on the ears. Enthusiasts of 3D printing have begun printing these ear protectors and shipping to hospitals and other facilities to those who need them.

I first heard about this idea from Tim Radney (@tradney) from SQL Skills. It wasn’t long until Tim’s boss and owner of SQL Skills, Paul Randal (@PaulRandal), also joined in. Since I bought a printer last year for something educational and fun to do with my grandkids, I decided to begin printing them as well and have printed about 150 of the straps so far. (I have a new, faster printer arriving in a few days that will help me boost my production.) Quite a few others in the community are also printing the straps and other supplies.

I decided to spend some time chatting with Tim and Paul to learn more about how they got started.

Kathi: How did you hear about 3D printing the ear protectors?

Tim: I got started when a former co-worker tagged me in a post about a Boy Scout remixing the NIH mask strap to make it use less filament and print faster.

Paul: I was first told about it by my daughter, a HS senior, who read about another senior doing it. Then Tim told me about it later that day.

Kathi: What happened next?

Tim: I printed a few and posted on Facebook tagging a few friends and relatives in the healthcare industry asking if they could use these. That immediately sparked a huge interest, so I made another Facebook post making it public so others could share.

Paul: I started printing them immediately, and I happened to have ordered a second printer at the end of February anyway, so put that to use as soon as it arrived.

Kathi: What has the response been like?

Tim: Within a few days I had nearly 4k straps requested. I've since bought 3 additional printers to try to keep up with the demand. These are all free including shipping to any healthcare worker. I've had many offers to help by providing filament, stamps, and donations to purchase filament. The interest and need for these straps has NOT gone down.

Kathi: Any advice for people in the SQL Server community who would like to do this?

Paul: If you're printing in PLA, that can't be sterilized (that's what I'm using). If you're printing in PETG, that can be sterilized in an autoclave (that's what Tim is printing). And don't be fooled into buying the cheapest possible printer, as you'll end up having a bunch of problems with it. In the US, you can ship about 100 of the straps in a USPS flat rate shipping box for about $8. It's also a good project as a distraction from work and the news.

Tim: I have a blog post that can tell you everything you need to know!

Thanks to Tim and Paul for sharing their stories. I'm so proud of the SQL Server community for stepping up and using their talents to help make the world a better place!

 

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Administration

Quickly Query Database and Log Size in T-SQL

As a consultant, I have to be able to quickly spot problems, and one of the problems I frequently find is transaction log files that are incorrectly sized.

SSMS: Search and replace across multiple objects in a database

Here’s a quick tip that touches on one of the powerful SSMS tricks in my “Management Studio Level-Up” presentation.

Database classifications have changed

Some time back I wrote about the new data classifi...

Switching multiple databases to FULL recovery model.

To switch a database from simple to full recovery model, it is simple to do when you have one or two databases that need to be switched. You can...

Cleaning Up Registered Servers

Another post for me that is simple and hopefully s...

Should I install SSMS on a server running SQL Server?

There’s a lot of advice out there on the internet that suggests that you should not install SSMS on your database servers running SQL Server. This came up at...

Remember this if you want to use sp_

Erik Darling, of Erik Darling Data (blog | Twitter...

Move All Your SQL Database and Log Files in Bulk

As always, the script from this post can also be f...

It’s 2020, Do I really need to DBCC CHECKDB?

I’ll start by saying that I swear I posted this ...

Azure DevOps

How to restore a deleted Azure DevOps repository

If you are using Azure DevOps, you might be comforted that your Git repo is “in the Cloud” and automatically has availability and disaster guarantees. However you (or someone...

Azure Synapse (SQL Data Warehouse and Data Lake)

Azure Synapse Analytics confusion

I see a lot of confusion among many people on what features are available today in Azure Synapse Analytics (formally called Azure SQL Data Warehouse) and what features are coming in the future.

Backup and Recovery

Backup History and Information

How long a database takes to backup is something that over the years I have been asked to get. These requests come for different reasons,

Conferences, Classes, Events, and Webinars

EightKB – A new virtual SQL Server event

With all the events that have been cancelled over ...

Data Science

Forecasting Best Practices, from Microsoft

Microsoft has released a GitHub repository to share best practices for time series forecasting.

Database Design, Theory and Development

What is the datatype SQL VARIANT

The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data.

The Conceptual Model Strikes Back!

“You must unlearn what you have learned” (Master Yoda) The “conceptual” level of Data Modeling has been a stepchild for many years and is mostly forgotten in fast-paced delivery...

Codd’s Twelve Rules

Dr. Codd proposed the normalization rules we used to design databases, but did you know that he also came up with rules that vendors must meet to call their...

DevOps and Continuous Delivery (CI/CD)

Why Unit Testing in the Database Is Tough

Hamish wants to develop a conversation about unit testing within database because he recognises that the lack of unit testing is a significant problem.

T-SQL Tuesday – #125: Unit Testing Databases

It’s T-SQL Tuesday time again! March felt really long for a lot of us as we got used to our new way of life, so I’m excited we made it to April’s prompt.

Notebooks

Jupyter books in Azure Data Studio

Jupyter Book: A collection of SQL, PowerShell, and Python-based notebooks and markdown files. In a recent Channel9 segment, Vicky Harp…

Performance Tuning SQL Server

SQL Server 2017 cu17 ColumnStore Workload OOMs Part 1

A support ticket concerning this behavior is open with Microsoft. SQL Server 2017 CU20 has not been evaluated for this behavior. Although no published fix included in CU20 appears to address this behavior, it's possible additional affects of the documented fixes address the behavior.

An approach to index tuning – Part 2

Erin Stellato concludes her two-part series on her multi-step approach to index tuning in SQL Server. The post An approach to index tuning – Part 2 appeared first on SQLPerformance.com.

The SQL Server Performance Tasting Menu: Out, Damn Sort

Shook Spear …

SQL Server Troubleshooting and Performance Tuning – Observer Effect

I hope you are OK during those turbulent times! People often ask me about my most curious experience in SQL Server consulting. Well, as many of my colleagues, I...

PowerPivot/PowerQuery/PowerBI

Power BI Governance – Why you should consider to disable Export to Excel

Recently, I posted a poll on Twitter to vote for new blog topics. One thing that popped-up in my mind, was more on the governance side of Power BI.

Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh

Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you...

EASILY create a Hierarchy in Power BI Desktop

Learn to easily create a hierarchy in Power BI. Th...

3 Favorite Options in Power BI Desktop

Power BI has a lot of options you can set. Here ar...

Professional Development

Working From Home For The First Time

Many people are working from home now thanks to the COVID-19 (aka the Coronavirus) bug that’s running through the world like mad. Some people (like me) work from home...

3D Printing for Covid19

A friend tagged me in a Facebook post about a surg...

Python

NumPy – Say Bye to Loops

It is said that Python, compared to low-level languages like C, improves development time at the expense of runtime. But there are a handful of ways to speed up operation runtime in Python

R Language

Saving R Graphics across OSs

R is known for it’s amazing graphics. Not only ggplot2, but also plotly, and the other dozens of packages at the graphics task view.

T-SQL

New Metadata-Only Column Changes in SQL Server 2016

The ALTER TABLE ... ALTER COLUMN command is very powerful. You can use it to change a column's data type, length, precision, scale, nullability, collation…and many other things besides.

SDU Tools: Currencies by Country in SQL Server T-SQL

I recently posted about how we added Countries and...

Tools for Development

GitHub sharply slashes plan pricing, offers core features for free to all

The lowest-tier paid plan is dropping to $4 per se...

SQL Prompt Fixes Poor Order By Coding

SQL Prompt is a fantastic coding aid, but it does ...

Virtualization and Containers/Kubernetes

SQL Server and CPU Hyper-Threading in Virtual Environments

I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains.

 
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. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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