Learning New Tech and Lots of AI

Database Weekly for October 8, 2022 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 Feed]([Twitter]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -