A Lot of Interesting Theory This Week

Database Weekly for May 4, 2024 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  Take Care The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take care of family, whether it's aging family members (Hi!), or kids or grandkids. You're in a management role and have team members that you look after. So putting yourself first seems either wrong or impossible. In some circumstances, at some times, it may well be. However, if you're literally not there, due to sickness, injury, or worse, then you're not meeting those responsibilities anyway. So, you must take of yourself in order to be able to take care of others. When I say to take care of yourself, I mean it on multiple levels too. First up, emotionally and mentally. All the stuff going on around is draining. I know I feel it. So, you need to find those things that get you recharged. It might be a good night's sleep. Maybe for you it's some time out on the water. Visiting a museum? Heck, seeing the therapist. Whatever it might be, make sure you carve out some time to get your brain reset. Next, physically. I'm not great at it (oh, my wife can tell you), but I try to get in three workouts in a week. Plus, weekends I'm frequently doing physical labor. And again, I know because I've got (new) hard limits on what I can do, you may not be able to exercise or do hard labor. Do what you can. Physical fitness and exercise has been proven, time and again, in replicated studies, that it not only improves your physical well-being, but positively impacts your mental and emotional wellness. See point one. Again, carve some time out for whatever physical exercise you can do. Finally, safety. Stuff is happening around us. Personally, I'd suggest taking a self-defense class or three if you don't already study it. No, I don't mean "I know Kung Fu" classes. Find classes in your area that teach situational awareness, things like that. None of us is John McClain. We're not going to karate chop our way to freedom. No, in terms of safety I'm talking about the biggest self-defense technique there is: don't be there. Avoid the situation entirely. When you hear the chants coming down the street, head the other way, even if it's going to make you late to work. Keep your head on a swivel. Know your surroundings and respond accordingly. Learn to recognize escalating violence, both in groups and individually. Learn to deescalate, or better still, just walk (or run) away. Keep yourself safe. Yeah, I know. Kind of a depressing topic. Still, it's something to think about. Don't obsess over it, but have it in mind. In order to take care of others, you must take care of yourself. Neither of these is mutually exclusive in the long run. Please, take care. 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. AI/Machine Learning/Cognitive Services [Roundtables: Inside the Next Era of AI and Hardware]( From Technology Review Feed - Tech Review Top Stories Recorded on April 30, 2024 Inside the Next Era of ... [New Learning Path: AI Apps with Azure Database for PostgreSQL]( From 36 Chambers – The Legendary Journeys Microsoft has released a new learning path yesterd... [Optimizing Investments in Copilot for Microsoft 365: How To Get Started]( From IT Pro - Microsoft Windows Information, Solutions, Tools Organizations should not only invest in AI technology like Copilot Microsoft 365 but also prioritize education, continuous training, and analytics to ensure successful implementation and maximize ROI. [Now Is the Time for Executives to Deploy Ethical Rules Around AI]( From Dataversity For better or worse, AI is causing disruption in almost every field imaginable. Corporations around the world are embracing its possibilities to make work more efficient. The success of... Administration of SQL Server [Snake draft sorting in SQL Server, part 2]( In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel. In the previous example, we determined a distribution order for databases based on size – though you can rank by literally any attribute (or combination of attributes). Once we’ve determined how to build out this order, we may want to store that data somewhere because, sometimes, the source of that data is not directly accessible. [Snake draft sorting in SQL Server, part 1]( I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times. Imagine a job that loops through and restores each database in sequence. [6 Best SQL Training Courses for Beginners (2024 Updated)]( From SQLServerCentral Blogs We all know that choosing the right basic SQL trai... [Will AI Replace SQL Developers? The Answer Might Surprise You!]( From SQLServerCentral Blogs The world of databases keeps growing, and the pres... [SQL Server Management Studio issues with Central Management Servers in v20.1]( From The Bit Bucket I've recently been doing work with a site that makes extensive use of Central Management Servers. And that's an issue if you upgrade past v19.3 of SSMS. Central Management... [Why Read Committed Queries Can Still Return Bad Results In SQL Server]( From Erik Darling Data Why Read Committed Queries Can Still Return Bad Results In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning... [SMS: PRIMARY KEYS & INDEXES]( From Database Debunkings Note: I am working on entirely new papers (not re-writes) in the PRACTICAL DATABASE FOUNDATIONS series. Two were already published:THE FIRST NORMAL FORM - A DEFINITIVE GUIDEPRIMARY KEYS -... [SQL Server Diagnostic Information Queries for May 2024]( From Glenn Berry Introduction These are my SQL Server Diagnostic Information Queries for May 2024, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration... Azure SQL [SQL Down Under show 90 with guest Joe Sack discussing Azure SQL Database and Copilot is now published!]( From The Bit Bucket Joe Sack is an old friend. (I've known him a long ... [Code Analyze your SQL scripts in Visual Studio and elsewhere | Data Exposed: MVP Edition]( From Azure SQL Maybe you already take advantage of the C# code an... [Check Azure SQL DB Space Used]( From SQLServerCentral Blogs A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some files to lower the bill. To check my progress I needed to... The... [Introducing Regular Expressions (Regex) support in Azure SQL Database | Data Exposed]( From Azure SQL In this episode of Data Exposed, we'll introduce the new Regular Expressions (Regex) feature in Azure SQL Database. Join us to discover the built-in T-SQL REGEX functions in Azure... Cloud - AWS [Run scalable, enterprise-grade generative AI workloads with Cohere Command R & R+, now available in Amazon Bedrock]( From AWS News Blog In November 2023, we made two new Cohere models av... [Add your Ruby gems to AWS CodeArtifact]( From AWS News Blog Ruby developers can now use AWS CodeArtifact to se... [Stop the CNAME chain struggle: Simplified management with Route 53 Resolver DNS Firewall]( From AWS News Blog Updated 2 May 2024: I removed the reference to Route53 Alias that was incorrectly referred as a chain Starting today, you can configure your DNS Firewall to automatically trust... [Build RAG applications with MongoDB Atlas, now available in Knowledge Bases for Amazon Bedrock]( From AWS News Blog Foundational models (FMs) are trained on large volumes of data and use billions of parameters. However, in order to answer customers’ questions related to domain-specific private data, they need... Computing in the Cloud (Azure, Google, AWS) [Can Your IT Operating Model Keep Up With Cloud?]( From IT Pro - Microsoft Windows Information, Solutions, Tools Forrester describes its Cloud Operating Model Fram... [AWS, Microsoft, Google Continue to Invest in Cloud as Demand Grows in AI Era]( From IT Pro - Microsoft Windows Information, Solutions, Tools The Big 3 cloud providers start 2024 off strong, fueled by organizations' growing adoption of AI. Conferences, Classes, Events, and Webinars [Introducing the pre-con schedule for PASS Summit 2024]( The first speakers and sessions have just been announced for PASS 2024! We’re delighted to share the pre-con schedule for Monday, November 4, and Tuesday, November 5, 2024. Check out the full pre-con line up and the incredible speakers taking part and secure your spot today. DMO/SMO/Powershell [How To Use PowerShell To Edit the Windows Registry]( From IT Pro - Microsoft Windows Information, Solutions, Tools PowerShell offers extensive capabilities for manag... Data Science [Granularity Is the True Data Advantage]( From Dataversity Commerce today runs on data – guiding product development, improving operational efficiency, and personalizing the customer experience. However, many organizations fall into the trap of thinking that more data... Database Design, Theory and Development [Database technology learning resources]( From Simple Talk Before I started as the editor of Simple Talk, I w... [Data Labeling Challenges and Solutions]( From Dataversity In the rush to adopt AI across diverse sectors, t... [DBA and Developer: Allies or Adversaries?]( From SQLServerCentral Blogs In the expansive landscape of software development... [Start-DbaMigration for SQL Server Migrations]( From Callihan Data Server migrations don’t happen overnight. They t... [Identifying Object Dependencies]( From Andy Broadsword When looking to migrate, consolidate or deprovisio... [What Being a Data-Driven Organization Really Means]( From IT Pro - Microsoft Windows Information, Solutions, Tools Implement these five best practices if you want to become a truly data-driven business. [Mind the Gap: The Data Chasm]( From Dataversity Welcome to the inaugural edition of Mind the Gap, a monthly column exploring practical approaches for improving data understanding and data utilization (and whatever else seems interesting enough to share).... [3rd Party Applications Have Issues]( From DallasDBAs.com As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries... DevOps and Continuous Delivery (CI/CD) [The Redgate Seminar – Brisbane]( From SQLServerCentral Blogs On Thursday, May 2, we have the Redgate Seminar in... [Test Data Management – 2024 is your year to do it]( From SQLServerCentral Blogs This blog post is about Test Data Management – o... [Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger]( From SQLServerCentral Blogs I wrote a post recently about pruning branches in git. That’s part of the job, but the other part is removing local branches. This post looks at one way... The... [Develop and Test Your Rollback Plan]( From SQLServerCentral Blogs he rollback plan... what to do when things go wrong to get back to where you were before the deployment or implementation. I've seen too many cases where a... The... [Flyway’s Baseline Command Explained Simply]( From Product learning – Redgate Software The Baseline command is intended to make it easy to turn any preexisting production database into a Flyway database so that, subsequently, versioned migrations can then be applied to... DocumentDB/Key-Value/Graph/other NoSQL Databases [Updating Documents in MongoDB]( From Simple Talk In the previous articles this series, I demonstrat... MDX/DAX [The Optimizing DAX book is available]( From SQLBI We are proud to announce the availability of our n... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Fabric and Azure SQL in a few clicks: Mirroring a Database]( Finally, mirroring is available for Fabric! You can mirror an Azure SQL to Fabric. It works for CosmoDB and Snowflake as well, but in this article, I will focus on Azure SQL. It is 100%, no, but it is definitely a feature that is really great even now. Before getting into a step-by-step of the process, let’s understand the basics. [Microsoft Fabric / Power BI Q&A w/ Kasper de Jonge (April 27, 2024) (Member Chat 2nd Half)]( From Guy in a Cube Join us live as we answer your questions about Mic... [Azure Elastic Jobs - The NonPlastic, Elastic Fantasic]( From SQL Rod After a lengthy period in Public Preview it seems,... [Microsoft Fabric Training and Tutorials]( From SQLServerCentral Blogs Microsoft Fabric is the new data offering in Micro... [Delta Lake Table Structure Demystified in Microsoft Fabric]( From RADACAD The structure of storing data in OneLake for the L... [Get row counts of all tables in a Microsoft Fabric warehouse]( From SQLServerCentral Blogs I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You get an option to load sample data when you create a new pipeline in... The... [All Fabric Workload Items are now available from the Scanner API]( From FourMoo All Fabric Workload Items are now available from the Scanner API I was working with the customer and was looking for some information in the Scanner API. For a... Oracle/PostgreSQL/MySQL/other RDBMS [New Learning Path: AI Apps with Azure Database for PostgreSQL](  [Marco Slot: Crunchy Bridge for Analytics: Your Data Lake in PostgreSQL]( From Planet Postgres A lot of the world’s data lives in data lakes, h... [Robert Haas: Hacking on PostgreSQL is Really Hard]( From Planet Postgres Hacking on PostgreSQL is really hard. I think a lot of people would agree with this statement, not all for the same reasons. Some might point to the character... [David Z: Bringing IvorySQL to Neon Autoscaling Platform]( From Planet Postgres 1. Overview In this blog post, we will guide you through the process of integrating IvorySQL, an open-source database built on PostgreSQL, into Neon Autoscaling Platform. Throughout this... Performance Tuning SQL Server [Plansplaining part 29 – Introduction to cursor processing]( From SQL Server Fast This is already the 29th part of the plansplaining... PowerPivot/PowerQuery/PowerBI [Power BI Semantic Model Memory Errors, Part 1: Model Size]( From Chris Webb's BI Blog You probably know that semantic models in Power BI... [Pretty Power BI – Adding GIFs]( From Adatis Good UX design is critical in enabling stakeholder... [Quick Guide to Transition Power BI Reports to Power BI Paginated Reports]( From Purple Frog Systems A Quick Start Guide to Transitioning Existing Powe... [Power Apps Connection References to SQL Server]( From Deb the DBA Power Platform is part of the Microsoft universe o... [Use a slicer to filter a visual based upon a measure in Power BI]( From DCAC Have you ever wanted to filter a visual by selecti... [Can’t create a Relationship? Time for a surrogate key in Power BI!]( From Guy in a Cube This looks at a scenario of a hierarchy but the ch... Professional Development [Video: A Primer on Classification]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, I explain so... [SQL at 50: A Lesson in How to Stay Relevant Around Data]( From Dataversity Structured query language (SQL) is now 50 years ol... [Technology For Humanity]( From Simple Talk There was a time, when I was in a team that was designing an important IT system for a multinational bank, the testers arranged for perfectly normal office workers... [How to Manage a Rapidly Growing IT Team]( From IT Pro - Microsoft Windows Information, Solutions, Tools Maintaining IT staff performance and efficiency during rapid growth requires careful planning and structure. Here's how to expand your team without missing a beat. [SQLBits 2024: Learning about people at a technical event]( From Purple Frog Systems It has been a hot minute since I attended a SQLBits conference. It’s a techie event! I’m not technical. Project Managers must surely be classed as ‘persona non-grata’. Last... R Language [R Programming Bug Exposes Orgs to Vast Supply Chain Risk]( From IT Pro - Microsoft Windows Information, Solutions, Tools The CVE-2024-27322 security vulnerability in R's deserialization process gives attackers a way to execute arbitrary code in target environments via specially crafted files. Reporting Services [3 Report Configurations You Need to Review in Reader Mode!]( From Havens Consulting Video by: Reid HavensLearn about three visual/repo... SQL [How to Use Any SQL Database With Rust]( Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t solely based on the “fearless concurrency” mantra but also on its expanding ecosystem that fosters integration with various technologies. A domain Rust proves to be formidable is database interaction, and a pivotal player in this realm is the Diesel ORM. In this article, I will demonstrate how to get up and running with Rust, connecting to SQL databases using the Diesel ORM. Security News and Issues [Kaiser Health System Sent Private Patient Data to Tech Giants]( From IT Pro - Microsoft Windows Information, Solutions, Tools The data shared with other companies may have incl... [World Password Day 2024: Best Practices for Secure Accounts]( From IT Pro - Microsoft Windows Information, Solutions, Tools Strong password habits are important year-round. World Password Day gives us an opportunity to brush up on our skills. [Rare Interviews with Enigma Cryptanalyst Marian Rejewski]( From Schneier on Security The Polish Embassy has posted a series of short interview segments with Marian Rejewski, the first person to crack the Enigma. Details from his biography. Tech News [Inside the quest to map the universe with mysterious bursts of radio energy]( From Technology Review Feed - Tech Review Top Stories When our universe was less than half as old as it ... [The Download: mysterious radio energy from outer space, and banning TikTok]( From Technology Review Feed - Tech Review Top Stories This is today’s edition of The Download, our w... [Three takeaways about the current state of batteries]( 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. Batteries are on my mind this... The Lighter Side [CodeSOD: Article tF7q2]( From Daily WTF When I first saw Nick L's submission, I thought to... [Error'd: Testing 1,2,3,4,5]( From Daily WTF An anonymous friend sent us our frist test in prod for this week. And then there will be more, and more, and more. "This came up in Kaspersky's Blog's RSS.... Virtualization and Containers/Kubernetes [How to Leverage Your VMware Migration to Redesign Your Infrastructure Architecture]( From IT Pro - Microsoft Windows Information, Solutions, Tools If migrating from VMware, consider doing more than a "mere migration." Instead, consider accomplishing your long-term objectives through an infrastructure redesign.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -