You Never Know

Database Weekly for November 18, 2023 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  You Never Know I'm writing this sitting at the PASS Data Community Summit. It's been a fantastic event. I gave a community session on Azure DevOps. I was able to help Redgate launch a new product. I've received a bunch of hugs from VERY dear old friends. I've met a ton of people. It's been great. Allow me to take a moment to tell you how I got here. In 2005, I attended my very first PASS Summit. I went to sessions. I went back to my hotel. I went to one, exactly one, party where I just happened to talk to a couple of volunteers who helped run the event. After speaking with them a bit, my life changed. I started volunteering. I wrote articles. I wrote a book. I presented sessions. I become an MVP. And I got the best damned job I ever had. All from a single conversation. You never know. You simply don't know what it's going to be, but it's going to be something. So, a couple of lessons here. You have to put yourself in the situation where you can have that critical conversation. Please, look for and take advantage of those opportunities. Also, you simply don't know how you're going to affect others. You may think you're just hanging out and drinking with a new acquaintance, but you might be changing someone's life trajectory. You never know. Grant Fritchey [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 [Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.]( Is MongoDB in use within your organization? The Flyway development team are adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey. [Using SSDT and DACPACs with Flyway: a Demonstration]( The aim of this article is simply to demonstrate that you can use two DACPAC files, representing the source and target versions of a SQL Server database, to create a migration file that can then be used in Flyway. AI/Machine Learning/Cognitive Services [Behind Microsoft CEO Satya Nadella’s push to get AI tools in developers’ hands]( From Technology Review Feed - Tech Review Top Stories In San Francisco last week, everyone’s favorite ... [Exploring the environmental impact of AI and analytics in the cloud]( From AllAnalytics Cloud computing has become the backbone of countless industries, helping organizations use the power of analytics, machine learning and AI for insights and innovation. However, the rapid expansion of... [3 ways generative AI can level the field with health care fraudsters]( From AllAnalytics Over the last year, generative AI has captivated the public imagination. Many of us have become newly acquainted with the concept of an approaching Singularity coined by John von... [Machine Learning: Challenges and Opportunities for Modern Data Executives]( From Dataversity The transformational promise of artificial intelligence (AI) and machine learning (ML) for enterprises has fueled enormous excitement and massive investment by data executives. One estimate predicts that AI’s contribution... [Microsoft’s Copilot Assistant is Coming to Windows 10 PCs]( From Petri IT Knowledgebase Microsoft has just started rolling out a new Windo... [Making sense of the AI hype with Katie King]( From AllAnalytics Katie King has interviewed subjects from many walks of business life for her books: academics, venture capitalists, executives from high-profile brands and telecommunications companies. Among them, one that made... Administration of SQL Server [Deploying Indexes with SQL Compare]( From SQLServerCentral Blogs I suspect many people assume this is the case, but... [Online disaster recovery between SQL Server 2022 and SQL Managed Instance - Preview]( From Azure SQL We’re excited to announce a major new capability... [Webinar: How to Harden SQL Server]( From SQLServerCentral Blogs On November 29, 2023, at 11 AM Eastern Standard Ti... [Azure SQL + SQL Server Year in Review, 2023]( From Azure SQL TODO [SQL SERVER – Exploring 3 Underutilized Features]( From Journey to SQL Authority with Pinal Dave This blog post will explore three underused features that can significantly enhance your SQL Server experience. Let us discuss 3 Underutilized Features. First appeared on SQL SERVER – Exploring 3... [SQL SERVER – Exploring 3 Overutilized Features]( From Journey to SQL Authority with Pinal Dave Potentially leading to less efficient implementations or missed opportunities for optimization. In this blog post, we'll explore three such Overutilized features. First appeared on SQL SERVER – Exploring 3 Overutilized... [Cumulative Update #10 for SQL Server 2022 RTM]( From MS SQL Server Blog The 10th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to... Azure CosmosDB [Cosmos DB – Monitoring performance]( From SQLServerCentral Blogs Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query... The... Azure SQL [Announcing Public Preview of premium-series hardware for Azure SQL Database Hyperscale elastic pools]( From Azure SQL We are excited to announce the public preview (in ... [General Availability: Lower pricing for Azure SQL Database Hyperscale expected in December 2023]( From Azure Updates Build new and highly scalable applications on Azur... [Public preview: Azure Backup supports long term retention for backup of Azure Database for PostgreSQL– Flexible Server]( From Azure Updates Now you can retain backups for up to 10 years by d... [License-free standby replica for Azure SQL database]( From Azure SQL To protect database powering the application from ... Cloud - AWS [AWS Glue Data Catalog now supports automatic compaction of Apache Iceberg tables]( From AWS News Blog Update November, 16 2023 — I added a link to the... [Build AI apps with PartyRock and Amazon Bedrock]( From AWS News Blog If you are ready to learn more about Generative AI while having fun and building cool stuff, check out PartyRock.aws . You can experiment, learn all about prompt engineering,... [New – Long-Form voices for Amazon Polly]( From AWS News Blog We are launching three new voices for Polly. Powered by a new long-form engine, the voices are natural and expressive, with appropriate pauses, emphasis, and tone. New Voices The... [Happy anniversary, Amazon CloudFront: 15 years of evolution and internet advancements]( From AWS News Blog I can’t believe it’s been 15 years since Amazon CloudFront was launched! When Amazon S3 became available in 2006, developers loved the flexibility and started to build a new... [AWS, Google Team Up with Linux Foundation on Cloud Spending Specification]( From IT Pro - Microsoft Windows Information, Solutions, Tools Together with cloud giants AWS, Microsoft, Google Cloud, and Oracle Cloud, the FinOps Foundation, a Linux Foundation project focused on cloud financial management, has created a universal cloud billing... Cloud - Azure [GA: Ultra Disk performance updates]( From Azure Updates Azure Ultra Disk Storage now provides maximum thro... [Power what’s next with limitless relational databases from Azure]( From Microsoft SQL Server Blog We were excited to get back in front of customers ... [Generally Available: Red Hat Enterprise Linux 9.3 now supported on Azure Virtual Machines]( From Azure Updates Red Hat Enterprise Linux (RHEL) 9.3, the latest version of RHEL 9 from Red Hat is now generally available on Azure Virtual Machines (VMs). Availability of RHEL 9.3 for... [Part 1: The Modern Azure Data Warehouse – Choosing The Tech]( From SQLServerCentral Blogs With reports hitting the transactional databases, we were encountering performance issues. We needed to choose a path forward that would lighten the load on the prod database servers and... The... Community Interests [PASS Summit 2023 – Microsoft Keynote – Limitless growth, limitless opportunities: Data and innovation in an AI world]( From Simple Talk I arrived early to get my seat at the media table.... [PASS Data Summit 2023 KeyNote 1]( From SQLServerCentral Blogs Morning from the PASS Data Summit! I will be live ... [PASS Summit 2023 – Redgate Keynote – The New Database Landscape – Revealing Shifts and Charting the Next Horizon]( From Simple Talk Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence!   Carly Miechen – Redgate Events Welcome to day 2. Let the... [PASS Data Summit 2023 KeyNote 2]( From SQLServerCentral Blogs Morning from the PASS Data Summit! I will be live blogging the event again today, so check back for announcements and releases throughout the keynote. Today, we will dive... The... [Navigating the Pitfalls of IT Training Programs]( From IT Pro - Microsoft Windows Information, Solutions, Tools The bulk of today's boot camps fail to provide the breadth of tech knowledge needed to excel in elite IT positions. [Women in Tech: Finding Allies #PASSDataSummit]( From SQLServerCentral Blogs The WIT panel spoke on an excellent topic today: needing, and finding, allies at work. Afterward and for the first […] The post Women in Tech: Finding Allies #PASSDataSummit appeared... The... [PASS Summit 2023 – Community Keynote – AIOps and ChatGPT – Prepare to Ride the Next Wave]( From Simple Talk Last but not least, the Community Keynote. Hang on to your hats, this is going to be an interesting ride! President/Founder of SQL Skills – Kimberly Tripp Surprised people... Computing in the Cloud (Azure, Google, AWS) [Google DeepMind wants to define what counts as artificial general intelligence]( From Technology Review Feed - Tech Review Top Stories AGI, or artificial general intelligence, is one of the hottest topics in tech today. It’s also one of the most controversial. A big part of the problem is that... [How to unlock your leadership potential on a cloud migration project: A guide for the DBA, part 1]( From Blog – Redgate Software If your organization is embarking on a cloud migration project, it can be a great opportunity to develop skills and qualities that will help unlock your leadership potential. But... [2023 Global Cloud Ecosystem]( From Technology Review Feed - Tech Review Top Stories The cloud, fundamentally a tool for cost and resource efficiency, has long enabled companies and countries to organize around digital-first principles. It is an established capability that improves the... Conferences, Classes, Events, and Webinars [Live Redgate Product Launch: Transform your software delivery with Test Data Management]( Don’t worry if you missed Redgate’s live stream announcement at PASS Data Community Summit - you can join David Gummer, Chief Product Officer at Redgate, and Alex Yates, Senior Solutions Specialist at Redgate, live on the 29th of November to learn: How test data management can benefit you in your role How you can reap benefits including accelerated data provisioning, and improved quality and speed of application releases Top takeaways from the exciting launch at PASS Data Community Summit 2023 How Redgate have worked to simplify the challenges of managing and getting your hands on quality (yet compliant) test data [Live Redgate Product Launch: Transform your software delivery with Test Data Management]( Don’t worry if you missed Redgate’s live stream announcement at PASS Data Community Summit - you can join David Gummer, Chief Product Officer at Redgate, and Alex Yates, Senior Solutions Specialist at Redgate, live on the 29th of November to learn: How test data management can benefit you in your role How you can reap benefits including accelerated data provisioning, and improved quality and speed of application releases Top takeaways from the exciting launch at PASS Data Community Summit 2023 How Redgate have worked to simplify the challenges of managing and getting your hands on quality (yet compliant) test data Data Mining / Data Analysis [How SAS users are benefiting from the career versatility of data analytics]( From AllAnalytics More than spreadsheets and formulas, data analytic... [From Service to Software: Sean's Story]( From AllAnalytics From Service to Software, and Back Again At SAS, he’s known as “DJ Mobelizer” or “The DJ”, but the man behind the music at SAS events, is none other... Database Design, Theory and Development [No Database Is Perfect: Applying CAP Theorem to Database Choice]( From Dataversity Since its introduction to the marketplace in 2000, the consistency, availability, and partition theorem, or CAP theorem, has been a guiding principle in database management. Computer scientist Eric Brewer presented... DevOps and Continuous Delivery (CI/CD) [What is MLOps? An Overview of Machine Learning Operations]( From Past News - RSS Feeds MLOps is the practice of applying DevOps principles to machine learning. Learn more about MLOps and how it can help you streamline your ML workflow. The post What is MLOps?... [Ascend.io CEO Sean Knapp on Automating Data Pipelines]( From Past News - RSS Feeds I spoke with Sean Knapp, CEO of Ascend.io, about the issues and challenges involved with automating data pipelines. Among other key points, he noted that “Companies that don’t have... General [Tuning Using Windows Functions]( Sometimes query tuning involves taking a different approach to a problem. And given that other tuning options might be creating index(es) or redesigning tables – both of which are much more permanent changes to an environment – rewriting a query can often be just right. Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Thoughts about the Microsoft Fabric journey to becoming Generally Available]( From Kevin Chant Reading Time: 6 minutes In this post I want to share my thoughts about the Microsoft Fabric journey to becoming Generally Available (GA). Which was announced by Microsoft... [Digging deeper into Data Activator in Microsoft Fabric]( From Guy in a Cube We look deeper at Data Activator in Microsoft Fabr... [Microsoft Fabric in GA: What It Means]( From Curated SQL Matt Gordon gives us the lowdown: At their Microsoft Build conference in May 2023, Microsoft announced the company’s new unified analytics solution, Microsoft Fabric. As… Oracle/PostgreSQL/MySQL/other RDBMS [Database Concurrency in PostgreSQL]( Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs various techniques to ensure concurrent access to the database while maintaining data consistency using atomicity and isolation of ACID (stands for Atomicity, Consistency, Isolation and Durability properties. Performance Tuning SQL Server [How Multi-Statement Table Valued Functions Cause Performance Problems In SQL Server]( From Erik Darling Data How Multi-Statement Table Valued Functions Cause Performance Problems In SQL Server   Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... PowerPivot/PowerQuery/PowerBI [Unboxing DAX Query View in Power BI – Unplugged #54]( From Sqlbi Discover the new DAX Query View introduced in Power BI Desktop November 2023. Spoiler: it is a good feature! Python [Getting Started with Python Integration to SAS Viya for Predictive Modeling - Imputing Missing Values]( From AllAnalytics In part 1 of this series, we examined our data bef... Security News and Issues [Rackspace Ransomware Costs Soar to Nearly $12M]( From Dark Reading: Dark Reading News Analysis Rackspace's 2022 ransomware attack costs only cont... [EU Tightens Cybersecurity Requirements for Critical Infrastructure and Services]( From Dark Reading: Dark Reading News Analysis Organizations in "essential" sectors have until Oc... [Takeaways From the MGM Attack and Emerging Threat Landscape]( From IT Pro - Microsoft Windows Information, Solutions, Tools To prevent cyberattacks, organizations must implement strong security measures, adapt to new challenges, and promote digital literacy. [Consumer Software Security Assessment: Should We Follow NHTSA's Lead?]( From Dark Reading: Dark Reading News Analysis Vehicles are required to meet basic safety standar... T-SQL and Query Languages [Working around schema drift in SQL Server]( At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across a large number of sites. Let’s say, pulling or removing information from the Users table, and related tables, across all of our databases. Tech News [Minimizing Legal Risks in the Procurement Function]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here's how organizations can reduce legal risks du... [Gaming the Electric Grid – PV Solar]( From Glenn Berry Introduction The second post in this series, Gaming the Electric Grid – PV Solar will cover my experiences with residential grid-tied PV solar systems as a homeowner over the... [What’s coming next for fusion research]( From Technology Review Feed - Tech Review Top Stories This article is from The Spark, MIT Technology Review’s weekly climate newsletter. To receive it in your inbox every Wednesday, sign up here. We’ve covered the dream of fusion... [Making Accessibility Part of the Design Process – Part 1]( From Simple Talk Accessibility should not be an afterthought In a world that thrives on connectivity and progress, the concept of accessibility has emerged as a fundamental bridge that connects diverse individuals... [The pain is real. The painkillers are virtual reality.]( From Technology Review Feed - Tech Review Top Stories This article first appeared in The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, and read articles like this first, sign up here....  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -