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 New Technology Is Challenging

On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit major snags getting these chips to communicate with my computer. I was setting up a old laptop with Linux to see if that works better when I hit a breakthrough. I finally was able to see the controller through software. Now I just have to figure out how to get a bootloader on the darned thing and I think I'll be off and running.

The issue is, the documentation out there on these STM32 chips is... poor (trying to be kind). It's not that things are not well documented, they are. However, they're documented by people with a large amount of existing knowledge of electronics, mostly for people with an equally large amount of knowledge of electronics. Yeah, I've been working with computers for over 30 years, and playing on game systems since the original Pong, but I'm not an electronics expert, at all, in any sense. In fact, I'm still struggling with a lot of the basics.

Something to think about when you're setting your training, whether in-house, inter-team, or external, is who your audience is. If you're teaching something introductory, you may need to assume zero knowledge on the part of the people you're trying to teach. And if they have to have other knowledge first, you're going to need to find that or make it so you can provide it. The last thing you want to do is leave people in a lurch where they want to learn what you are teaching, but just can't. Granted, some topics really do require a ton of prior knowledge and sometimes, people just won't be able to learn without that prior knowledge.

Now, to see if I can get that bootloader on the controller. Fingers crossed!

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

Try Before You Commit in Flyway

Sometimes we want to check whether it is possible to run a Flyway migration without error, but not actually make the changes. We might just need to 'sanity test' the performance of a migration on the Staging server, for example. By using a placeholder 'switch' to trigger a SQL Exception, we can get Flyway to roll-back its transaction, and therefore the migration, on demand.

AI/Machine Learning/Cognitive Services

Get ready for the next generation of AI

From Technology Review Feed - Tech Review Top Stories

To receive The Algorithm in your inbox every Monda...

DeepMind’s game-playing AI has beaten a 50-year-old record in computer science

From Technology Review Feed - Tech Review Top Stories

DeepMind has used its board-game playing AI AlphaZ...

AI and data fuel innovation in clinical trials and beyond

From Technology Review Feed - Tech Review Top Stories

The last five years have seen large innovations th...

AI vs. Deep Learning

From Past News - RSS Feeds

Deep learning has become something of a catchphras...

I Was There When: AI mastered chess

From Technology Review Feed - Tech Review Top Stories

I Was There When is an oral history project that�...

Google’s new AI can hear a snippet of song—and then keep on playing

From Technology Review Feed - Tech Review Top Stories

A new AI system can create natural-sounding speech and music after being prompted with a few seconds of audio. AudioLM, developed by Google researchers, generates audio that fits the...

Administration of SQL Server

Scary Scalar Functions - Part Four: Your Environment

From SQLServerCentral Blogs

Scary Scalar Functions series overview Part One: P...

Restore HEADERONLY and FILELISTONLY

From SQLServerCentral Blogs

Good day reader.  This post is coming to you from...

Recognizing the Resource Database

From Callihan Data

Can you name each of the system databases in SQL S...

How to enable SQL Server trace flags at startup

From SQLServer-DBA.Com

Adding trace flags sql server startup

Load Data Asynchronously to SQL Server via an API and Python

From MSSQL Tips

Learn how to consume multiple API calls to load da...

Visually Tracking Buy-Sell Time Series Models with SQL Server and Excel

From MSSQL Tips

Learn how to build time series data models in SQL ...

SQL Commands to check current Date and Time (Timestamp) in SQL Server

From SQLShack

This article explores different SQL Commands (func...

Analysis Services / BI on the MS Stack

Storage Engine (VertiPaq) – The Whiteboard #07

From Sqlbi

How does the VertiPaq storage engine communicate w...

Azure SQL

Generally available: Query Store hints Azure SQL Database, Azure SQL Managed Instance

From Azure Updates

Shape your query plans without changing the code.

Lesson Learned #239: Attempt was made to access a socket in a way forbidden by its access permission

From Azure Database Support Blog

Our customer, using, for example, SQL SERVER Manag...

Develop Apps with Azure SQL Database for Free | Data Exposed

From Azure SQL

You know Azure SQL Database has the features you n...

Azure Synapse (SQL Data Warehouse and Data Lake)

The Data Lakehouse Explained

From IT Pro - Microsoft Windows Information, Solutions, Tools

This comprehensive five-part explainer introduces ...

Backup and Recovery

Giving Away the Keys to Your Backups? Here’s How to Keep Out Hackers

From Dark Reading: Dark Reading News Analysis

As threat actors' sophistication has grown dramati...

Community Interests

Registered for the Data Community Summit

From SQLServerCentral Blogs

I was reminded this week that I needed to get regi...

Sharing Knowledge at 44CON

From Dark Reading: Dark Reading News Analysis

The infosec conference named after the UK's callin...

Computing in the Cloud (Azure, Google, AWS)

AWS Week in Review – October 3, 2022

From AWS News Blog

This post is part of our Week in Review series. Ch...

Public preview: Azure Firewall Basic

From Azure Updates

Azure Firewall Basic provides cost-effective, ente...

How To Choose a Cloud-based Disaster Recovery Service

From IT Pro - Microsoft Windows Information, Solutions, Tools

Should your organization deploy a cloud-based disa...

Cloud Computing vs. Edge Computing: What’s the Difference?

From Dataversity

Much has been said about the mass migration toward...

How to Install And Get Started With the Azure CLI

From Petri IT Knowledgebase

The Azure Command-Line Interface (CLI) is a cross-...

Recently Released: Updates to SqlPackage, DacFx, and GitHub sql-action

From Azure SQL

We recently released v19.2 of SqlPackage, a v161-p...

Conferences, Classes, Events, and Webinars

Join a community like no other at Summit

PASS Data Community Summit 2022 takes place from 15-18 November online and in-person in Seattle. Register today to unlock access to over 300 world-class sessions and speakers. Join thousands of liked-minded data professionals at the year's largest hybrid data platform conference and get inspired by other experts facing the same challenges you are.

PASS Data Community Summit Pre-cons

Don't miss the fantastic all-day sessions happening at PASS Data Community Summit...

PASS Data Community Summit: Community Keynote on Friday

It has been announced that Kimberly Tripp will deliver...

DMO/SMO/Powershell

Community Tools Month 2022 - dbatools

From SQLServerCentral Blogs

The Prompt In July, Brent Ozar (blog | twitter) as...

6 Reasons to Learn PowerShell

From Lee Markum

  SQL Server professionals may be reluctant to st...

How To Check Your PowerShell Version

From IT Pro - Microsoft Windows Information, Solutions, Tools

Are you running the latest version of PowerShell? ...

Publishing PSTimeSheets To The PSGallery

From No Column Name

Words: 567 Time to read: ~ 3 minutes Skip This for...

Data Mining / Data Analysis

Checksums and data integrity in SAS programs

From AllAnalytics

Have you ever typed your credit card into an onlin...

Data Privacy, Compliance, and Governance

Scaling Data Access Governance

From Dataversity

The rise of data lakes and adjacent patterns such ...

UK to Replace GDPR with 'Consumer-Friendly' Privacy Regime

From IT Pro - Microsoft Windows Information, Solutions, Tools

The UK's new culture secretary decries "red tape,"...

Database Design, Theory and Development

Server Management Best Practices in Today’s Data-Driven Organizations

From Dataversity

Servers constitute the pillar of companies, especi...

DevOps and Continuous Delivery (CI/CD)

GitHub Actions information using the GitHub connector in Power BI

From Kevin Chant

Reading Time: 4 minutes In this post I want to co...

DevOps From Redgate

From Scary DBA (Grant Fritchey)

In a few weeks at the PASS Data Community Summit, ...

Applying the Benefits of DevOps for Cloud Transformation and Innovation

From MSSQL Tips

This article covers the essential roles DevOps pla...

A Real-world Implementation of Database DevOps: People, Processes, Tools

From Product learning – Redgate Software

This series of articles describes a path you can t...

5 Ways ITOps Teams Can Support Sustainability

From IT Pro - Microsoft Windows Information, Solutions, Tools

IT operations teams play a leading role in helping...

Machine Learning

Azure Machine Learning—General availability updates for September 2022

From Azure Updates

New features include the ability to establish even...

Oracle/PostgreSQL/MySQL/other RDBMS

Querying data from Azure Database for PostgreSQL using psql

From SQLShack

In this article, we will learn how to query the da...

Introducing the MySQL INSERT statement

From Simple Talk

In the previous article in this series, I introduc...

PGSQL Phriday #001: Two Truths and a Lie

From Scary DBA (Grant Fritchey)

As a part of my own journey of learning within Pos...

Performance Tuning SQL Server

Deciding between COALESCE and ISNULL in SQL Server

From MSSQL Tips

When writing T-SQL, a lot of developers use either...

Function Vs. Performance

From Scary DBA (Grant Fritchey)

Recently I was looking through DBA.StackExchange w...

HADR_SYNC_COMMIT Wait Updates (In Progress)

From MS SQL Server Blog

A HADR_SYNC_COMMIT wait occurs when the session is...

What To Do When Your Query Runs For Too Long To Get An Actual Execution Plan

From Erik Darling Data

Willfully While I do enjoy answering questions ab...

PowerPivot/PowerQuery/PowerBI

Power BI Fast and Furious with Aggregations

From RADACAD

Power BI is not only a solution for small datasets...

Measure Killer for Power BI

From Excelerator BI

 

A Power Query feature you may not know about!

From Guy in a Cube

We thought everyone knew about this Power Query ca...

Power BI using Synapse Serverless Pool with Delta Lake format

From Dan English's BI Blog

In this post I just wanted to show the ability to ...

Professional Development

Organizations Must Formulate Long-Term Remote Work Strategy

From IT Pro - Microsoft Windows Information, Solutions, Tools

Workplace norms have gone through a revolution, an...

Who’s Hiring in the Microsoft Data Platform Community? October 2022 Edition

From Brent Ozar Unlimited

Is your company hiring for a database position as ...

SQL

The Basics of Inserting Data into a SQL Server Table

Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with a single execution of an INSERT statement. You can even use the output of a stored procedure to insert rows. In this article, I will explore the basics of inserting data into a SQL Server table using the INSERT statement.

SQL Server Security and Auditing

SQL Server user roles and permissions query

From SQLServer-DBA.Com

Using the SQL Server user roles and permissions qu...

What you can do is based on more than your direct permissions.

From SQLStudies

What you have access to is not just what you have ...

Security News and Issues

Relentless Russian Cyberattacks on Ukraine Raise Important Policy Questions

From Dark Reading: Dark Reading News Analysis

Microsoft cybersecurity executive John Hewie expla...

Russia-Linked Cybercrime Group Hawks Combo of Malicious Services With LilithBot

From Dark Reading: Dark Reading News Analysis

The malware-as-a-service group Eternity is selling...

Data Masking in Principle

From Product learning – Redgate Software

This is the first of two articles to describe the ...

US Consumers Are Finally Becoming More Security & Privacy Conscious

From Dark Reading: Dark Reading News Analysis

The trend, spotted by Consumer Reports, could mean...

We Can Save Security Teams From Crushing Workloads. Will We?

From Dark Reading: Dark Reading News Analysis

Today, the processing of mountain-high stacks of alarms is considered "security." That system is failing customers and the cybersecurity workforce.

T-SQL and Query Languages

How to calculate the Range of a Data Set using the GREATEST and LEAST SQL Server 2022 Functions

From MSSQL Tips

In this article, we look at how to calculate the r...

SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more

From MSSQL Tips

In this article, we look at various aspects of cre...

The Basics of Inserting Data into a SQL Server Table

From Simple Talk

Before data can be read from of a SQL Server datab...

What’s New in SQL Server 2022: GENERATE_SERIES()

From Jonathan Kehayias

I’ve been doing a lot of work with SQL Server 20...

T-SQL Tuesday #155 –The Dynamic Code Invitation

From SQLServerCentral Blogs

Apologies for the late invitation. A minor snafu h...

TSQL Output Clause course – just released

From Steve Stedman

I have just completed a course in our SQL Queries ...

Tech News

Raspberry Pi Still Hard to Get as Company Can't Meet Demand

From Tom's Hardware US

Almost six months since an official update from Ra...

How To Install Ubuntu on a Computer or Virtual Machine

From IT Pro - Microsoft Windows Information, Solutions, Tools

As a lightweight operating system, the entire Ubun...

Europe to Force Laptop Makers to Adopt USB-C for Charging

From Tom's Hardware US

All laptops sold in Europe will have to support US...

How the covid pop-up window is wreaking havoc on daily life in China

From Technology Review Feed - Tech Review Top Stories

Welcome back! Hope you are not stuck in highway tr...

Raspberry Pi Pico Adds Ambience to Tabletop Adventures

From Tom's Hardware US

Maker and developer Balthazar Rouberol is using a ...

Power beaming comes of age

From Technology Review Feed - Tech Review Top Stories

Power beaming has long been a dream of engineers a...

AMD Warns of $1.1 Billion Revenue Shortfall, Cites Weak PC Market

From Tom's Hardware US

AMD pre-announced that it would miss its revenue t...

Cognizant CTO Anil Cheriyan on Optimizing Digital Transformation

From Past News - RSS Feeds

I spoke with Anil Cheriyan, CTO, Executive VP, Str...

Adatis runs successful Data event for Higher Education 

From Adatis

Last week, we were thrilled to host Advancing Acad...

Microsoft Provides New Performance Tips for Windows 11 Gamers

From Tom's Hardware US

Microsoft discusses the implications of toggling o...

AirDrop and Apple ‘Continuity’ Style Features Coming to Windows 11 PCs

From Petri IT Knowledgebase

This Week in IT, Intel Unison promises to bring an...

 
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

 

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