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
 

Learning Leads To Learning

I am an amateur radio operator. In the US this is commonly referred to as a ham, or a ham radio operator. My call sign is KC1KCE, as issued by the US government through the FCC. And yeah, I can hear you now, a ham is the geek equivalent of a cross-fitter. How do you know someone is a cross-fitter. 'Cause they already told you about it. Hams are kind of the same.

This week I really drilled down on a bunch of stuff with my radios. I have a Raspberry Pi with a transceiver hat (an attachment that goes on top of the Pi, like a hat) that I use as a hotspot for DMR (Digital Mobile Radio). I added functionality for System Fusion, a second digital radio mode to my Pi. I also set up my HF (high frequency) radio to work with a local repeater on 6 Meters (what's known as a band, in this case frequencies between 50 and 54 MHZ). I took part in several nets (on air meetings) using several different radio modes.

Yes, I hear that too. What's all this have to do with databases?

While the time I spend figuring out and implementing these technologies doesn't immediately help me deploy better with Azure DevOps or understand how to capture query metrics in PostgreSQL, it does help me practice good troubleshooting skills. I make backups of my radio's programming (yeah, you can do that, and yeah, you REALLY need to run backups on your radios, just like your databases). I manage code the same way I would if it were database structures. Further, figuring out how to work the OS on the Pi translates back into work I do in containers, working with SQL Server on Linux and other stuff like that.

In short, learning about my radios helps me learn about databases. Learning about databases helps me learn about my radios. Learning helps you to learn better. Learning better helps you learn more. To a large degree, your brain is a muscle. Use it or lose 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.
Vendors/3rd Party Products

Testing Databases: What’s Required?

An overview of the challenges of database testing and test data management, reviewing the different types of database test that need to run during development work, what sort of test data they require, and how to manage all the required data sets, during development, in a way that allows rapid cycles of parallel testing.

The Basics of Updating Data in a SQL Server Table

Once data is inserted into a table, data typically needs to be maintained as time goes on. To make changes to an existing row or a number of rows, in a table, the UPDATE statement is used. This article shows how to use the UPDATE statement to modify data within a SQL Server table.

Index Types in PostgreSQL: Learning PostgreSQL with Grant

In this article I’m going to go over the different types of indexes and some index behaviors. We’ll get into what the indexes are, how they work, and how best you can apply them within your databases.

Administration of SQL Server

Creating database aliases on SQL Server 2022

From Sqlbi

If you create server aliases for SQL Server connec...

SQL Create Schema to Organize Database Objects, Assign Permissions and Easier Management

From MSSQL Tips

Learn about SQL Server schemas and how to use them...

SQL Server and Clustered vs. NonClustered Indexes

From Steve Stedman

In SQL Server, an index is a data structure that a...

T-SQL Tuesday #158 – When Worst Practices are the Best

From Eitan Blumin

This month's #tsqltuesday is an especially interes...

What is the difference between Always On Clustered and Always On Clusterless

From SQLServer-DBA.Com

What is the difference between Always On Clustered...

T-SQL Tuesday #158 – Stop Taking Transaction Log Backups

From Callihan Data

This week’s T-SQL Tuesday comes from Raul Gonzal...

SQL Server 2019 Express Step by Step Download, Install and Configure

From MSSQL Tips

Learn how to download, install and configure SQL S...

Understanding SQL Server Hardware: What Uses Memory, and How Much Do I Need?

From Erik Darling Data

+OK

Logs Do Not Care About Your Feelings or Emotions

From SQLHA -- Allan Hirt

Your log is not a jerk The post Logs Do Not Care About Your Feelings or Emotions appeared first on SQLHA.

How To Fix SQL Server Always On Availability Group Database Not Synchronized

From MSSQL Tips

In this article, we look at how to resolve the issue of an Always On Availability Group database not synchronizing and how to fix this issue.

Analysis Services / BI on the MS Stack

Using PROC DEEPPRICE to personalize prices and optimize revenue

From AllAnalytics

SAS' Sylvia Kabisa shows you how an online media c...

Azure Databricks, Spark and Snowflake

Insert differently with Snowflake and SQL Server

From Sherpa of Data

One of the things that I’ve gotten used to with ...

Azure SQL

At-scale monitoring for Azure Site Recovery with Backup center

From Azure Updates

The new enhancements released in Backup center ena...

Troubleshooting SQL Insights

From Azure Database Support Blog

SQL Insights for Azure SQL Db allow you to have a quick look into the resource usage of your Azure SQL Resource in a graphical way, but when we...

Lesson Learned #279: Slow between calls to Azure SQL Elastic Database Pool

From Azure Database Support Blog

It is not the first time, that we used to have this type of service requests that our customers reported slow connections in an Elastic Database Pool. Following I...

Lesson Learned #281: Export fails due to system out of memory exception

From Azure Database Support Blog

We found today an out of memory exception raised by SQL Server Management Studio exporting a database. This exception may occurs because, for performance improvement the export process, this process...

Azure Synapse (SQL Data Warehouse and Data Lake)

Public preview: Azure Synapse Runtime for Apache Spark 3.3

From Azure Updates

You can now create Azure Synapse Runtime for Apach...

How to easily teach yourself Azure Arc-enabled data services | Data Exposed

From Azure SQL

In the episode of Data Exposed with Anna Hoffman and Lior Kamrat, we will be talking about how to get started with Azure Arc-enabled data services, the newly announced...

Career, Employment, and Certifications

Amazon Cuts 18,000 Jobs From its Global Workforce

From Petri IT Knowledgebase

Further fueling fears of a coming recession, Amazo...

Recommended SQL Server certifications and badges

From Kevin Chant

Reading Time: 4 minutes I want to cover recommend...

Community Interests

Data Céilí Dublin 2023

From DBA From The Cold

Today we have launched Data Céilí (pronounced ka...

Computing in the Cloud (Azure, Google, AWS)

Happy New Year! AWS Week in Review – January 9, 2023

From AWS News Blog

Happy New Year! As we kick off 2023, I wanted to t...

Beyond Rightsizing: When It Comes to Cloud Cost Optimization, Think Big

From IT Pro - Microsoft Windows Information, Solutions, Tools

Sure, rightsizing VM instances will save money, but there are other cloud cost optimization strategies that can bring you greater cloud savings and even save you time and technical...

AWS, Azure, and GCP: 4 Major Areas in Which They Differ

From IT Pro - Microsoft Windows Information, Solutions, Tools

Consider these four differences between AWS, Azure, and GCP before choosing one of the "Big Three" public clouds.

DMO/SMO/Powershell

How to create a PowerShell Module with multiple Functions

From Sid 500 PoSh

In this blog post, I will show you how to create a...

Microsoft Releases Exchange Server Updates to Improve Security of PowerShell Payloads

From Petri IT Knowledgebase

Microsoft has released yesterday the January 2023 ...

Data Mining / Data Analysis

How organizations can maximize productivity to maintain their competitive edge

From AllAnalytics

Data science teams are no longer comprised of tiny...

Identifying People Using Cell Phone Location Data

From Schneier on Security

The two people who shut down four Washington power...

redefining the analytical process

From Storytelling with Data

"I want to kick things off with a super important ...

Anxiety in Children, Anxiety in Parents

From AllAnalytics

I have an anxiety disorder and 24 years ago when I...

Database Design, Theory and Development

4 High-Impact Data Quality Issues That Are Easily Avoidable

From Dataversity

When we talk to prospective customers, their first questions are usually around the fundamentals of data quality, including what it is, how we measure it, what happens when it...

DevOps and Continuous Delivery (CI/CD)

Public Preview: Azure Automation Visual Studio Code Extension

From Azure Updates

Use the Azure Automation extension to perform local authoring and management of automation runbooks using VS Code

ETL/SSIS/Azure Data Factory/Biml

Interview Questions and Answers for Azure Data Factory and SSIS

From AndyLeonard.blog()

First, I apologize. I apologize because I intentio...

What Is ETL, Extract, Transform, Load?

From Past News - RSS Feeds

Extract, transform, load (ETL) is the process of extracting data from various sources, transforming it through various methods, and loading it into a data warehouse or data lake. Some...

General

Thoughts on Software Development and Postgres

From Curated SQL

Ryan Lambert thinks about software development: Qu...

Hardware

Raspberry Pi Camera Module v3 Review: A New Angle on Photography

From Tom's Hardware US

The latest camera from Raspberry Pi brings autofoc...

Understanding SQL Server Hardware: Parallel vs Serial Query CPU Usage

From Erik Darling Data

+OK

G-Code 101: Modify Your 3D Printing Files

From Tom's Hardware US

Learn about G-Code and how we can write our own cu...

Roomba testers feel misled after intimate images ended up on Facebook

From Technology Review Feed - Tech Review Top Stories

When Greg unboxed a new Roomba robot vacuum cleane...

Neon Raspberry Pi Picade: A Time Machine to the 1990s

From Tom's Hardware US

Gavin Strange's neon infused Raspberry Pi powered ...

The Most Anticipated Portable Monitors of 2023

From Tom's Hardware US

Exciting portable monitors from Asus, and ViewSoni...

Raspberry Pi Produced 10 Million RP2040s in 2021, More Pi Stores Likely

From Tom's Hardware US

In a recent episode of Tom's Hardware: The Pi Cast...

What to Expect from Open-Source Data Infrastructure in 2023

From Dataversity

Open-source technologies will become even more pro...

Oracle/PostgreSQL/MySQL/other RDBMS

CI/CD and Postgres

From Curated SQL

Ryan Booz thinks about Database DevOps: At the cor...

Creating a PostgreSQL Docker Container with a Volume on Windows

From SQLServerCentral Blogs

This post looks at how to set up a PostgreSQL cont...

Microsoft: Kinsing Targets Kubernetes via Containers, PostgreSQL

From Dark Reading: Dark Reading News Analysis

The cryptomining malware, which typically targets ...

Indexing in Postgres

From Curated SQL

Grant Fritchey provides an overview: In this artic...

Performance Tuning SQL Server

Against the Grain: Heaps, Clustered Indexes, and Fragmentation

From Curated SQL

Rob Farley cautions against rash decisions on thre...

SQL Server Indexes with Key and Non-Key Columns as Covering Indexes to improve Performance

From MSSQL Tips

Learn how to build SQL Server indexes using key an...

PowerPivot/PowerQuery/PowerBI

How to make your Power BI solution support multiple languages

From Data – Marc

In case you’re working in an international compa...

(Livestream Replay) ChatGPT...Fad or Future? - Practical use-cases for Power BI - with Mathias Halkjær

From Havens Consulting

ABSTRACT As chatbots become more prevalent in ...

How to create Power BI reports

From SQLShack

In this article, we will learn how to create Power...

Updating your Query syntax in Power Query to show the entire query in M

From FourMoo

Welcome to 2023, I am looking forward to an amazin...

Press Releases

Devart's dbForge Tools for SQL Server Get Even More Powerful

The entire dbForge for SQL Server product line from Devart was updated. Now all the dbForge add-ins support SSMS 19 Preview 4, and the dbForge Studio can also be run on Linux and macOS.

Product Upgrades and Releases

Released: SCOM Management Packs for Azure SQL Database, SQL Server, RS, AS (7.0.42.0)

From MS SQL Server Blog

Updates to Azure SQL Database, SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.42.0). You can download the MPs from the links below. Majority of the...

Professional Development

Creating an Annual Organizational IT Roadmap

From MSSQL Tips

This article intends to cover a few tips for creat...

The constant is change

From Technology Review Feed - Tech Review Top Stories

For the past 22 years, we’ve been publishing an ...

The Importance of In-Person User Group Meetings

From The SQL Herald (Joey D'Antoni)

I really, really miss speaking at in-person user g...

SQL Server Mentoring – Do you need some occasional help?

From Steve Stedman

Sometimes we all need a little help without a long...

Habit building hacks

From AllAnalytics

If you’ve decided to make some changes this year...

Why Analyzing Past Incidents Helps Teams More Than Usual Security Metrics

From Dark Reading: Dark Reading News Analysis

Traditional metrics don't reflect real-world sever...

Security News and Issues

Serbia Slammed With DDoS Attacks

From Dark Reading: Dark Reading News Analysis

The Serbian government reports that it staved off ...

Cyberattack Cancels Classes for Des Moines Public Schools

From Dark Reading: Dark Reading News Analysis

School to resume Thursday, Jan. 12, after Iowa sch...

How To Fight Security Tool Sprawl

From IT Pro - Microsoft Windows Information, Solutions, Tools

Security tool sprawl is a challenge that organizations of all sizes contend with today. Explore the factors that contribute to tool sprawl and how to get your house in...

Notorious Ransomware Gang Accused of Attack on UK’s Royal Mail

From IT Pro - Microsoft Windows Information, Solutions, Tools

The LockBit allegedly targeted the Royal Mail and used encryption to lock some of its computers.

Researchers Find 'Digital Crime Haven' While Investigating Magecart Activity

From Dark Reading: Dark Reading News Analysis

A security vendor's investigation of infrastructur...

New Survey Sheds Light on Why Enterprises Struggle to Thwart API Attacks

From Dark Reading: Dark Reading News Analysis

Corsha’s Annual State of API Secrets Management ...

Threats of Machine-Generated Text

From Schneier on Security

With the release of ChatGPT, I’ve read many random articles about this or that threat from the technology. This paper is a good survey of the field: what...

Software Development

SQL Server vs Oracle: Connect from Visual Studio 2019 ASP.NET Core Web Application

From MSSQL Tips

Learn how to use SQL Server or Oracle as the backend database for a simple .Net Core Web Application.

T-SQL and Query Languages

3 Ways to Debug T-SQL Code

From Brent Ozar Unlimited

Writing new code = bugging. That part’s easy. Ta...

T-SQL Tuesday #158–Implementing Worst Practices

From SQLServerCentral Blogs

Not that I’m looking to do this, but that’s th...

T-SQL Tuesday #158 – Using the Worse Practices

From Deb the DBA

Happy T-SQL Tuesday! It’s the first one of 2023 ...

T-SQL Tuesday #158 : Worst Practices

From SQLBlog.org

For T-SQL Tuesday #158, I talk about a couple of j...

Inner Join vs. Outer Join

From Steve Stedman

A SQL Server inner join is a type of join that com...

SQL Server Function Examples with JSON Files

From MSSQL Tips

This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.

Common Table Expressions

From Steve Stedman

A common table expression, also known as a CTE, is a temporary named result set in SQL that can be used within a SELECT, INSERT, UPDATE, or DELETE statement....

Working with time series data in SQL Server 2022 and Azure SQL

From Microsoft SQL Server Blog

Time series capabilities in SQL Server were introduced in Azure SQL Edge, Microsoft's version of SQL Server for the Internet of Things. The post Working with time series data...

Getting started with SQL LIMIT clause

From SQLShack

Today, I am going to explain how to use the SQL LIMIT clause to limit output values. We all know RDBMS systems are one of the popular ways to...

Tech News

Microsoft is Reportedly Bringing ChatGPT Features to Outlook, Word, and PowerPoint

From Petri IT Knowledgebase

Microsoft is reportedly planning to integrate Open...

Windows Subsystem for Android Gets Update to Android 13

From Tom's Hardware US

Microsoft's latest update to the Windows Subsystem...

The state of responsible technology

From Technology Review Feed - Tech Review Top Stories

Consideration of how to deploy technology responsi...

Cyber Jobs of the Future: Sleuth, Bodyguard, 'Immunity' Developer

From Dark Reading: Dark Reading News Analysis

With artificial intelligence poised to displace ma...

We can use sewage to track the rise of antibiotic-resistant bacteria

From Technology Review Feed - Tech Review Top Stories

This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. This week, a sore throat and...

The Lighter Side

Meet the designers printing houses out of salt and clay

From Technology Review Feed - Tech Review Top Stories

Ronald Rael and Virginia San Fratello may have met...

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

Microsoft SQL Server Management Studio Error

From SQLServerCentral Blogs

I came across an issue with SSMS not loading prope...

Virtualization and Containers/Kubernetes

You can run a SQL Server Docker container on Apple M1 and M2 Silicon

From Born SQL

Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta support today for Apple’s...

Kubernetes-Related Security Projects to Watch in 2023

From Dark Reading: Dark Reading News Analysis

Organizations must be vigilant about balancing per...

flyway

Getting Started with Flyway Migrations on Oracle

From Product learning – Redgate Software

A quick demonstration of using Flyway with Oracle, for those of a nervous disposition. We'll use Flyway to run some migrations on an Oracle Autonomous Database, building the initial...

Getting Started Connecting to a Database with Flyway

From SQLServerCentral Blogs

In a previous post, I got Flyway installed as a CL...

 
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

 

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