| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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 |
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 |
Everybody and their dog are talking about ChatGPT ... |
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... |
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... |
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 |
Once a private link is created our customers disab... |
Today, I worked on a service request that our cust... |
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... |
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... |
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... |
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... |
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 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 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... |
The mission of the Security & Governance team ... |
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 |
I talk about some of the pivotal criteria guiding ... |
In this article, we look at how to enable auditing for an Azure SQL Managed Instance. |
Career, Employment, and Certifications |
Something a little different for this post… I wa... |
(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,... |
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... |
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) |
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... |
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 |
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.... |
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,... |
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... |
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 |
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 |
In early 2022, Microsoft released a new activity i... |
Use new Excel functionality to return small multiples of sparklines |
The Corsair MP600 GS isn't exactly an exciting mid... |
Performance Tuning SQL Server |
The common corporate amoeba floats around, graspin... |
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. |
PowerPivot/PowerQuery/PowerBI |
Why using a column from a large fact table as a di... |
In this blog post, I walk-through how to use a Pow... |
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. |
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. |
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... |
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... |
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. |
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... |
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 |
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... |
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 |
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... |
Learn about how to implement a simple bucket sort ... |
Learn how to import data from an Excel file into a SQL Server database using Python. |
In the series of Azure Machine Learning posts: Thi... |
SQL Server Security and Auditing |
Today, I worked on a service request that our cust... |
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... |
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... |
Back in August, LastPass announced that its system... |
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:... |
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 columnI ran into an issu... |
Here is a sample query using the MIN and MAX funct... |
SQL Server 2022 introduced a new T-SQL element, DA... |
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... |
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 –... |
Is outsourcing your IT operations the best way to meet your IT needs? We look at the benefits and drawbacks of outsourcing IT. |
Microsoft has announced some changes in its plans to kill... |
Maker Chris Bensen has packed dual Raspberry Pi Ze... |
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 |
A complete bypass of the Kyverno security mechanis... |
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. |
|
|