Backup history, Managed Instance and more in Database Weekly (2021-10-09)

Database Weekly for October 9, 2021 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  PASS Data Community Summit Pre-cons This year PASS Data Community Summit is a free virtual event, and I encourage you to [register]( even if you are interested in just a handful of sessions. One of the Learning Pathways might be just what you are looking for, from Query Basics to Power BI to DevOps. What I’m most excited about this year are the pre-cons. Because they are virtual, there are no costs for session rooms, lunch, etc. The price for each is a low $200. It’s a ton of work building an all-day class, so I’m thrilled that the speakers will get all the proceeds. Whether you are starting your career, switching to a new one, or building advanced skills that can help you today, there is something for everyone. As a trainer of quite a few new DBAs over the years, I am really excited about Denny Cherry’s [Database Administration for the Non Database Administrator](. So many of us – myself included – started out as “accidental” DBAs. No one knows more about getting the most out of SQL Server than Denny, so this should be a wonderful session for new DBAs or anyone who wants to be a DBA. If you can attend both days, some pre-cons go together nicely. Bob Ward and Ajay Jagannathan from Microsoft are giving [Migrate SQL Server to Azure](. Bob and Ajay have the inside story about what tools to use and the best way to migrate. The next day, Tracy Boggiano is presenting [Azure SQL Fundamentals](. Tracy has real-world experience migrating to Azure. She knows what can go wrong and how to avoid the issues. These sessions complement each other well, and you will gain all the tools you need to migrate to Azure after attending these two days! Suppose you have already migrated but have some issues with deployments. In that case, Rob Sewell has the answers for you in his [Control your Cloud Data Deployments - Deploy your Azure Data Solutions with Bicep and Azure DevOps]( session. Monica Rathbun’s [SQL Server Performance Tuning and Optimization]( pre-con will take you from identifying performance problems to how to solve them. The next day, Erin Stellato’s [Finding Problems and Stabilizing Performance with Query Store]( will take your skills to the next level as you learn how to take advantage of tools and features that are part of SQL Server like Query Store and Intelligent Query Processing. On Monday, Itzik Ben-Gan is presenting [Advanced T-SQL Querying and Query Tuning](. Itzik will cover the many T-SQL features added over the past few versions that have made querying easier and perform better. On Tuesday, Kimberly L. Tripp will give [Solving Query Performance Problems with Statistics](. This is an excellent session for anyone with query performance issues that are difficult to figure out! If you are interested in analytics, there are several pre-cons from which to choose: - Ginger Grant is presenting [Developing Data Solutions with Python and Apache Spark in Azure Synapse Analytics]( - Steph Locke is giving [The Latest Data Science Workflow in Azure]( - Learn Power BI with Angela Henry’s [Zero To Dashboard]( There’s one more that I’d like to mention. Blythe Morrow will give [Master Communication and Influencing Skills](. We can all benefit from this pre-con from better emails, getting your ideas heard in meetings, and negotiating a pay raise. There is something for everyone at PASS Data Community Summit. [Register]( today, and be sure to find the [pre-con]( that is right for you!   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. Administration of SQL Server [Measuring SQL Server File Latency]( From SQLServerCentral Blogs This post is a reference post for retrieving IO st... [How to use Database Compatibility to increase your migration success]( From SQLServer-DBA.Com Understanding SQL Server database compatibility le... [Different Index Build Strategies For SQL Server]( From Erik Darling Data Link Up This post is links to a series of articles that it’s a shame more people haven’t seen, because they describe why some index builds/rebuilds take a lot longer... [How to manage SQL Server logs effectively]( From SQLShack This article covers an overview of SQL Server logs... [Licensing SQL Server and Affinity Masking]( From Callihan Data What happens if you have a SQL Server that was ini... [Deploying a DACPAC]( From Callihan Data In my last post, we created a DACPAC in SSMS. Now,... [SQL Server Diagnostic Information Queries for October 2021]( From Glenn Berry These are my SQL Server Diagnostic Information Queries for October 2021, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a short amount of time. These are my SQL Server Diagnostic Information Queries for October 2021... [How to start SSMS as a different Windows login]( From SQLServer-DBA.Com How to deal with connect to remote SQL Servers wit... [Script to retrieve SQL Server database backup history and no backups]( From MSSQL Tips In this tip we provide queries you can use to get ... [Automating Extended Events data collection]( From Simple Talk It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended... [SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?]( From SQLStudies Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? ... Continue reading [Quickly Find SQL Server Code Errors when using SSMS]( From MSSQL Tips Use SSMS to quickly find errors in your T-SQL code by double clicking on the error message and SSMS will bring you right to that line of code. [Min and Max memory configurations in SQL Server Database instances]( From SQLShack This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances. Introduction The server performance depends on various factors such as CPU,... Azure Databricks, Spark and Snowflake [Integrating Azure Databricks with Azure Data Factory]( From SQLShack In this article, we will learn how to establish su... Azure SQL Database [Azure SQL and Azure Purview work better together]( From Azure SQL Azure Purview lets you govern Azure SQL Databases ... [Azure SQL News Update: October 2021]( From Azure SQL Today and every Wednesday Data Exposed goes live at 9AM PT on LearnTV. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as... Azure SQL Managed Instance [Restore to SQL Managed Instance]( From SQLServerCentral Blogs Now that we have a Managed Instance built, the nex... [Announcing Azure SQL MI Repository on GitHub]( From Azure SQL We are launching an official repository for the Az... Azure Synapse (SQL Data Warehouse and Data Lake) [Building Scalable Lakehouse Solutions using Azure Synapse Analytics]( From MSSQL Tips In this series I will discuss common challenges of... [Monitoring Azure Synapse Analytics with alerts]( From SQLShack This article will drive you through the way to create alerts on an Azure Synapse instance to receive notifications based on various monitoring criteria that are met. Introduction Data... Big Data [4 Risks of Storing Large Amounts of Unstructured Data]( From Dataversity In 2013, the big data headline was the incredible statistic that 90% of all data in the history of the entire human race had been created in the previous two years... Computing in the Cloud (Azure, Google, AWS) [Introduction to Azure Time Series Insights]( From SQLShack In this article, we are going to learn in detail a... Conferences, Classes, Events, and Webinars [PASS Data Community Summit 2021: I’m Excited!]( From Scary DBA (Grant Fritchey) I sincerely hope this isn’t the first time you?... DMO/SMO/Powershell [Fun With PowerShell Write-Debug]( From Arcane Code Introduction In my previous post, Fun With PowerSh... Database Design, Theory and Development [Quick, Easy, and Flexible Data Model Diagrams]( From Dataversity Many of us have a lot to do. And we have short delivery cycles, sprints, and a lot of peers to share data models with. In search of something lightweight, which is quick and easy, and may be produced (or consumed) by other programs? DevOps and Continuous Delivery (CI/CD) [Update a Database Project within the GitHub website]( From Kevin Chant In this post I want to cover a couple of ways you can update a Database Project within the GitHub website. Because both ways can be useful... ETL/SSIS/Azure Data Factory/Biml [Data Access Modes in SSIS OLE DB Destination: SQL Command vs. Table or View]( From SQLShack This article compares the SSIS OLE DB Destination SQL command with the “Table or View” data access mode. In a previously published article, SSIS OLE DB Destination vs SQL... Microsoft News [What to Expect with Windows 11: A Day One Hands-On]( From AnAndTech Tomorrow, Microsoft is officially launching Windows 11, the next installment of their operating system which underpins the majority of PCs in use today. Windows 10 has an install base... Performance Tuning SQL Server [UDF Inlining And String Aggregations]( From Erik Darling Data Quatro Enemigos This post is really four different posts. Maybe five... PowerPivot/PowerQuery/PowerBI [Using PowerShell to run Power BI DAX queries and extract data to CSV]( From FourMoo In this blog post I am going to show you how to us... [Power BI Report Accessibility: Emulate Vision Deficiencies Using Edge DevTools]( From Chris Webb's BI Blog I’m not an expert on Power BI report accessibili... R Language [How to show 5 minute intervals in Power BI?]( From Guy in a Cube Another question from the comments... MrTavelBlog ... [Text processing and word stemming for classification models in master data management (MDM) context in R]( From DataScience+ Under business conditions, narrowly specialized tasks often come across, which require a special approach because they do not fit into the standard data processing flow and constructing models. One of these tasks is the classification of new products in master data management process (MDM). SQL [Dealing with foreign keys when deleting rows.]( From SQLStudies Deleting rows from a table is a pretty simple task... SQL Server News [SQL Server 2019 CU #13 Just Released By Microsoft Today]( From Steve Stedman Today Microsoft release the following SQL Server update. SQL Server 2019 CU 13 (KB 5005679) 10/05/2021 At Stedman Solutions, LLC we do help with SQL maintenance and administration. If... SQL Server Security and Auditing [Ransomware Recovery For Your SQL Server]( From Steve Stedman Will your backup and recovery strategy cover you? So what about ransomware? A lot of people are getting hit with ransomware lately. I’ve seen more people lose their systems... Security News and Issues [Company that routes SMS for all major US carriers was hacked for five years]( From Ars Technica Syniverse hasn't revealed whether text messages were exposed. T-SQL [Create and Compare SQL Time Series Models]( From MSSQL Tips This tip compares four time series models using SQ... [Analytic Function FIRST_VALUE]( From It's All Just Electrons Last week, I found myself with a T-SQL problem. A ... [Yes, data type names can still be case sensitive]( From SQLBlog.org In this tip, I use specific examples to counter as... [Bad Habits and Best Practices]( From SQLBlog.org An index of over a decade's worth of posts and vid... [Multiple Ways to Concatenate Values Together in SQL Server]( From MSSQL Tips In this article we look at how to concatenate SQL Server data using various methods using concatenation operator, functions CONCAT and CONCAT_WS. [SQL SELECT INTO Examples for New Tables - Part 2]( From MSSQL Tips In this article we look at more ways to create a new SQL Server table using SELECT INTO as well as some specific nuances you should be aware of. [Recursive Queries using Common Table Expressions (CTE) in SQL Server]( From MSSQL Tips Learn how to write recursive queries in SQL Server by using a Common Table Expression also know as a CTE. Tools for Dev (SSMS, ADS, VS, etc.) [Display Line Numbers in a SQL Server Management Studio Query Window]( From MSSQL Tips Learn how to turn on and turn off seeing line numb...  [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -