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

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 FeedTwitter
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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -