Maybe It Is DNS (2021-10-23 DBW)

Database Weekly for October 23, 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  Maybe It Is DNS There are jokes about how often DNS is a problem. There are [stickers]( [shirts](, and [mugs]( you can buy. There's a [classic haiku](, which leads into [a rant]( about the struggles of sysadmins. I will admit that I know a little about DNS, but I find myself confused at times and usually seek assistance from others when something doesn't work. The old days of a single MX record and a few A records to map names to IPs has grown into a [much more complex system](. DNS usually works. In fact, it's lower on my list of things to check these days, though I do often get a quick DNS check when I ping an address. There are some failures, and these days when large companies have issues, it can affect a lot of people. Akamai had an issue and [knocked off a large chunk of the Internet](. When [Facebook had an issue recently](, it not only affected customers, but the engineers that were trying to fix things. Some couldn't even get into buildings. I guess relying on a single domain might be a bad idea. Most of us rely on DNS in our organizations, which means that [a rising level of DNS based attacks]( is disconcerting. These are still behind the issues we have with ransomware and DDoS attacks, but when DNS doesn't work, a lot of stuff shuts down. I could see a lot of people that work inside a company's domain for most of their work being unable to accomplish anything. I tend to use a number of domains for my daily work. Evernote and Dropbox are essential, but if one were down, I could still do things with local copies. [Red-gate.com]() is certainly important, but as long as SQL Server Central is up, I can do something different. Actually, if both were down, I could still write or create questions. I'm more bothered by slowness in my connection or machine than losing any particular service. I haven't every been too worried about DNS security, but I left sysadmin work when it was a simpler time. These days, I suspect many organizations might want to be sure they are paying attention. If they use a lot of services connected to one domain, I might think about having a secondary domain connected to a few. If I were in charge, a sqlservercentraladmin.com might be one I'd set up. Steve Jones - SSC Editor [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 [Dealing with Failed SQL Migrations in MariaDB or MySQL]( Although it is easy to get started with Flyway, there are times when real-life can trip you up. Discover the fastest ways to restore the previous version of the database, to recover from a failed Flyway migration that leaves the database in an indeterminate state, and then how to adapt your database development process to avoid these problems. [5 things to look for in a monitoring tool]( Two key findings from Redgate’s recent State of Database Monitoring Survey of over 2,500 IT professionals were that 79% of respondents reported using either a third-party or in-house monitoring tool and the satisfaction rate with third-party monitoring tools is at an all time high of 86%. But when should you use an in-house tool, and when should you take the plunge and invest in a third-party monitoring tool like SQL Monitor? [Secrets of Flyway Teams Undo]( Flyway Teams has an Undo facility that enables you to roll back one or more migrations. This article demonstrates how it works and explains how Undo migrations make testing migration scripts easier and branch-based development simpler. AI/Machine Learning/Cognitive Services [Personal Highlights of Scikit-Learn 1.0]( Yes! After more than 10 years, scikit-learn released its 1.0 version on 24 September 2021. In this post, I'd like to point out some personal highlights apart from the release highlights. [MLOps and DevOps: Why Data Makes It Different](r/oreilly/radar/atom/~3/RiP4wYBCZjg/) From O'Reilly Radar - Insight Much has been written about struggles of deploying machine learning projects to production. As with many burgeoning fields and disciplines, we don’t yet have a shared canonical infrastructure stack... Administration of SQL Server [SQL Server: Who created the database?]( Question: I have seen new database in my server. that was created nearly 45 days back. I have tried to check using standard report but no luck. SQL version: SQL server 2017 enterprise. Is it possible to find who created database. [How to Configure Repositories for Installing and Upgrading SQL Server on RHEL Virtual Machine]( From MSSQL Tips In this article we look at how to get the correct ... [Auto Create Statistics – Do the Stats Tell the Story?]( From Callihan Data When we query for data, we don’t always think about the magic that goes into efficiently returning results. One vital piece to this magic is statistics. Statistics in SQL... [SQL Server 2019 upgrade considerations]( From SQLServer-DBA.Com Lots to think about when it comes to a SQL Server 2019 upgrade [Save Enough Job History Before It’s Too Late]( From Callihan Data Let’s imagine a scenario. It’s one that I’ve been through and I suspect it’s one that some reading this post have been through as well. You come in on... Analysis Services / BI on the MS Stack [Controlling drillthrough in Excel PivotTables connected to Power BI or Analysis Services](r/sqlbi_blog/~3/C2_uUF4OuTs/) From SQLBI Learn how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. [Power BI / AAS data model optimization v2]( From Dan English's BI Blog This is an updated version of the presentation I did earlier in the year which I recently presented for the Minnesota Data Saturday 13 event this past weekend. Here... Azure Databricks, Spark and Snowflake [Visualizing data with dashboards in Azure Databricks]( From SQLShack In this article, we will learn how to create dashboards using the data that is typically processed using notebooks in Azure Databricks. Introduction In this article, we will learn... Azure SQL Database [Performance of querying blob storage with SQL]( From Simple Talk It’s possible to query blob storage using SQL, b... Azure SQL Managed Instance [Simple test results for query I/O performance on Azure SQL Managed Instance]( From Erik Darling Data Lately I’ve been doing some exploratory performance testing on Azure SQL Managed Instances in preparation for a migration to that platform. This blog post documents some storage testing results... Azure Synapse (SQL Data Warehouse and Data Lake) [How To Automatically Backup Your Azure Data Lake(House)]( Out of the box, Azure Data Lake Storage Gen2 provides redundant storage. Therefore, the data in your Data Lake(house) is resilient to transient hardware failures within a datacenter through automated replicas. [Azure Cosmos DB – HTAP using Azure Synapse Link]( From SQLServerCentral Blogs I haven’t done much blogging in the last 6 months. My last article was posted in January, on Data Governance in the Covid era. After changing jobs in March,... The... Career Growth and Certifications [Back in the office]( From Simple Talk Last week, Steve Jones (@way0utwest), Grant Fritch... [A New Form of Address: Mx]( From SQLServerCentral Blogs When I was presenting at the dataMinds Connect conference, I called on someone in the audience. At the time, I called on someone raising their hand and said something... The... [The Value of Microsoft Cloud Workshops]( From 36 Chambers – The Legendary Journeys Microsoft Cloud Workshops are free, step-by-step guides for implementing solutions in Azure. As part of the work I do with Solliance, I’ve assisted in creating and maintaining several MCWs in... [How To Become a Successful BI Developer]( From MSSQL Tips In this article we cover technical skills and soft skills that are typically found in successful BI developers. [Congratulations to the Scholarship Class of 2021.]( From Brent Ozar Unlimited To celebrate the holiday season, we give back to those who spend their entire year giving back in their own communities. We go looking for data professionals who make... Computing in the Cloud (Azure, Google, AWS) [Improving Responsiveness in Predictive Analytics with Real-Time Change Detection]( From BlueGranite Blog With the advent of Internet of Things (IOT) and th... [Automating Diagnostic Notebooks with Azure Serverless Architecture | Data Exposed]( From Azure SQL Did you know that Jupyter Notebooks can be automat... [Apache Kafka vs Microsoft Azure Service Bus]( In the ever-growing field of big data, Apache Kafka has become a widely adopted distributed streaming platform. From message queuing to event streaming, Apache Kafka delivers on a wide range of use cases. Its high throughput, scalability, and fault tolerance make it the clear-cut choice as an open source event handler. Conferences, Classes, Events, and Webinars [In conversation with Troy Hunt: Security and compliance in database monitoring]( Troy Hunt, Information Security Author & Instructor at Pluralsight, Microsoft Regional Director, and Founder of Have I Been Pwned joins Steve Jones to discuss the critical and complex role of monitoring in organizational data security and compliance. [Free #SQLPASS Keynote: 5 Ways the Cloud Impacts Your Career]( From Brent Ozar Unlimited Succeeding as a data professional is all about pla... [My new Online Training: SQL Server Query Tuning Fundamentals – German Edition]( From SQLServerCentral Blogs As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who... The... DMO/SMO/Powershell [#PowershellBasics: Get a list of files from a directory.]( From SQLStudies I’ve got a project I’m working on at the momen... Data Science [Outliers, Anomalies, and Noise]( From 36 Chambers – The Legendary Journeys This is part of the series Finding Ghosts in Your Data. For the inaugural post in this series, I want to spend a few moments on terminology. What’s the... Data Visualisation [What Makes a Good Visualization?]( From 36 Chambers – The Legendary Journeys This post has been on my backlog for about a year,... [how education looks]( From Storytelling with Data Last month, we invited you to envision education by sourcing some compelling data related to schools, academia, or learning and producing a visual that makes the “so what?” clear.... Database Design, Theory and Development [Avoiding NULL with Normalization]( From 36 Chambers – The Legendary Journeys Aaron Bertrand sticks up for NULL: A long time ago, I answered a question about NULL on Stack Exchange entitled, “Why shouldn’t we allow NULLs?” I have my share... DevOps and Continuous Delivery (CI/CD) [Data Operations and DataOps: Not One and the Same]( From Dataversity Click to learn more about author John Pocknell. In today’s competitive enterprise landscape, having a proper DataOps strategy in place correlates with better data intelligence and optimization within an organization –... [Developing Databricks’ Runbot CI Solution]( Runbot is a bespoke continuous integration (CI) solution developed specifically for Databricks’ needs. DocumentDB/Key-Value/Graph/other NoSQL Databases [Building and consuming GraphQL API in ASP.NET Core 5]( From Simple Talk GraphQL is a platform-independent, language-neutral query language and may be used to run queries and retrieve data. Joydip Kanjilal explains how to use GaphQI in an ASP.NET Core 5... [How to find the version of Hadoop and Hive?]( From Hadoop in the Real World As simple as this question sounds, we get this question a lot. So we decided to write a post on finding the version of Hadoop and […] The post How... ETL/SSIS/Azure Data Factory/Biml [What the heck is the SSISDB? Where does it come from?]( From Andy M Mallon – AM² Back in my day, we stored SQL Server Integration S... HA/DR/Always On/Clustering [How to Avoid Disaster Recovery Failures](r/Petri/~3/2l7aNaZ-UNY/how-to-avoid-disaster-recovery-failures) From Petri IT Knowledgebase Experiencing a disaster is one of the worst possible events for both businesses and their IT departments. However, there is one worse event – failure to recover from the... [Backup and Recovery – flooding and hurricanes, are you covered?]( From Steve Stedman So how about flooding or hurricanes? I live in the United States Pacific Northwest, about as far away from Florida as you can be in the lower 48 United... Hardware [Surface Duo 2: Better Hardware, Same Productivity](r/Petri/~3/7Q7oCKVjF2c/surface-duo-2-better-hardware-same-productivity) From Petri IT Knowledgebase The Surface brand is full of products that tried s... [Apple Drops Intel in Biggest MacBook Pro Overhaul in Years]( From IT Pro - Microsoft Windows Information, Solutions, Tools With its new processors and devices, Apple is aiming squarely at the high-end chips that Intel has provided for the MacBook Pro and other top-end Macs for about 15... MDX/DAX [Combine Text Strings in Power BI Using DAX]( From MSSQL Tips Learn various ways to concatenate strings in Power... [7 reasons DAX is not easy](r/sqlbi_blog/~3/k3PGi94h878/) From Sqlbi DAX is simple, but it is not easy. Watch the video... [Binary – DAX Guide](r/sqlbi_blog/~3/EAY1_wmzG28/) From SQLBI The Binary DAX data type is used in the data model to store images or other non-structured types of information. Microsoft News [Microsoft prepares another major Windows update… for Windows 10]( From Ars Technica The Windows 10 November Update, or 21H2, is now av... Performance Tuning SQL Server [A SARGability Riddle]( From Erik Darling Data Use The Force I had a RABID FAN ask me an interesting question about a query. I can’t use theirs, but I can repro the question. The question was: if using... [When Spills Cause tempdb Contention]( From Erik Darling Data Temptables I was helping a client troubleshoot a scalability issue recently, where during one point in their workload tempdb went out of control. What was puzzling them was that nothing in... PowerPivot/PowerQuery/PowerBI [Text Mining and Sentiment Analysis: Data Visualization in Tableau]( Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis with Tableau and Oracle data. [Handling “Select All” For Slicers Bound To Dynamic M Parameters In Power BI]( From Chris Webb's BI Blog Last year I blogged about handling multi-select scenarios for dynamic M parameters. Since then support for “Select All” has been added (see here) but since a regular slicer with... Product Reviews and Articles [SQL Server and Azure Purview work better together]( From MS SQL Server Blog Azure Purview, which recently became generally ava... [Getting In A State Using Flyway]( From Product learning – Redgate Software Flyway baseline migration scripts are a simple and fast way to deploy new copies of a database, at a specific version, for testing work, or to create a new... [Scripting with Flyway Teams and PowerShell]( From Product learning – Redgate Software During the development cycle, the mechanics of reliable delivery must not be allowed to dominate the design work. With script callbacks in Flyway Teams, many of the development tasks... [Some Kafka and some algorithms]( From Thirty Years Tapping A Keyboard Mastering Kafka Streams and ksqlDB: Building real-time data systems by example by Mitch Seymour I’m fascinated by the duality between streams and tables, the mixing of data at rest... Product Upgrades and Releases [Released: Microsoft.Data.SqlClient 4.0 Preview 3]( From MS SQL Server Blog Microsoft.Data.SqlClient 4.0 Preview 3 has been re... [Microsoft Launches Security Program for Nonprofits]( From Dark Reading: Dark Reading News Analysis A new set of security tools is built to assess ris... Python [DBScan Clustering in Python]( Unsupervised Learning is a common approach for discovering patterns in datasets. The main algorithmic approach in Unsupervised Learning is Clustering, where the data is searched to discover groupings, or clusters, of data. Each of these clusters contain data points which have some set of characteristics in common with each other, and each cluster is distinct and different [Build Pie Charts with Python for Displaying Counts from SQL Server Data]( From MSSQL Tips In this article we look at how to generate different types of pie charts using Python and SQL Server. R Language [Little useless-useful R functions – Useless interface for learning irregular verbs]( From TomazTsql So you want to train your knowledge on irregular verbs or your child is learning all forms of the verbs or you are getting prepared for post-covid travel a... [Little useless-useful R functions – Useless animated showcase of plot() function]( From TomazTsql Plot() function is R’s most generic function for plotting different types of graphs. And making a animation of sample graphs with is as useless as it can be useful... Security News and Issues [Pwned - The Collected Blog Posts of Troy Hunt (Preview)]( From Troy Hunt We choose this photo for the cover because this wa... [Problems with Multifactor Authentication]( From Schneier on Security Roger Grimes on why multifactor authentication isn... [Nearly Three-Quarters of Organizations Victimized by DNS Attacks in Past 12 Months]( From Dark Reading: Dark Reading News Analysis Response and recovery have significant impact on 5... [How One Healthcare System Bolstered Third-Party Security]( From IT Pro - Microsoft Windows Information, Solutions, Tools WellSpan Health employs a large number of external vendors and workers, creating security challenges. Here's how the health system improved third-party security. [Nation-State Attacker of Telecommunications Networks]( From Schneier on Security Someone has been hacking telecommunications networks around the world: LightBasin (aka UNC1945) is an activity cluster that has been consistently targeting the telecommunications sector at a global scale since at... [2021 State of Ransomware Report Reveals 83% of Victims Paid to Get Data Restored]( From Dark Reading: Dark Reading News Analysis Research by ThycoticCentrify shows a majority of organizations experienced a ransomware attack, while 93% are allocating special budget to fight growing threats. [Passwordless Is the Future … but What About the Present?]( From Dark Reading: Dark Reading News Analysis Password managers, single sign-on, and multifactor authentication each offers its own methodology and unique set of benefits — and drawbacks — to users. [Missouri Governor Doesn’t Understand Responsible Disclosure]( From Schneier on Security The Missouri governor wants to prosecute the reporter who discovered a security vulnerability in a state’s website, and then reported it to the state. The newspaper agreed to hold off... T-SQL [Bad Habits : Avoiding NULLs]( From SQLBlog.org I talk about NULLs in SQL Server, the logical issu... [Handling an unknown number of parameters in SQL Server]( From MSSQL Tips In this article we compare performance differences when splitting comma separated strings using TVPs, TVFs, openjson, string_split and more. [SQL LEFT function in queries]( From SQLShack In this article, we will learn how to use SQL LEFT function with straightforward examples. What is the SQL LEFT function? Most of the time we need to work... [Group By Starting Characters]( From SQLServerCentral Blogs I was chatting with Jeff (b|t) on my team yesterday and the context escapes me but I had this thought: “Can you Group By the beginning characters, or a... The... [Dealing with an unknown number of parameters with OPENJSON()]( From SQLBlog.org After seeing multiple people switch from STRING_SPLIT() to OPENJSON() to deal with multiple parameters, I decided to explore whether that is a change in the wrong direction. [There Has to be Room at the TOP!]( From Sherpa of Data In our continuing adventures with the TOP operator... [A handy search procedure]( From SQLBlog.org Updated this stored procedure I wrote a decade ago to search for a string in procedure bodies, object names, job steps, and more... [STRING_SPLIT Basics–#SQLNewBlogger]( From SQLServerCentral Blogs Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post on using STRING_SPLIT() with... The... Tech News [Intel Reports Q3 2021 Earnings: Client Down, Data Center and IoT Up]( From AnAndTech Kicking off another earnings season, Intel is once again leading the pack of semiconductor companies in reporting their earnings for the most recent quarter. As the company gets ready... The Lighter Side [How SpaceX ignited a new Raptor engine on Starship without an explosion]( From Ars Technica So why don't all rocket engines have giant nozzles? Tools for Dev (SSMS, ADS, VS, etc.) [Upgrade SQL Server Management Studio (SSMS) along with Azure Data Studio]( From SQLShack This article explains upgrading SQL Server Management Studio (SSMS) and Azure Data Studio (ADS) to their latest version with a single installation. Introduction SQL Server Management Studio, aka SSMS,...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -