Backup strategy, Azure SQL Edge, and more in Database Weekly (2022-02-05)

Database Weekly for February 5, 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  Please include your DDL I haven’t done it much the past few years, but I would answer some programming questions posted in forums back in the day. In the late 90s, I answered Visual Basic questions and eventually switched to SQL Server questions here on SQL Server Central as my career progressed. Answering questions not only assisted someone else, but it also helped me learn as well. Now, because I’m learning more about MySQL, I’m trying to answer a MySQL question every day on [Stack Overflow](. Like many tech professionals, I frequently find answers to my own questions on the site, but this is the first time I’ve tried answering any. In my case, I’m seeing syntax in the MySQL code that looks unfamiliar to my brain that's so used to T-SQL. For example, I would write and call a proc selecting the rows from a table called Airplanes like this: CREATE PROC usp_getPlanes AS SELECT ID, Name, Description FROM airplanes; GO EXEC dbo.usp_getPlanes; The same procedure in MySQL looks like this: DELIMITER // CREATE PROCEDURE getPlanes() BEGIN SELECT ID, Name, Description FROM airplanes; END// DELIMITER ; CALL getPlanes(); As I run across these differences, I can learn more about MySQL syntax and possibly answer the questions. I might also get some ideas for [Simple Talk]( or SQL Server Central articles. Spending some time looking at MySQL questions on Stack Overflow seems useful but has been somewhat frustrating. The questions are grabbed up quickly, probably due to the vast audience on the site, but I wonder if some folks watch for new questions several hours each day to gain reputation points. It’s very competitive. Many rude comments are not helpful at all. Instead, they are “this question was answered by another post” or “read the manual.” I like to give the poster the benefit of the doubt and assume that they did try searching for their answer and couldn’t find it. Sometimes the linked post that is supposed to have the solution doesn't. The biggest problem with answering query questions is that it is rare to see the DDL and DML statements given, but I don't think that's limited to Stack Overflow. Some questions will show some sample data and maybe what the data returned is supposed to look like and a query they’ve already tried but didn’t work. That means spending several minutes writing out CREATE TABLE and INSERT statements while, in the meantime, someone else will probably post the answer. If you are posting questions like this, please provide some DDL and DML code!!! I realize that I don’t understand Stack Overflow’s nuances at this point, but I’ve seen some strange behavior. After posting the correct query to a question, I’ve noticed that the question often gets deleted within a few seconds. Are the posters too embarrassed to leave the question alone once it’s answered? I enjoy solving SQL puzzles, but please, post your DDL and DML code and leave your question up so I can get those reputation points!  Kathi Kellenberger [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 [Frustrated with your database monitoring challenges?]( Find out how 2500+ of your database professional peers are meeting current and upcoming challenges in our free reports. We cover the Cloud, Security, Growing Environments and the value of monitoring for the entire organization. [Moving from ‘Chaotic’ to ‘Managed’ Database Development using Flyway]( This article describes a route to adopting Flyway in order to bring management and control to a chaotic database development process. It is based on use of Flyway migrations to update a database from version to version, while maintaining object-level source scripts for tracking changes between versions. AI/Machine Learning/Cognitive Services [Detect the Language with Azure AI Language Service]( From MSSQL Tips In this article we take a look at the Azure AI Lan... Administration of SQL Server [Index Column Order]( From SQL Seeker In this post I'm going to demonstrate one of the i... [Things you shouldn't really do in SQL Server: Disabling Join Types Globally]( From SQL Seeker A while ago I presented a session which covered tr... [Space used by Individual tables in SQL Server]( From SQLServerCentral Blogs Learn how to manage SQL Server space used by individual tables with this tutorial. Read more here. The post Space used by Individual tables in SQL Server appeared first on... [SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests]( From SQLServerCentral Blogs Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations. The post SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests appeared first on... [SQL Server Diagnostic Information Queries for February 2022]( From Glenn Berry Introduction These are my SQL Server Diagnostic Information Queries for February 2022, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration... [Don’t optimize for ad hoc workloads as a best practice]( From Born SQL (This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held... [Build a backup strategy and restore plan from scratch]( From Steve Stedman If you have a SQL Server you must have a backup and restore plan. If you don’t you’re in for a rude awakening for sure. Backups are absolutely essential... [Safer Upgrades with Query Store]( From Callihan Data  Azure SQL [Azure SQL News Update: February 2022]( From Azure SQL Usually, Data Exposed goes live at 9AM PT on Learn... [General availability: Enhanced storage configuration with tempdb]( From Azure Updates Manage your SQL Server on Azure Virtual Machine st... [Performance Testing Azure SQL Edge on Intel and M1 MacBooks]( From MSSQL Tips In this article we do performance comparisons of running Azure SQL Edge using Intel Mac versus M1 Mac to see what kinds of differences there are in performance. [Scalar UDF Inlining for Azure SQL Database]( From SQLShack This article explores the scalar UDF performance issues and improvements in Azure SQL Database using UDF Inlining. Introduction SQL Server 2017 and 2019 include intelligent query processing (IQP) features... Azure SQL Managed Instance [Improving data loading performance On SQL Managed Instance with Business Critical service tier]( From Azure SQL In this blog post we shall consider some of the st... Big Data [Saving and Sharing Log Analytics Query]( From Simple Talk Log Analytics uses KQL – Kusto Query Language ... Computing in the Cloud (Azure, Google, AWS) [Azure Files–Standard and Premium]( From SQLServerCentral Blogs This is part of a series on my preparation for the... Conferences, Classes, Events, and Webinars [Ready for SQLBits 2022?]( From Azure SQL SQLBits, the largest Microsoft Data Platform confe... [DevOps 101: What, who, why and how?]( More and more organizations are turning to DevOps as a way of working together to improve the efficiency and quality of software delivery, and increase value to the business. But what exactly is DevOps and what does it mean for you and your organization? DMO/SMO/Powershell [Friday Fun: Redacting with PowerShell]( From The lonely Administrator It has been a while since my last Friday Fun post.... [Fun With PowerShell Objects – Modifying Existing Objects]( From Arcane Code So far we’ve covered a lot in this ... Data Mining / Data Analysis [How to Use Data Analytics to Gain Valuable Insights with Limited Data]( From Dataversity Every modern business professional understands the... Data Privacy, Compliance, and Governance [Stop Using Production Data For Development]( From Thomas LaRock A common software development practice is to take data from a production system and restore it to a different environment, often called “test”, “development”, “staging”, or even “QA”. This... Data Science [11 Intriguing Roles for Data Scientists in 2022]( From Dataversity Data Science is a diverse field with an array of c... Database Design, Theory and Development [When to use CHAR, VARCHAR, or VARCHAR(MAX)]( It’s important to choose the right datatypes whe... [Comparison of the VARCHAR(max) and VARCHAR(n) SQL Server Data Types]( From MSSQL Tips You are developing a SQL Server application and at... [Varchar Data Types in SQL Server, Oracle and PostgreSQL]( From MSSQL Tips Learn about the differences in SQL Server, Oracle ... [Surrogate Key vs Natural Key Differences and When to Use in SQL Server]( From MSSQL Tips In this tip we cover the pros and cons to using a ... ETL/SSIS/Azure Data Factory/Biml [Video-Updates to SSIS Framework Manager and Reports]( From AndyLeonard.blog() Kent Bradshaw and I have been working together on ... MDX/DAX [DAX table functions for paginated reports: Part 1]( Several DAX table functions can be used for pagina... [ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT – DAX Guide]( From SQLBI ISLOGICAL: Checks whether a value is a logical val... Machine Learning [Beyond the Basics with Azure ML: Working with Notebooks]( From 36 Chambers – The Legendary Journeys This is part one in a series on getting beyond the basics with Azure ML. In the prior series, Low-Code Machine Learning with Azure ML, we saw how to... Oracle/PostgreSQL/MySQL/other RDBMS [Creating Azure DB for MySQL – Single Server]( From SQLServerCentral Blogs Enough of the theory and text lets use the Azure P... [Generally available: Azure PostgreSQL backup with long term retention]( From Azure Updates Azure Backup and Azure Database Services bring to ... Performance Tuning SQL Server [SQL Server Trivial Execution Plans]( From SQLShack In this article, we will go through the details of... PowerPivot/PowerQuery/PowerBI [Power BI vs. Tableau: 2022 Software Comparison]( From Past News - RSS Feeds Microsoft Power BI and Tableau are two of the top ... [Performance of sparklines in Power BI – Unplugged #41]( From Sqlbi The new sparklines feature in Power BI retrieves m... [Power BI instead of slides again for Data Toboggan]( From Kevin Chant Reading Time: 3 minutes Last week I presented usi... Professional Development [SQL Homework – February 2022 – “Soft” skills.]( From SQLStudies Well, it’s a new year and a new start, even if I am a bit behind the start of the ... Continue reading Python [Learn Python Complex Built-in Data Types including List, Tuple, Range, Dictionary and Set]( From MSSQL Tips In this article we present complex built-in data t... R Language [Little useless-useful R functions – Making boxplot from a picture]( From TomazTsql Generating violin boxplots from image. Yes, why not. We create a raster image from a picture and calculating the ratio of the pixels on the scale of grayscale.... SQL Server News [Cumulative Update #15 for SQL Server 2019 Big Data Clusters]( From MS SQL Server Blog Today, we announce the release of the latest cumul... SQL Server Security and Auditing [Detect Weak Passwords in SQL Server]( From Eitan Blumin This is a T-SQL script that I’m cross-publishing with the official Madeira Data Solutions blog. This script generates various permutations and variations of common and weak passwords and uses... T-SQL [sp_GetRowcount: How to count the number of rows in any SQL Server table fast]( From SQLServerCentral Blogs Have you ever had to find the number of rows in a ... [Behind the scenes of the SQL Delete Statement]( From SQLShack In this article, we will explore the details of wh... [Software Vendor Mistakes With SQL Server: Using Date Functions On Columns Or Local Variables]( From Erik Darling Data Reusable Logic In most programming languages, it’s quite sensible to create a variable or parameter, use some predefined logic to assign it a value, and then keep reusing it to... [Checking Against Multiple Fields The Easy Way]( From Sherpa of Data A lot of times, you’re asked to find where two different tables have the same data. Thankfully, this is a fairly normal ask. Sometimes, though, you’re asked to see... [Assessing Time Series Model Performance with T-SQL]( From MSSQL Tips This article describes the use of T-SQL code for artificial intelligence models that recommend when to buy and sell financial securities.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -