Database Weekly for December 25, 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
 Killing IE Sort of. Apparently, Microsoft will kill off IE in Feb 2023 in Windows 10. [The lifecycle page]( notes that IE will be permanently disabled with an Edge update. For earlier OSes, it isn't quite clear what will happen. However, extended support ends this month, Jan 2023, for Windows 7 and 8. Does anyone use Windows 8? I have used IE many times in my career, but the last decade of so I've shuddered every time I need to run it on a server or remote machine. It's ancient technology that feels cumbersome, much like trying to get something done on a Palm Pilot instead of a modern smartphone. I know there are lots of websites and apps that use technology that works in IE, and Microsoft is adding an IE Mode to Edge for those cases. Microsoft has a "[what you need to know](" article you can read, but it seems more like an advertisement for Edge than an informative article. I could care less about IE, and I mostly don't think I've needed it in years, but I do encounter that technology in a few places. Outlook is the main one where some sort of IE-based control is still being loaded for some authentication mechanisms. I think removing IE is one thing, but getting rid of embedded controls based on IE is going to be a much harder and longer-term issue. I know so many developers that used various versions of the browser control in their apps, and I suspect there is no shortage of places that IE tech will continue to be a problem. I'm sure it works most of the time, but probably not always. Hopefully, most of you out there use a modern browser for your work, and if you need one inside an application, you use something besides an embedded IE-era control. If you need an alternative, there's [an older Stack answer]( that might help. Please, use anything by an IE control. It's time we let that technology retire gracefully in a museum somewhere. 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 [A Version Control Strategy for Database DevOps]( Our goal was to transform a 'serial' and manual development and release process into one that supported parallel development work and automated releases. This article explains step one: migrating our monolithic, centralized repos to Git, then implementing a Release Flow branching strategy for parallel development work streams, and a Pull Request workflow to control an automated build and release process. AI/Machine Learning/Cognitive Services [Advent of 2022, Day 24 â Further reading and code material for Azure Machine Learning]( From TomazTsql  [Create Texts with a Markov Chain Text Generator⦠and what this has to do with ChatGPT!]( From Learning Machines Everybody and their dog are talking about ChatGPT ... [Capital Oneâs Abhijit Bose on Best Practices for Machine Learning]( From Past News - RSS Feeds I spoke with Abhijit Bose, Head of Enterprise Machine Learning and AI Engineering at Capital One, about how to optimize a machine learning deployment, from handling typical challenges to... [Advent of 2022, Day 21 â Using Azure Machine Learning terminal]( From TomazTsql In the series of Azure Machine Learning posts: Using Azure CLI can help you progress faster, make repetitve tasks automated and even use the GIT integration, for faster and... [Advent of 2022, Day 19 â Statistical analysis and ML comparison of prediction models]( From TomazTsql In the series of Azure Machine Learning posts: Yesterday we have shown, that statistical analysis and all bolts and whistles can be done super simple in Azure machine learning.... Administration of SQL Server [Lesson Learned #256: Connection was denied since Deny Public Network Access and DNS resolution.]( From Azure Database Support Blog Once a private link is created our customers disab... [Lesson Learned #258: Python vs Connection Refused with Login timeout expired]( From Azure Database Support Blog Today, I worked on a service request that our cust... [T-SQL Tuesday #157- âEnd of Year Activityâ â RECAP]( From SQLServerCentral Blogs I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below... The... [Use of the RESTORE FILELISTONLY command in SQL Server]( From SQLShack This article explores the RESTORE FILELISTONLY command in SQL Server with examples. Introduction Performing a database backup is an integral part of a DBAâs job. Backups are taken to... [Lesson Learned #255: SSL is required but not requested using JDBC.]( From Azure Database Support Blog Today, I worked on a service request that our customer got the following error message: SSL is required but not requested. This issue means that SSL is required (Azure... [SQL Server Wait Type: SOS_PHYS_PAGE_CACHE]( From Steve Stedman Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application... [SQL Server 2022: How Auto-Drop Statistics Work]( From Simple Talk Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table structure is not blocked by the presence of the... [SQL Server Backups]( From Steve Stedman SQL Server backups are an essential part of any database administratorâs job. In this blog post, weâll discuss what SQL Server backups are, why theyâre important, and how to...
Azure CosmosDB [How to Create Azure Function for Azure Cosmos DB using VsCode]( From Hasan Savran    Azure Cosmos DB's Change Feed feature triggers an event for Inserts and Updates in a collection. The easiest way to handle these events is, by executing an... Azure SQL [Security Investments in Azure SQL Database & Azure SQL Managed Instance in 2022]( From Azure SQL The mission of the Security & Governance team ... [Python serverless functions to query Azure SQL DB]( From SQLShack This article will show how to get data from Azure SQL in the Serverless Python app. Introduction Application and data tier communication has evolved over the period. Azure offers... Azure SQL Managed Instance [Stack Overflow's path to the cloud]( From SQLBlog.org I talk about some of the pivotal criteria guiding ... [Enable Auditing for Azure SQL Managed Instance]( From MSSQL Tips In this article, we look at how to enable auditing for an Azure SQL Managed Instance. Career, Employment, and Certifications [Data Engineering Interview Questions]( From Paul Andrew Something a little different for this post⦠I wa... [The Mentoring Class of 2023]( From In Recovery... (Meeps, one of our seven cats, helping with the selection processâ¦) Since my first round of community mentoring back in 2015, when I mentored 54 people for six months,... [Microsoft certifications are a slow-moving target]( From Kevin Chant Reading Time: 3 minutes In this post I want to explain why I think Microsoft certifications are a slow-moving target. I want to cover this due to some... [Resolving to Write in the New Year]( From Simple Talk It is almost New Yearâs Day, that time when the optimistic at heart start thinking about making changes in their life on that magical day that ends the year.... Computing in the Cloud (Azure, Google, AWS) [Cloud Predictions 2023: The Innovation Question]( From Past News - RSS Feeds  [Lesson Learned #254: Checking Execution Timeouts in Azure Log Analytics]( From Azure Database Support Blog Today, I worked on a service request when our customer needs to know several details about the command timeout captured (attention event) and sent to Log Analytics from Azure... [AWS Week in Review â December 19, 2022]( From AWS News Blog We are half way between the re:Invent conference and the end-of-year holidays, and I did expect the cadence of releases and news to slow down a bit, but nothing... Conferences, Classes, Events, and Webinars [VMUG Ireland Relaunch Event]( From DBA From The Cold SAVE THE DATE: VMUG Ireland Relaunch Event February 9th, 2023 Location: Dublin VMUG Ireland is back! We are hosting a VMUG Relaunch event in Dublin on February 9th, 2023.... [New Course â Preparing for Corruption in SQL Server]( From Steve Stedman Corruption in a SQL database is when the database becomes damaged or corrupted, making it unable to be used or accessed. This can happen for a number of reasons,... DMO/SMO/Powershell [Create multiple DNS A Records with PowerShell]( From Sid 500 PoSh Imagine you have to create hundreds or thousands of DNS records. Do you want to do that one by one? Surely not. I will show you an example how... [PowerShell: How To Reverse Alphabetical File Names & Rename]( Recently I had shot a bunch of videos on a Video App on my iPhone. By default it saves the videos/photos within the App itself. Later, I can move them to iPhone âPhotosâ. Data Privacy, Compliance, and Governance [Finding the Right Data Governance Model]( From Dataversity Data Governance has received much attention in both the academic and practitioner communities over the past 15 years. Compared to the even more recent concept of Data Governance, IT governance has... ETL/SSIS/Azure Data Factory/Biml [Use the output of a Script activity as the items in a ForEach activity in Data Factory]( From SQLServerCentral Blogs In early 2022, Microsoft released a new activity i... Excel [Excel Small Multiples And Sparklines: Fun With Dynamic Arrays, Let, Lambda And Image]( From Chris Webb's BI Blog Use new Excel functionality to return small multiples of sparklines Hardware [Corsair MP600 GS SSD Review: Middling, but Capable]( From Tom's Hardware US The Corsair MP600 GS isn't exactly an exciting mid... Performance Tuning SQL Server [Thoughts on RLS for Data Migration]( From Forrest Shares Stuff The common corporate amoeba floats around, graspin... [SQL Server For Beginners: How Eager Index Spools Cause Performance Problems Demo]( From Erik Darling Data +OK [Another Method to Reduce Temp Table Plan Cache Pollution]( SQL Server allows stored procedures to reference temporary tables that were created in an outer scope. However, doing so can cause the plan cache pollution problem described here. [SQL Server For Beginners: What Spools Mean In Query Execution Plans]( From Erik Darling Data +OK PowerPivot/PowerQuery/PowerBI [Power BI DirectQuery Mode And Degenerate Dimensions]( From Chris Webb's BI Blog Why using a column from a large fact table as a di... [SQL Server Agent Gantt Chart in Power BI]( From Purple Frog Systems In this blog post, I walk-through how to use a Pow... [Migrating to Power BI, but how?]( Over the last half year, I have been involved in many large migration projects from another BI tool to Power BI. All with a different setup, from Tableau, Microstrategy and from Analysis Services to Power BI. In this blog I will shine a light on the experiences I gained during these migrations and share some doâs and donâts. [Custom Date Templates with Bravo for Power BI]( From SQLBI This video explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool. [Multiple Text Options for Button Navigators in Power BI]( From Havens Consulting Video by: Reid HavensLearn how to combine button navigators to create a multiple (alternative) button effect options for either the Page or Book Navigator objects in Power BI. This... [Enhancing Power BI Apps with Emoji]( From eHansalytics Your report page names, and in turn, the Power BI app can be enhanced with the judicious use of emoji. I was surprised to find out that the characters... [Content Endorsement in Power BI, Part 2, Endorsing Contents]( In the previous post I explained the basic concepts around content endorsement in Power BI. We discussed that usersâ ability to collaborate in creating and sharing content is one of the key aspects of usersâ experience in Power BI. But it would be hard, if not impossible, to identify the quality of the content without a mechanism to identify the content quality in large organisations. Content endorsement is the answer to this challenge. [Customizing date and time intelligence templates in Bravo for Power BI]( From SQLBI This article explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool. Thanks to... Press Releases [dbForge Products Won Awards in Q2-Q4 2022](h.45nj1ntmeyvi) The dbForge Studio product line along with dbForge SQL Complete was shortlisted by Capterra 2022 according to user feedback and monthly search volumes for relevant keywords. All dbForge Studios consistently rank among the top database solutions on Capterra. In particular, dbForge Studio for SQL Server is ranked in the top 10 free database software and in the top 9 open-source database software. Product Reviews and Articles [Dealing with Mutually Dependent Databases in Flyway]( From Product learning â Redgate Software How to create and manage 'stub' objects, in Flyway migrations, in order to overcome build failures caused by circular, or mutual, dependencies between objects in different databases. The technique... [A SQL Compare Picklist]( From SQLServerCentral Blogs Recently a customer was trying to sync up production and development. Theyâd somewhat lost control of both environments and wanted to build a plan of how to sync them.... The... Product Upgrades and Releases [Whatâs New in Visual Studio Extensions for SSAS and SSRS]( From MS SQL Server Blog We have just released the new Visual Studio extensions for SSAS 2022 and SSRS 2022. Microsoft Analysis Services Projects 2022(SSAS) and Microsoft Reporting Services Projects 2022(SSRS) provide project templates... Python [Bucket Sort Algorithm in Python to Sort a List of Array Values]( From MSSQL Tips Learn about how to implement a simple bucket sort ... [Import Data from an Excel file into a SQL Server Database using Python]( From MSSQL Tips Learn how to import data from an Excel file into a SQL Server database using Python. R Language [Advent of 2022, Day 23 â Working with R]( From TomazTsql In the series of Azure Machine Learning posts: Thi... SQL Server Security and Auditing [Lesson Learned #257: Encryption scheme mismatch for columns/variables]( From Azure Database Support Blog Today, I worked on a service request that our cust... [Understanding Keys and Certificates with TDE]( From SQLServerCentral Blogs When you first look at the encryption hierarchy for TDE in SQL Server it can be a bit daunting. There seem to be a lot of objects involved and... The... [What is TDE (Transparent Data Encryption)?]( From SQLServerCentral Blogs TDE is referred to as a âtransparentâ form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The... The... Security News and Issues [LastPass Confirms Hackers Stole Personal Data and Encrypted Password Vaults]( From Petri IT Knowledgebase Back in August, LastPass announced that its system... [Do Not Email Passwords]( From Steve Stedman Itâs never a good idea to email passwords, whether itâs your own personal password or a password that youâre sharing with someone else. Here are a few reasons why:... Software Development [Lesson Learned #253: Retry Logic for Execution Timeout Expired]( Today, I worked on a case that our customer faced an execution command timeout "Msg -2, Level 11, State 0, Line 0 - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding" T-SQL and Query Languages [Counting a character in a column]( From World of Whatever Counting a character in a columnI ran into an issu... [Min and Max Aggregate Functions in TSQL]( From Steve Stedman Here is a sample query using the MIN and MAX funct... [Should You Use SQL Server 2022âs GREATEST and LEAST?]( From Brent Ozar Unlimited  [Should You Use SQL Server 2022âs DATETRUNC?]( From Brent Ozar Unlimited SQL Server 2022 introduced a new T-SQL element, DA... [Options to Compare Table Records]( From Callihan Data We recently looked at looked at comparing schemas using Azure Data Studio. What if we need to compare tables by using a query? For this post weâll compare using... [Should You Use SQL Server 2022âs STRING_SPLIT?]( From Brent Ozar Unlimited SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to be in order. However, thatâs the only thing they improved â... [Fun With KQL â CountIf]( From Arcane Code Fun With KQL - CountIf Tech News [When â and When Not â to Outsource IT Operations]( From IT Pro - Microsoft Windows Information, Solutions, Tools Is outsourcing your IT operations the best way to meet your IT needs? We look at the benefits and drawbacks of outsourcing IT. [Microsoft to Permanently Disable Internet Explorer 11 in February 2023]( From Petri IT Knowledgebase Microsoft has announced some changes in its plans to kill... The Lighter Side [Overpowered Ornament Contains Tiny Raspberry Pi Cluster]( From Tom's Hardware US Maker Chris Bensen has packed dual Raspberry Pi Ze... [The worst technology of 2022]( From Technology Review Feed - Tech Review Top Stories  Weâre back with our annual list of the worst technologies of the year. Think of these as anti-breakthroughs, the sort of mishaps, misuses, miscues, and bad ideas that... Virtualization and Containers/Kubernetes [Container Verification Bug Allows Malicious Images to Cloud Up Kubernetes]( From Dark Reading: Dark Reading News Analysis A complete bypass of the Kyverno security mechanis...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -