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
 

New Stuff Can Be Scary

I'm learning how to be a net controller for a high frequency (HF) radio network. Nets are a fun way to make lots of contacts quickly. Taking part in a net is simple. You check in with the net control and then you can answer calls or make calls (different nets have different rules). It's all fun.

Then, there's being the net controller.

This is the person who has to check everyone into the computer program to track them. So, you're operating the computer and the radio. Plus, on HF, there's this thing called a pile-up where lots of people broadcast over the top of each other. You have to pluck individual voices out of the mix and get their call signs. Also, you have to follow the scripts for checking people in, controlling the net, and more. You also have to do all this while still sticking to the law when it comes to broadcasts. And if you screw any of this up, you could be messing up people's chances at an award.

In short, I'm a little terrified.

However, learning and expanding your knowledge and skill set are vital. And yeah, learning new stuff and taking on new responsibilities can be scary. It's just a part of expanding what you do. It's no different from learning AWS, Azure ML, or some other technology. Sure, using it and learning it can be fun. Then, you have to implement it into production and your business is going to use it. That's scary.

Just because we're scared of the new technology, new methodologies, and expanded capabilities, that's no reason not to embrace them. As with fear in general, it's not a question of whether or not your scared, but how you deal with it.

Grant Fritchey

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.
AI/Machine Learning/Cognitive Services

How close is AI to decoding our emotions?

Researchers have spent years trying to crack the mystery of how we express our feelings. Pioneers in the field of emotion detection will tell you the problem is far...

Facebook wants to make AI better by asking people to break it

The explosive successes of AI in the last decade or so are typically chalked up to lots of data and lots of computing power. But benchmarks also play a...

Administration

SQL Server Suddenly Frozen? You Might Be Snapshotting Too Many Databases.

Snapshot backup tools like Azure Site Recovery and Veeam are great for sysadmins. They let you quickly replicate a virtual machine to somewhere else without knowing too much about...

SQL Server 2016++, checkdb/checktable, and trace flags 2549 & 2562

 TL;dr Trace flag 2549 is no longer required for checkdb or checktable in SQL Server 2016++. Trace flag 2562 may still benefit checkdb on a system (depends on disk...

Azure SQL Database

Azure SQL Offers Manual Failover for PaaS Resources

Sometime having the right command in place opens up new doors to test things, like a failover for example.  In this post we will take a look at a...

Azure SQL Managed Instance

What’s new in Azure SQL Managed Instance at Ignite 2020

Azure SQL Managed Instance is a fully managed, secure, and always up-to-date SQL instance in the cloud, providing an ideal destination for modernizing your SQL Server applications at scale. SQL Managed Instance is part of the Azure SQL family of database services which include virtual machines and managed databases. Since its inception, Azure SQL Managed Instance (SQL MI) has been continuously improved based on customer feedback, aiming to meet critical requirements of organizations that migrate and modernize their applications in Azure.

Azure Synapse (SQL Data Warehouse and Data Lake)

Azure Synapse Analytics overlooked features

There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and... The...

Career Growth and Certifications

The 4 Presentations I’m Proudest Of, and What Inspired Them

I was thinking back about the presentations I’ve been the most proud of over the years. I’ve written and performed a *lot* of stuff over time, but here are...

Community Interests and PASS

Why I’m Not Speaking at PASS Summit and You Shouldn’t Either

If you saw any of my angry tweets last night, it’s not just because the Saints weren’t good. I’ve been writing a lot about PASS and C&C the for-profit...

Computing in the Cloud (Azure, Google, AWS)

Move a VM with Azure Resource Mover

I use Azure VMs quite often for trying things out, especially when tech reviewing articles for my day job as editor of Simple Talk. Frequently, a special purpose VM...

Static hosting with Azure Blob Storage and Azure CDN

No matter what you need, Azure probably has a solu...

How to Save Money with Your Azure Virtual Machine Demos

Sorry for spammy, SEO title, we got to pay the bills. Sometimes it’s fun to just write some code to solve problems, and not think about the world’s larger...

Redgate University
Conferences, Classes, Events, and Webinars

VMworld 2020 SQL Server session preview

Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview of my session at VMworld 2020 called Hybrid Cloud Architecture for SQL Server Workloads: Deep... The...

DMO/SMO/Powershell

Parse parameter default values using PowerShell – Part 1

Aaron Bertrand talks about a new project involving parsing the default values for parameters out of stored procedure and function bodies. The post Parse parameter default values using PowerShell –...

Data Privacy, Compliance, and GDPR

Why Encryption Isn’t Enough for Database Development Environments

At first glance, encryption may seem like a one-step solution to protect sensitive data in the software development lifecycle. In this post we share why reality is not so...

The fight over the fight for California’s privacy future

Many privacy advocates oppose Prop 24, which would buttress consumer privacy.

Data Visualisation

Google Maps gets a COVID-19 layer

View COVID data as easily as you view traffic or satellite data.

what is a table?

  ...

DevOps and Continuous Delivery (CI/CD)

Why is database continuous integration important?

A very common tenet used when building out a DevOp...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Redis: Understanding the Open Source Data Store’s Primary Uses and Challenges

Click to learn more about author Bassam Chahine. Redis, which stands for “REmote Dictionary Server,” is a speed-optimized in-memory data store most often used as a cache. Redis has...

ETL/SSIS/Azure Data Factory/Biml

Azure Data Factory pipelines: Filling in the gaps

Azure Data Factory is a cloud based data orchestra...

Hardware

ADATA External and HP Portable SSDs Review: Featuring the ADATA SE800 and HP P700

Portable flash-based storage solutions are one of the growing segments in the direct-attached storage market. The emergence of 3D NAND with TLC and QLC has brought down the cost...

The Samsung 980 PRO PCIe 4.0 SSD Review: A Spirit of Hope

It may be a bit later than originally planned, but Samsung's first consumer SSD to support PCIe 4.0 is here. The Samsung 980 PRO was first previewed at CES...

Western Digital Updates Red Pro Line with 16 and 18TB Capacity Points

Western Digital recently unveiled their first energy-assisted magnetic recording (EAMR) HDDs for the retail channel. Today, the company is taking advantage of the same hardware platform with some tweaks...

MDX/DAX

Introduction to DAX Financial Functions – Part 1

Business Intelligence Architect, Analysis Services...

Performance Tuning SQL Server

Starting SQL: Fixing Parameter Sniffing

Mostoftentimes There is a good solution to alleviating parameter sniffing. Ones I commonly use are: Temp tables Changing indexes Dynamic SQL There isn’t really a good place to put a temp table in this...

SQL Server 2019 - the strangest thing happened on the way to my cardinality estimate

Today was kind of a rough day.  It started with a...

Starting SQL: Persistent Problems With Parameters

Pick A Database, Any Database Alright, maybe not any database. Let’s stick with SQL Server. That’s the devil we know. At some point in your life, you’re going to construct a...

I Would Love a “Cost Threshold for Recompile” Setting.

In environments where complex queries can get bad plans due to parameter sniffing, it would help to say that all queries with an estimated cost over X should be...

What’s the Difference between CXPACKET and CXCONSUMER

If wait stats were celebrities, then CXPACKET would be a superstar, showing up in a gauche limo and getting swarmed by nerdy fans asking for an autograph. It would...

PowerPivot/PowerQuery/PowerBI

Power BI Publish to Web can be SCARY!?!

Some don't realize that Power BI Publish to Web is...

Power Query installation.

While I was preparing to work in the new (for me) ...

Power BI Report Performance And The Number Of Visuals On A Page

Speed up Power BI report load times by reducing th...

STOP publishing your Power BI report until you do these 5 things!

Your Power BI report could be slow and not functio...

Product Reviews and Articles

Review: Stellar Repair for SQL Server

I was contacted by Stellar Info quite a while ago....

Hidden treasures of SQL Prompt

You are invited to discover features of SQL Prompt...

Solving the Provisioning Problem in Database Development using Clones

When database development is described, the detail...

Comparing Two SQL Server Databases: When, Why, and How

SQL Compare has a simple premise: it will compare ...

Comparing Two SQL Server Databases: When, Why, and How

SQL Compare has a simple premise: it will compare two databases, a source, and a target, and generate a script that, when executed on the target, will make its...

Product Upgrades and Releases

Microsoft R Open 4.0.2 now available

Microsoft R Open 4.0.2 has been released, combining the latest R language engine with multi-processor performance and tools for managing R packages reproducibly. You can download Microsoft R Open...

SQL Server Security and Auditing

A new malware attack on SQL Server

Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can... The...

Security News and Issues

One of this year’s most severe Windows bugs is now under active exploit

Zerologon vulnerability lets hackers access network crown jewels almost instantly.

Amazon Delivery Drivers Hacking Scheduling System

Amazon drivers — all gig workers who don’t work for the company — are hanging cell phones in trees near Amazon delivery stations, fooling the system into thinking that...

Documented Death from a Ransomware Attack

A Dusseldorf woman died when a ransomware attack against a hospital forced her to be taken to a different hospital in another city. I think this is the first documented...

How to Protect Your Company from Ransomware Attacks

eWEEK DATA POINTS: Cybercriminals thrive on--and use to their advantage--their victims' lack of preparation or overconfidence in what was deployed.

Software Development

Six Tips for Building a Recommendation System

So you want to build a recommendation engine? Whether it is for suggesting videos or developing the latest dating app, recommenders have become a powerful tool for many organizations....

T-SQL

Converting a Datetime to UTC

I was in a need of converting some datetime values...

SQL Server Synonyms

SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article, Greg Larsen demonstrates how to use synonyms and the...

How to use Stopwords and Stoplist to improve SQL Server Full-Text Search (FTS)

Total: 3 Average: 5 The current article is about Stopwords and Stoplist usage. The aim is to make Full-Text Search more efficient in terms of storage and performance. Additionally,...

Cleaning up bad dates–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got some data recently from an online... The...

The Lighter Side

How Tesla plans to make batteries cheap enough for a $25,000 car

Tesla’s big “battery day” event, explained.

We are in possession of a working Xbox Series X

Gaze upon it, but don't expect answers to your questions. Yet.

How the Artemis moon mission could help get us to Mars

“If God wanted man to become a spacefaring species, He would have given man a moon.” The famed rocket scientist Krafft Ehricke uttered those words in 1984. He wanted...

Tools for Development

How to ship SQL Jupyter Notebooks and Books directly to Azure Data Studio by creating an extension in the Marketplace

The recently released Extension Generator for Azure Data Studio has opened up yet another way to ship Notebooks and Books to ADS allowing you to easily author your extensions.

Virtualization and Containers/Kubernetes

Configure HyperV on windows 10 - Part 5

The post Configure HyperV on windows 10 - Part 5 a...

How Enterprises Can Future-Proof Kubernetes Management Platforms

eWEEK DATA POINTS: While the Kubernetes development community has done a commendable job of providing clear and concise interfaces into Kubernetes, the integration of additional tools still requires deep...

 
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. 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

 

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