A Little Late, But We're Here

Database Weekly for March 11, 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  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: The AI Economy]( From Technology Review Feed - Tech Review Top Stories Recorded on August 10, 2023 The AI Economy Speaker... [AI Startup Anthropic Says New Models Cut Hallucination Risks]( From IT Pro - Microsoft Windows Information, Solutions, Tools The startup says new versions of Claude will be tw... [Could Microsoft's AI Strategy Tank Its Reputation?]( From IT Pro - Microsoft Windows Information, Solutions, Tools Microsoft is making a high-stakes bet on AI. But w... [GenAI to Propel Global Robotics AI Chipset Market to New Heights]( From IT Pro - Microsoft Windows Information, Solutions, Tools Aided by the democratization of generative AI, the... Administration of SQL Server [Mastering Microsoft SQL Server: Analyzing and Optimizing Complex Queries]( From Dataversity In the realm of database management, particularly ... [Archive SQL Server Data using the SQL OUTPUT Clause]( From MSSQL Tips This tip explores a better, more direct, and more ... [SQL Server Diagnostic Information Queries for March 2024]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [Instant File Initialization for the transaction log | SQL Server 2022 Hidden Gems | Data Exposed]( From Azure SQL Next in the SQL Server 2022 hidden gems series you... [Webcast on SQL Server Administration]( From SQLServerCentral Blogs I will be giving another Microsoft SQL Server-base... [bit Obscene Episode 2: SQL Server Agent Jobs]( From Erik Darling Data bit Obscene Episode 2: SQL Server Agent Jobs Going... [Don't Trust the Defaults]( From SQLServerCentral Blogs (2024-Mar-08) Software installation typically inv... Azure SQL [Optimized locking in Azure SQL Database]( Whether or not it’s a cloud offering that makes sense for you, Azure SQL Database is often the staging ground for new features that will eventually make it to all flavors of SQL Server. Earlier this year, Microsoft announced this magical-sounding feature, “optimized locking.” Instead of locking individual rows and pages for the life of the transaction, a single lock is held at the transaction level, and row and lock pages are taken and released as needed. Career, Employment, and Certifications [4 women in tech describe times they made a difference]( From AllAnalytics Making a difference involves taking meaningful act... Cloud - AWS [AWS Weekly Roundup — New models for Amazon Bedrock, CloudFront embedded POPs, and more — March 4, 2024]( From AWS News Blog This has been a busy week – we introduced a new ... [Free data transfer out to internet when moving out of AWS]( From AWS News Blog You told us one of the primary reasons to adopt Am... [Amazon RDS now supports io2 Block Express volumes for mission-critical database workloads]( From AWS News Blog March 7, 2024: Post updated to change GB to GiB. M... [AWS Follows Google Cloud in Ending Cloud Switching Costs]( From IT Pro - Microsoft Windows Information, Solutions, Tools AWS' Sébastien Stormacq said removing data transf... [Get RDS Instance Type RAM in Terraform]( From youdidwhatwithtsql.com For a monitoring project I’m currently working o... Cloud - Azure [SQLpassion Live Training about running SQL Server in Microsoft Azure]( From SQLServerCentral Blogs From April 24 – 25, 2024 I will run a brand-new ... [Reading Azure SQL audit log from Azure Storage using sys.fn_get_audit_file returns empty result]( From Azure Database Support Blog This blog post was created on March 6th, 2024. Whe... Computing in the Cloud (Azure, Google, AWS) [Cloud VMs are Not an Architectural Failure on Your Part]( From DCAC With the demise of the #SQLHelp hashtag (well it s... [The Five Biggest Challenges with Large-Scale Cloud Migrations]( From Dataversity The popularity of cloud computing continues to gro... [Leveraging Cloud Automation to Manage Costs for Highly Unpredictable Workloads]( From IT Pro - Microsoft Windows Information, Solutions, Tools Businesses should adopt measures to automate their... [Can Platform Teams Improve Shared Services?]( From IT Pro - Microsoft Windows Information, Solutions, Tools To revitalize shared services, organizations are s... [Explosion of Data in the Cloud Era Leading to Observability Complexity]( From IT Pro - Microsoft Windows Information, Solutions, Tools There's just too many applications and too much da... DMO/SMO/Powershell [PowerShell Dynamic Parameters and SQL Server]( Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values. Data Science [How to Trust Your Telemetry Data]( From IT Pro - Microsoft Windows Information, Solutions, Tools To effectively address the complexities of telemet... [Using analyzers in RavenDB indexing]( From Ayende @ Rahien We got an interesting question in the RavenDB Disc... Data Warehousing [SQL Down Under show 85 with guest Bob Duffy discussing building data warehouses is now published]( From The Bit Bucket And another new SQL Down Under show is published! ... Database Design, Theory and Development [Understanding the Importance of Data Lineage in Modern Data Management]( The concept of data lineage has been around for many years, but it has become increasingly important in recent years due to the growth of big data and the increasing complexity of data processing systems. In today’s data-driven world, organizations are collecting and storing more data than ever before. This data is important for making informed business decisions, fueling innovation, and enabling organizations to better understand their customers and markets. DevOps and Continuous Delivery (CI/CD) [Video: Get Started with GitHub]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS In this video, we take a lo... [Friday Flyway Tips–Undoing Development Changes]( From SQLServerCentral Blogs I had a customer ask about undoing changes made by... [Redgate Test Data Manager: A Guide for the DevOps Manager]( From Product learning – Redgate Software Redgate Test Data Manager will prepare, manage and... Machine Learning [Supporting Diverse ML Systems at Netflix]( From Netflix TechBlog - Medium David J. Berg, Romain Cledat, Kayla Seeley, Shasha... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Scheduling and Monitoring Fabric Pipeline Executions]( From Curated SQL Andy Leonard shares a tip: The more I work with Mi... [Scheduling and Monitoring a Fabric Data Factory Pipeline Execution]( From AndyLeonard.blog() The more I work with Microsoft Fabric Data Factory... Oracle/PostgreSQL/MySQL/other RDBMS [Deepak Mahto: Why I Love psql – PostgreSQL Terminal.]( From Planet Postgres At PGConf India 2024, I delivered a lightning talk... [Regina Obe: PostgreSQL Mistakes and How To Avoid them]( From Planet Postgres The adoption of PostgreSQL is growing each year. M... [Ryan Booz: PGSQL Phriday #016]( From Planet Postgres Invitation from Ryan Booz Many of the PostgreS... [David Z: Setting up a debugging environment in PostgreSQL to better understand OpenSSL APIs]( From Planet Postgres 1. Overview In my previous blog, I discussed h... [Andrew Atkinson: Rails + Postgres Postgres.FM 086 — Extended blog post edition! ️]( From Planet Postgres I recently joined Michael and Nikolay as a guest o... [Elizabeth Garrett Christensen: Connecting QGIS to Postgres and PostGIS]( From Planet Postgres QGIS, the Quantum Geographic Information System, i... [MySQL INTO OUTFILE vs. INTO DUMPFILE]( From Callihan Data I haven’t had a MySQL post for awhile, so it’s... [Goutham Reddy Banala: Exploring JSONB in PostgreSQL]( From Planet Postgres PostgreSQL is a powerful Open-Source database mana... [Introducing PG Down Under – Focus on PostgreSQL]( From The Bit Bucket Welcome to PG Down Under! I've worked with data mo... [oded valin: Speed up PostgreSQL pgvector queries with indexes]( From Planet Postgres er sideUsing AI, it’s possible to find similar t... [Adrian Klaver: Using Polars & DuckDB with Postgres]( From Planet Postgres This post will look at two relatively new programs... [Henrietta Dombrovskaya: February 20 recording – finally!]( From Planet Postgres Here is [Eager Aggregation in SQL queries]( Aggregation is a widely used way to summarize the content of a database. It is usually expressed with GROUP BY clause or just using aggregate functions (like COUNT or SUM). When the database engine executes a query with aggregations, it produces individual rows need to compute the required output and then performs the aggregation as (almost) last step. We discuss in this article how to re-write a query manually so that the order of operations will be different and when it can be beneficial. Performance Tuning SQL Server [Implicit Conversion to Smaller Data Types?]( From Deb the DBA I’ve been working on a project where I have to d... [How To Tell If Lazy Table Spools Are Slowing Your SQL Server Queries Down, And Fix Them]( From Erik Darling Data How To Tell If Lazy Table Spools Are Slowing Your ... [Comparing Performance of TOP vs. MAX]( From Andy Broadsword Both TOP (1) and MAX can be used to identify t... [SQL Server Index Design: Getting Key Column Order Right]( From Erik Darling Data SQL Server Index Design: Getting Key Column Order ... PowerPivot/PowerQuery/PowerBI [Improve data labels with format strings]( From SQLBI Learn different approaches to format your DAX meas... [TRY_CAST Arithmetic Overflow Error]( From Purple Frog Systems TRY_CAST() Arithmetic Overflow Error – How? It i... [Getting started with Visual Calcs in Power BI]( From Guy in a Cube It's been a long time coming but Visual Calculatio... Professional Development [The Redgate Summit in Atlanta]( From SQLServerCentral Blogs Navigating the Database Landscape is the headline ... [Book Review: My Effin Life]( From SQLServerCentral Blogs This is very off topic, but I’ve been a fan of R... [We need to talk about the elephant in the room – the future of DBAs]( From Eitan Blumin Hey there, pull up a chair, and let’s have a rea... [Celebrating Strong Women]( From AllAnalytics When I first starting writing this blog, I thought... [Women in IT Face Challenges, but Mentors for AI Adoption Emerge]( From IT Pro - Microsoft Windows Information, Solutions, Tools Disparities for women in tech for persist, despite... Security News and Issues [The Download: the mystery of LLMs, and the EU’s Big Tech crackdown]( From Technology Review Feed - Tech Review Top Stories This is today’s edition of The Download, our w... [The Insecurity of Video Doorbells]( From Schneier on Security Consumer Reports has analyzed a bunch of popular I... [White House Calls for Adoption of Memory-Safe Programming Languages to Prevent Cyber-Attacks]( From IT Pro - Microsoft Windows Information, Solutions, Tools It’s time for software developers to reconsider ... [Welcoming the German Government to Have I Been Pwned]( From Troy Hunt's Blog Back in 2018, we started making Have I Been Pwned ... T-SQL and Query Languages [SQL String Functions - TRIM, LTRIM, RTRIM, REPLACE, STUFF, CHARINDEX and TRANSLATE]( From MSSQL Tips In this article, we look at how to manipulate stri... [Two-Dimensional Interval Packing Challenge]( I’ve dealt with many interval packing tasks in the past and used different techniques to handle those. But they all had something in common that kept the complexity level at bay—they were all what you can think of as one-dimensional interval packing tasks. During a T-SQL class, while discussing packing challenges, Paul Wilcox from Johns Hopkins inquired whether I dealt with two-dimensional packing tasks, and if I had any references to resources for addressing those. In this article I present Paul’s two-dimensional packing challenge and my solution. Tech News [The 2024 Technology Spending Rebound]( From IT Pro - Microsoft Windows Information, Solutions, Tools Infrastructure software providers are poised to le...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -