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

Volunteer For Something

I spent a chunk of the day yesterday, after work, but before working on a new book (yeah, I've got two jobs now), playing with my radios. I was programming the digital one to get it to use my Raspberry Pi as a hotspot (it used to work, now it doesn't). I also spent some time on the HF rig (High Frequency), made a simplex contact in Maryland, and failed to make any contacts in fldigi or JS8Call. Finally I checked into a local NTS net on one of the UHF radios (Ultra High Frequency), just for practice. In short, I played radio. However, I'm also practicing using all these different forms because I'm a volunteer for the local ARES group. I'm looking at joining a couple of other organizations in the area (new town, new volunteer opportunities).

Why?

Because the world needs volunteers. There's just so much that needs doing. Yeah, I'm volunteering with an emergency service (not my first one either), but there are preservation societies for various historic... stuff, food kitchens, Scouting, charitable organizations, churches, Scouts, synagogues, Freemasons, and did I mention Scouts. All of these organizations do vital work for your community. And, I happen to know, worldwide, these organizations are suffering from a severe shortage of volunteers. People just don't engage in these organizations anymore (also, Covid added to the problem, because of course it did). It's a shame. We are going to lose organizations that truly matter.

The thing is, volunteering does a whole bunch of stuff. Yeah, you're helping do some worthy cause, which is reason number one. However, you also get to meet people, make friends and contacts. You get to move, even if it's just going to a meeting. Volunteering is also a great help for your emotional well being. In short, absolutely support the worthy cause, whatever it might be, but also improve your own life at the same time.

So, please, get out there and volunteer. You are needed. Yes. You.

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.
Vendors/3rd Party Products

JPA + Flyway: Database Migration Challenges in Java Apps

Database migration is an essential part of the development process. It includes many challenges: from writing the migration scripts to making them runnable and avoiding loss of data. In this webinar we’ll look at common DB migration challenges and how to overcome them.

AI/Machine Learning/Cognitive Services

Building Ensemble Classifiers in Azure Machine Learning

From SQLShack

Introduction This article is the newest addition t...

Administration of SQL Server

SQL queries to change the column type

From SQLShack

This article covers the different SQL queries to change the column type. We are going to learn how we can change the data type of the columns of the...

How to capture SQL login details with Extended Events

From SQLServer-DBA.Com

An application owner wanted to record the usage of...

How to Enable and Disable Full Text Search for SQL Server Databases

From MSSQL Tips

Learn how to enable or disable full text search for a specific database on a SQL Server instance where the Full Text Search components have been setup.

How to Design Backups in SQL Server?

From SQLServerCentral Blogs

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related to the information to be recovered and the time that it will take to recover.... The...

Building blocks of Extended Events data collection

Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.

Azure SQL Database

Custom Azure Policy definitions for Azure SQL Databases backup retention periods compliance

From SQLShack

This article uses Azure policies to check complian...

Azure Synapse (SQL Data Warehouse and Data Lake)

Performance Improvements to Apache Spark 3.1.2 in Azure Synapse

Azure Synapse Analytics is continually focused on delivering a highly performant and scalable platform for supporting Spark Workload. We are focused on improving the query performance for the typical workload patterns that we see with our customers. By combining the latest open-source updates in Apache Spark with our team’s focus on performance updates we have made significant performance gains in standard TPC-DS benchmarking tests.

Distributed tables in Azure Synapse Analytics

From SQLShack

This article talks about the table distribution st...

Backup and Recovery

Pure Storage Flasharray SQL Server Snapshot Torture...You Kinda Asked for This

I gotta admit, some of you are really hard to convince. I’ve been saying for years that given a large enough database size (or a really small RTO storage based snapshots should be Plan A for recovering the database in the event of a disaster. Yes, you will have a Plan B, likely native backups. And Plan C. Maybe you’ll run out of letters because you’re so paranoid.

Restore SQL Server databases using File Snapshot Backups

From MSSQL Tips

In this article we will look at how to perform SQL...

Danger Danger Danger – REPAIR_ALLOW_DATA_LOSS

From Steve Stedman

Steve Stedman So years ago, when my kids were grow...

Case Studies

The Role of Data Governance in Effective Data Management

From Past News - RSS Feeds

I spoke with four industry experts about the growing challenges in data governance, spotlighting which issues need to be resolved for better data management. The experts: Kelly Symons, Senior...

Community Interests

Boost your skills by joining Microsoft at PASS Data Community Summit

From Microsoft SQL Server Blog

Since day one, Microsoft has been right beside you...

Computing in the Cloud (Azure, Google, AWS)

Not Optimizing Cloud Computing Spend Costs Enterprises $24B

From IT Pro - Microsoft Windows Information, Solutions, Tools

New research reveals that organizations are not ch...

Triggering Function Apps from Azure Queue Storage

From SQLShack

In this article, we are going to learn how to trigger Function Apps from Queue Storage in Azure. Function Apps has been one of the most popular cloud services...

AWS Cloud Builders – Career Transformation & Personal Growth

From AWS News Blog

Long-time readers of this blog know that I firmly believe in the power of education to improve lives. AWS Training and Certification equips people and organizations around the world...

New for AWS Distro for OpenTelemetry – Tracing Support is Now Generally Available

From AWS News Blog

Last year before re:Invent, we introduced the public preview of AWS Distro for OpenTelemetry, a secure distribution of the OpenTelemetry project supported by AWS. OpenTelemetry provides tools, APIs, and...

New Microsoft Learn Modules: Azure SQL IoT and Azure Arc-enabled data services | Data Exposed

From Azure SQL

Looking for the next Microsoft Learn modules to complete? Bob Ward, Buck Woody, and Anna Hoffman give you a run-down of Microsoft Learn, the learning paths they've launched, and...

Conferences, Classes, Events, and Webinars

Database technology trends

Join Matt Schmelzer, Data Systems and Automation - IT, and Jonathan Holck, IT Associate, from Artisan Partners in discussion with Microsoft MVP Grant Fritchey to learn how they implemented a successful infrastructure and what tools they need to support their growing estate.

Monitoring Large Estates at BMW

BMW have been monitoring their SQL Server estate for more than 7 years, but with evolving technology and circumstances, monitoring also needs to change and grow. Join Tony Maddonna in conversation with Redgate's James King, to discover how BMW are handling the challenges.

DMO/SMO/Powershell

Automating SQL & PowerShell Notebook Execution

When I first think about automation, I generally think in the following way: in order to automate a script, we want to ensure that the script itself can be run via a command line interface (CLI) and with almost no user interaction (except for input and output parameters). Now, how do we apply this to Jupyter Notebooks so that we can automate SQL notebooks or PowerShell Notebooks?

Fun With the PowerShell Switch Parameter

From Arcane Code

Introduction Over the last few posts I’ve been c...

How Can I Move a File or Folder from the Command Line Using Windows PowerShell?

From Petri IT Knowledgebase

In this article, I’ll show you how to use Window...

#PowershellBasics: Bulk insert.

From SQLServerCentral Blogs

In my last post I talked about invoke-sqlcmd. It?...

Data Mining / Data Analysis

The Most Dangerous Equation, or Why Small is Not Beautiful!

From Learning Machines

Over one billion dollars have been spent in the US...

Use simulations to evaluate the accuracy of asymptotic results

From AllAnalytics

The field of probability and statistics is full of...

Data Warehousing

Synapse vs Snowflake: The Data Warehouse Debate

From BlueGranite Blog

Data warehousing has become a hot topic for most o...

5 Critical Factors to Consider When Choosing a Data Warehouse Solution

From Dataversity

Click to learn more about author Ammar Ali. We have seen an unprecedented increase in modern data warehouse solutions among enterprises in recent years. Experts believe that this trend...

DevOps and Continuous Delivery (CI/CD)

Google DORA Report Details Best Practices to Speed DevOps

From IT Pro - Microsoft Windows Information, Solutions, Tools

The 2021 Accelerate State of DevOps report from Go...

What you need to know about the Accelerate State of DevOps 2021

From Blog – Redgate Software

Every year, the Accelerate State of DevOps Report ...

DocumentDB/Key-Value/Graph/other NoSQL Databases

Why Johnny Can’t Model: Understand NoSQL Data Modeling and Why You’re No Good At It

From IT Pro - Microsoft Windows Information, Solutions, Tools

Date: Wednesday, October 13, 2021 Time: 01:00 PM ...

General

Building an ETL With PowerShell

There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.

Performance Tuning SQL Server

Optimizing Spark Performance with Adaptive Query Execution

From MSSQL Tips

Learn about performance of Adaptive Query Executio...

Signs It’s Time To Switch From ORMs To Stored Procedures

From Erik Darling Data

Meet Wall There are, unfortunately, some times wh...

Free Query Tuning Practice

From Callihan Data

If you’re wanting to test out your query tuning ...

PowerPivot/PowerQuery/PowerBI

How to show a different contact for each report/dashboard within a Power BI App

From FourMoo

I recently got a request asking if it was possible...

One Click Calculation Group in Power BI

From Guy in a Cube

Calculation Groups in Power BI can be amazing! Pat...

DAX! Uggg – Where do you start? | Power BI

From Guy in a Cube

Not a coder? Don't understand DAX syntax? DAX can ...

Professional Development

Improve Your Presentation Skills by Rehearsing with PowerPoint Presenter Coach

From Cathrine Wilhelmsen

Did you know that the PowerPoint Presenter Coach c...

Software Development Estimation is Hard

From Curated SQL

Andy Leonard makes a point: I recently blogged abo...

How to Encourage a New Generation of Leaders in the Remote Workplace

From Past News - RSS Feeds

Companies are starting to finalize their long-term...

Breaking the cycle of bias in decision making

From AllAnalytics

“Bias is not inhuman. To have bias is absolutely human,” says Banu Raghuraman. If data enthusiasts are going to break the cycle of bias, however, “we have to be...

Security News and Issues

Three Tips for Safeguarding Against Data Breaches

From Dataversity

Click to learn more about author Balaji Ganesan. S...

Epik data breach impacts 15 million users, including non-customers

From Ars Technica

Scraped WHOIS data of NON-Epik customers also expo...

How Tech Companies Can Boost Cyber Defenses: Building a Cyber-First Culture

From Past News - RSS Feeds

Today’s accelerated pace of digital transformati...

Facebook’s latest “apology” reveals security and safety disarray

From Ars Technica

"Hard to say" who is responsible for platform-wide...

Secure Cloud Migration: Beware Identity Failures and Misconfigurations

From Past News - RSS Feeds

According to Gartner, the worldwide public cloud s...

OMIGOD Vulnerability Exposes Virtual Machines Running Inside Azure

From IT Pro - Microsoft Windows Information, Solutions, Tools

New Azure-based OMIGOD vulnerability is easy to ex...

Multifactor Authentication's Impact on Productivity Still Unknown

From IT Pro - Microsoft Windows Information, Solutions, Tools

Multifactor authentication is a well-known method ...

2021 has broken the record for zero-day hacking attacks

From Technology Review Feed - Tech Review Top Stories

A zero-day exploit—a way to launch a cyberattack...

T-SQL

TSQL JOIN Types Sale Continues

From Steve Stedman

Back by popular demand – 50% off our recently re...

Creating a table using the SQL SELECT INTO clause - Part 1

From MSSQL Tips

In this article we look at various ways to create ...

Learn SQL FULL OUTER JOIN with Examples

From MSSQL Tips

In this article we look at what a SQL Full Join is...

How LAG compares to other techniques

LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques

Tech News

Semiconductor firms can’t find enough workers, worsening chip shortage

From Ars Technica

Material costs are rising too, and the shortage wi...

Windows 11 setup warns that you aren’t “entitled” to updates on unsupported PCs

From Ars Technica

It's going to be at least mildly irritating to upg...

European Union announces plans to require all mobile devices to use USB-C

From Ars Technica

Devices using only wireless charging would be exem...

New report suggests Texas’ grid was 5 minutes from catastrophic failure

From Ars Technica

It comes with a long list of recommendations for a...

Tools for Dev (SSMS, ADS, VS, etc.)

Removing a Deleted Column from a Data Masker Masking Set

From SQLServerCentral Blogs

Data Masker for SQL Server is a great tool ensurin...

Virtualization and Containers/Kubernetes

5 Reasons Why Kubernetes Is So Challenging

From IT Pro - Microsoft Windows Information, Solutions, Tools

Among the reasons why Kubernetes is so challenging...

4 Reasons Why Kubernetes Is So Popular

From IT Pro - Microsoft Windows Information, Solutions, Tools

Among the reasons why Kubernetes has been so widel...

Containers: A Short Rant

From Scary DBA (Grant Fritchey)

I find myself doing more and more work with contai...

Container-Native Storage More Compelling Than Cloud-Native

From IT Pro - Microsoft Windows Information, Solutions, Tools

When storage is built into and run as containers, ...

 
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

 

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