Database Weekly for April 6, 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
 To Each Their Own I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first [Fabric Community Conference](. It was a great event, well attended. BUT... It was in Las Vegas. I am not a fan. First of all, Vegas is just far too noisy for me. I prefer to hear the world as opposed to machines and constantly blasting music. I'm not a show person. I, mostly, don't care for gambling (I do find craps fascinating, but I hate losing money). I feel like Vegas is overpriced too. Food's great though, but it costs a fortune. Overall, Vegas just isn't for me, even though I tend to go there at least once a year, sometimes more. It's the job. On the other hand, I saw a lot of people, even families with kids (spring break week here in the States), having a blast. They love it. Maybe it's the shows. Maybe it is gambling. The games. The bars. Heck, the noise and lights. People love it. And that's OK. Just because I don't care for it doesn't mean I'm going to try to take it away from others. I am firmly against the idea of "wrong fun." Meaning, you can have fun in ways that I approve and enjoy. We really are individuals. I might enjoy sitting at a quiet bar, murmuring crowd in the background, while I sip a wine and read a book. Others would find that incredibly dull. Still others would find the bar distracting them from their reading. More others (I have a limitless supply) would object to the alcohol. All of that is OK, as long as we don't try to force anyone to "right fun" and away from "wrong fun." In short, to each their own. 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 [The Flyway Migrate Command Explained Simply]( The 'Migrate' command automates the process of applying the database schema changes that are defined in migration scripts, while Flyway tracks the version of every copy of the database. This makes it much easier to maintain consistency across different database environments, and so facilitates continuous integration, continuous deployment, and database version control practices. AI/Machine Learning/Cognitive Services [Your Cloud Strategy Is Now Your AI Strategy, Too]( From IT Pro - Microsoft Windows Information, Solutions, Tools Just because it's easy to get going with an AI clo... [Why the Rise of LLMs and GenAI Requires a New Approach to Data Storage]( From Dataversity The new wave of data-hungry machine learning (ML) ... [Copilot or autopilot? Unpopular opinions on copilot]( From Data â Marc Lately itâs copilot before and after in all Micr... [Why Itâs Time to Rethink Generative AI in the Enterprise]( From Dataversity If youâve been keeping an eye on the evolution of generative AI (GenAI) technology recently, youâre likely familiar with its core concepts: how GenAI models function, the art of... Administration of SQL Server [Upgrade SQL Server on your workstation]( Lately, Iâve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source of the problem is usually the web installer/wrapper, which can fail for a variety of reasons that arenât always made clear by the error messages. Today, Iâm going to walk through one way you can approach a workstation upgrade and avoid these web installer issues altogether. Iâll focus on SQL Server 2022, but most of the information applies to any modern major version. Most of the information applies if youâre installing a brand-new instance, too. [When was my SQL Server Database Last Accessed?]( From SQLServerCentral Blogs Your boss walks up to you one morning and says, �... [SQL Server Diagnostic Information Queries for April 2024]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [A SQL script to automatically infer the data types of data that someone just dumped in your DB with no effort]( From T-SQL Tech Do you know the feeling when someone gives you a f... [SQL Server Filtered Index Essentials Guide]( From MSSQL Tips Learn about using filtered indexes for SQL Server ... [Dynamic Partitioning and a Simple Incremental Load]( From Simple Talk Letâs consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode("overwrite").format("delta").partitionBy("Year","Month","Day").save("Tables/" + table_name) Letâs consider we load the data daily, with all the transactions from... [SQL Server]( From MSSQL Tips I am new to SQL Server and I have heard the term u...
Analysis Services / BI on the MS Stack [Using scatterplots to find details in reports]( From Sqlbi This article describes how you can use a scatterpl... Azure SQL [Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access]( From Azure Database Support Blog In certain circumstances, we need to apply product... [Public preview: Azure Backup supports long term retention for backup of Azure Database for MySQLâ Flexible Server]( From Azure Updates Now you can retain backups for up to 10 years by d... [Lesson Learned #482: Identifying Potential Duplicate Statistics]( From Azure Database Support Blog Some time ago, we encountered a support case where... [Whatâs new in SQL Server and Azure SQL: 2024 so far | Data Exposed News Update]( From Azure SQL Read the 2024 recap of all the Azure SQL and SQL S... [Introduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition]( From Azure SQL When updating data in SQL Server, operators run th... Backup and Recovery [World Backup Day: Expert Tips for Securing Critical Data]( From IT Pro - Microsoft Windows Information, Solutions, Tools On World Backup Day, explore our curated collectio... Cloud - AWS [How I use Terraform to deploy my AWS amplify react js project]( From SQLServerCentral Blogs As a Software Engineer, I would like to deploy my ... [AWS Weekly Roundup â AWS Chips Taste Test, generative AI updates, Community Days, and more â April 1, 2024]( From AWS News Blog Today is April Foolâs Day. About 10 years ago, s... [Introducing AWS Deadline Cloud: Set up a cloud-based render farm in minutes]( From AWS News Blog Customers in industries such as architecture, engi... Cloud - Azure [Public Preview: Resiliency Review on Azure Advisor]( From Azure Updates Improve your workloadâs resiliency and optimize ... Community Interests [#TSQL2sday Invitation: Has AI Helped You with Your SQL Server Job?]( From Journey to SQL Authority with Pinal Dave I'm thrilled to be your host for this month's epis... [Off to SQL Saturday Salt Lake City ⦠on Friday]( From SQLServerCentral Blogs Iâm off on Thursday for Salt Lake City and a SQL... [The London Redgate Summit Comes on Apr 17]( From SQLServerCentral Blogs Iâm heading to the UK in a few weeks for the Lon... DMO/SMO/Powershell [PowerShell GUI Examples: How To Add a Slider to Your Scripts]( From IT Pro - Microsoft Windows Information, Solutions, Tools Learn about the practical applications of sliders ... [Powershell Logging - Transcripts, they're GREEEEAT!]( From SQL Rod No breakfast cereals or comic tigers were harmed i... [PowerShell Error Handling: Learn These Key Techniques]( From IT Pro - Microsoft Windows Information, Solutions, Tools Join PowerShell expert Brien Posey as he explains ... Data Mining / Data Analysis [Unlocking the Power of Data with Process MiningÂ]( From Dataversity Data is invaluable to an organization, but it can also represent a major stumbling block if an enterprise hasnât optimized how data is used to support processes that run... Data Privacy, Compliance, and Governance [What is data classification, and why is it important?]( From SQLServerCentral Blogs The benefits of data classification and the featur... DevOps and Continuous Delivery (CI/CD) [DevOps and Data: Lessons Teams Can Learn About Managing Databases]( From Dataversity According to the Bureau of Labor Statistics, the o... [DevOps Performance Metrics Measure Speed, Stability but Overlook Human Element]( From IT Pro - Microsoft Windows Information, Solutions, Tools Organizations need to also acknowledge and support... [Video: Infrastructure as Code in GitHub]( From 36 Chambers â The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we look at h... [Transforming CI/CD Pipelines for AI-Assisted Coding: Strategies and Best Practices]( From IT Pro - Microsoft Windows Information, Solutions, Tools Here's how developers can enhance their CI/CD processes to leverage AI-powered coding tools more effectively. DocumentDB/Key-Value/Graph/other NoSQL Databases [Building MongoDB Aggregations in MongoDB Compass]( From Simple Talk In the previous article in this series, I demonstr... ETL/SSIS/Azure Data Factory/Biml [Managing Failed Pipeline Runs in Azure Data Factory]( From MSSQL Tips In this article, we look at how to set up differen... [Building a framework for orchestration in Azure Data Factory: A series]( From MARTIN'S BLOG Most people will describe a framework as the "buil... [ELT is Not a Typo]( From Callihan Data Chances are that if youâve found your way to this blog, youâre somewhat familiar with ETL (Extract-Transform-Load). If youâve ever been reading a blog post or article and saw... [Gaining Insights from Azure Data Factory Per Pipeline Billing Details]( From MSSQL Tips In this article, learn how to configure per pipeli... Oracle/PostgreSQL/MySQL/other RDBMS [Ross Anderson]( From Schneier on Security Ross Anderson unexpectedly passed away Thursday ni... [Ahsan Hadi: PostgreSQL clustering solutions]( From Planet Postgres Introduction In my previous post A Brief History o... [David Wheeler: Talk: Postgres Yum Extensions]( From Planet Postgres Quit reminder that Devrim Gündüz of EnterpriseDB... [Sai Srirampur: Exploring versions of the Postgres logical replication protocol]( From Planet Postgres Introduction Logical Replication is one of the man... [Laurenz Albe: Syslog logging with journald in PostgreSQL]( From Planet Postgres © Caroline Albe 2024  Logging to sys... [Ãlvaro Hernández: Why Postgres Extensions should be packaged and distributed as OCI images]( From Planet Postgres There is an ongoing and engaging open discussion i... [muhammad ali: Pitfalls of using SELECT *]( From Planet Postgres Understand how SELECT * can be bad for database pe... [muhammad ali: PostgreSQL Roles and Privileges Simplified]( From Planet Postgres Learn to manage roles and privileges in PostgreSQL... Performance Tuning SQL Server [Advanced Query Optimization Techniques in SQL Server â Video Course]( From Journey to SQL Authority with Pinal Dave Facing the challenge of optimizing complex SQL Ser... [Join me In Boston May 10 For A Full Day Of SQL Server Performance Tuning Training]( From Erik Darling Data Spring Training This May, Iâll be presenting my ... [Solving Parameter Sniffing with Multiple Execution Plans]( From Andy Broadsword Dynamic SQL has many uses and one of these can hel... [Why INSERT/EXEC Causes Weird Blocking In SQL Server]( From Erik Darling Data Why INSERT/EXEC Causes Weird Blocking In SQL Server Going Further If this is the kind of SQL Server stuff you love learning about, youâll love my training. Iâm offering... PowerPivot/PowerQuery/PowerBI [Revolutionizing Power BI: Introducing the Ultimate Formula Language]( From SQLBI Exciting news has just landed in the Power BI univ... [Power Query ODBC bug affecting date calculations]( From SQLServerCentral Blogs I was working on an imported Power BI semantic mod... [Wait!?! Itâs the same data source! Whatâs going on???]( From Guy in a Cube Think you are using the same data source in Power ... [Boost DAX Performance in Power BI with Dual Mode]( From Guy in a Cube Don't ignore Dual Mode! If you are leveraging Dire... Professional Development [How Do You Decide What to Learn?]( From SQLServerCentral Blogs There are so many choices and so little time. How ... [Building a Culture of Data]( From Simple Talk One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My career has always revolved around data, but this is... [IT Professionals Prioritizing Work-Life Balance]( From IT Pro - Microsoft Windows Information, Solutions, Tools The 24/7 on-call nature of work for many IT professionals is leading to a shift in priorities in favor of a more sustainable work-life balance, a change accentuated by... Security News and Issues [Feds to Microsoft: Clean Up Your Cloud Security Act Now]( From IT Pro - Microsoft Windows Information, Solutions, Tools A federal review board demanded that the tech giant prioritize its "inadequate" cloud security posture. [Surveillance by the New Microsoft Outlook App]( From Schneier on Security The ProtonMail people are accusing Microsoftâs new Outlook for Windows app of conducting extensive surveillance on its users. It shares data with advertisers, a lot of data: The window informs... [Maybe the Phone System Surveillance Vulnerabilities Will Be Fixed]( From Schneier on Security It seems that the FCC might be fixing the vulnerabilities in SS7 and the Diameter protocol: On March 27 the commission asked telecommunications providers to weigh in and detail what... Software Development [Database Feature Toggles]( In software development the concept of feature toggles are used to selectively turn on and off features. They are, for example, used to restrict some newly introduced features to a select group to see how these features work. While this concept has been long used for user-facing application code, it is also a practice that is useful for database code. T-SQL and Query Languages [Find and Replace Text in Strings in T-SQL]( String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extract detailed information from it. Those of us who have tackled these challenges fully understand how code can quickly go from simple to absurdly complex, one function at a time. This article is focused on how to write, simplify, and get the most out of string data using the least amount of code to do so. Itâs a reminder that code complexity is equivalent to technical debt and that in these scenarios, less is always more. Tech News [The race to fix space-weather forecasting before next big solar storm hits]( From Technology Review Feed - Tech Review Top Stories Tzu-Wei Fang will always remember February 3, 2022... [How to reopen a nuclear power plant]( From Technology Review Feed - Tech Review Top Stories A shut-down nuclear power plant in Michigan could ... [The Download: Harvardâs geoengineering failure, and extending nuclear plantsâ lifetimes]( From Technology Review Feed - Tech Review Top Stories This is todayâs edition of The Download, our weekday newsletter that provides a daily dose of whatâs going on in the world of technology. The hard lessons of Harvardâs failed geoengineering... [How to safely watch and photograph the total solar eclipse]( From Technology Review Feed - Tech Review Top Stories On April 8, the moon will pass directly between Earth and the sun, creating a total solar eclipse across much of the United States, Mexico, and Canada. Although total... Virtualization and Containers/Kubernetes [Comparing Container Orchestration Tools: Kubernetes, Docker Swarm, Apache Mesos]( From IT Pro - Microsoft Windows Information, Solutions, Tools When selecting a container orchestration tool, considerations such as project size, resource constraints, and team expertise should guide the decision. Web [Making Accessibility Part of the Design Process â Part 3]( In this last segment of the series, weâll delve into the crucial elements of navigation and flow, exploring further the part of web accessibility that ensures users can effortlessly navigate online content. Additionally, weâll shine a spotlight on the indispensable practice of regular testing, an ongoing commitment that goes beyond compliance, providing invaluable insights into real user experiences and fostering continuous improvement. flyway [Using environments in Flyway commands]( From Blog â Redgate Software Deploying database code using pipelines in various...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -