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
 

It's All About the Gratitude

I'm writing this the day after the US holiday of Thanksgiving. Lots of things are said about Thanksgiving, positive, negative, in between. The core concept of the holiday is to take a moment to take stock of what you have. It's a good idea. Every so often, look around and acknowledge, depending on anyone's situation, of course, just how good we have it. I for one am grateful for the age we live in. Are there challenges? Enough for everyone. However, we live in an age of wonder, and the overall trajectory seems to be up. I'm extremely grateful for the past. I'm optimistic for the present, and I'm excited for the future. We'll see what it brings. Regardless, taking stock, I'm just grateful and don't have a problem saying that.

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

Bulk Loading Data via a PowerShell Script in Flyway

How to quickly and automatically bulk load test data once Flyway Teams completes a database migration. A baseline migration script creates the empty database version, which then triggers a PowerShell callback script that bulk loads in the right version of the data. It is a very fast way to provision multiple copies of a specific database version, complete with data, for ad-hoc or automated testing.

Adding Test Data to Databases During Flyway Migrations

How to add test data to a SQL Server database during Flyway development

DBAs at work #2: The airline DBA

How different is it working as a DBA at an airline? Find out how your peers work in this series: DBAs at work. This episode features Deborah Thompson, Database Administrator at WestJet, Canada’s second largest airline.

AI/Machine Learning/Cognitive Services

Using data to tell a story might be the most important skill

From AllAnalytics

As artificial intelligence (AI) becomes more ubiqu...

A Beginner’s Guide to AI and Machine Learning in Web Scraping

From Dataversity

With uses spanning personalized medicine to the cr...

Administration of SQL Server

Dynamic Data Mask is now useful and no one noticed it

From Simple Talk

Dynamic data mask is a very interesting security f...

My book “Learn T-SQL from Scratch” is launched

From SQLServerCentral Blogs

A lot of my colleagues and people in my network re...

How to INSERT INTO EXEC with extra column

From SQLServer-DBA.Com

The truth about INSERT INTO EXEC and adding extra...

Logging Database Scoped Configuration Changes

From Jonathan Kehayias

The introduction of DATABASE SCOPED CONFIGURATIONS...

3-2-1 Backup Rule for Data Protection in SQL – What Is It & Is It Relevant?

From SQLServerCentral Blogs

In the event of a disaster leading to database una...

Azure SQL Database

Managing Retention period of Azure SQL Database Backup

From SQLShack

Azure SQL Database is a fully managed SQL Server d...

Top 3 Reasons to consider Azure Database for MySQL – Flexible Server | Data Exposed

From Azure SQL

Azure Database for MySQL - Flexible Server is a ne...

Using tables as templates in Azure Database for PostgreSQL

From SQLShack

In this article, we will learn how to create a new...

Community Interests

Unexpected Speaker Gifts

From SQLServerCentral Blogs

I got two packages this week, both unexpected. The...

Computing in the Cloud (Azure, Google, AWS)

New – AWS Proton Supports Terraform and Git Repositories to Manage Templates

From AWS News Blog

Today we are announcing the launch of two features...

Conferences, Classes, Events, and Webinars

Monitoring Your Hybrid Environment with Redgate

Join this Microsoft hosted webinar to hear from Microsoft MVP and Redgate Advocate, Grant Fritchey to learn more about monitoring hybrid database environments, as part of their Azure Series.

DMO/SMO/Powershell

Reading Data from the Command Line in PowerShell–#SQLNewBlogger

From SQLServerCentral Blogs

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

Working with PowerShell strings

From Simple Talk

Knowing how to manipulate strings is critical in a...

How to get last logon of user on Domain Controllers using Powershell

From SQLServer-DBA.Com

How to get use last logon on Active Directory Dom...

Data Mining / Data Analysis

A Slice of Time: Statistical Functions

From 36 Chambers – The Legendary Journeys

This is part five in a series on window functions ...

DevOps and Continuous Delivery (CI/CD)

Getting Started with Cloud-hosted Databases using Spawn

From Product learning – Redgate Software

This article will get you started with Spawn, a ho...

ETL/SSIS/Azure Data Factory/Biml

Azure Data Factory for Web Scraping

From MSSQL Tips

In this article we look at how to build a web scra...

SSIS term extraction vs. term lookup

From SQLShack

This article explains both the SSIS term extractio...

Notebooks

Introducing JupICL: Fast Image Labelling Entirely Within a Jupyter Notebook

From AllAnalytics

SAS' Hamza Ghadyali introduces you to JupICL, a SA...

PowerPivot/PowerQuery/PowerBI

How did I keep my Power BI dataset measures documented and up to date?

From FourMoo

One thing that often happens is when users are usi...

Data Engineer Diary: Wrongly displayed cities in Power BI map visuals

From Joyful Craftsmen – The Business Intelligence Agency

a.k.a. when you find out that your company expande...

Professional Development

13 Ideas for Driving Employee Volunteerism

From MSSQL Tips

This article covers many ways an individual or man...

Security News and Issues

Using Community-Driven Threat Intelligence to Improve Your Security

From IT Pro - Microsoft Windows Information, Solutions, Tools

Date: Thursday, December 16th, 2021 Time: 11:00 A...

CISA Urges Critical Infrastructure to Be Alert for Holiday Threats

From Dark Reading: Dark Reading News Analysis

CISA and the FBI share steps organizations should ...

GoDaddy Breach Exposes SSL Keys of Managed WordPress Hosting Customers

From Dark Reading: Dark Reading News Analysis

The incident, which affected 1.2 million users, ra...

T-SQL

BETWEEN the two of us

BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.

Tech News

What Is Edge Computing? Why It’s Important and How It Works

From Past News - RSS Feeds

In a nutshell, edge computing is any computing tha...

American Connection Project Aims To Fill The Gaps In Rural Broadband

From Past News - RSS Feeds

In the cloud era, digital connectivity is clearly ...

NASA wants to use the sun to power future deep space missions

From Technology Review Feed - Tech Review Top Stories

In August 2022, a NASA probe called Psyche will set out to explore a giant metallic asteroid called Psyche 16, to help scientists learn more about how planets form. The way Psyche reaches its target, though, will...

 
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

 

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