Baseball Everywhere (DBW 2024-06-15)

Database Weekly for June 15, 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  Baseball Everywhere Last week was supposed to be my turn to curate Database Weekly and write an editorial to go along with it. Graciously, Mr. Louis Davidson (@drsql) offered to switch weeks while I was in Cambridge, England with most of the Redgate Marketing team for our yearly global gathering at HQ. As a remote worker on the other side of the pond, these opportunities for in-person collaboration are gamechangers. The week was awesome and some of my learnings might be worth another editorial in the future. But what I really want to talk about is… baseball! It just so happened that my return flight was supposed to be Saturday, June 8. But about two months ago, as I was watching a Yankees game one night, an advertisement for the London Series between the Philadephia Phillies and the New York Mets caught my attention. The first game was on Saturday evening and all I had to do was delay my flight until Sunday, which ended up saving about $300. (bonus!) As the keen eyed among you noticed, I’m a Yankees fan first, not a Phillies or a Mets fan. So why would I stay an extra day in England, chilly “summer” temperatures and all, to watch a baseball game that I could easily attend in the states? Because I’m a baseball fan and this was a rare opportunity to experience something unique around the sport I enjoy. And it did not disappoint! From an event perspective, MLB and their collaborators did an excellent job making the day, stadium, and event top notch. The field, transformed from a soccer pitch to a baseball field in a few days, was picturesque. Seriously, they really knocked this one out of the ballpark. The real joy, however, came with the community and camaraderie. I was fortunate to attend with two of my American co-workers, and we know a few others from the team were somewhere in the stadium as well. The Brits around us were just as excited to enjoy the American pastime, asking questions and celebrating the big plays. It was a rare opportunity to feel like we were able to share something with a stadium of people that may never see this beloved game again. It was an experience I felt fortunate to enjoy this year. You might not be a baseball fan. Heck, you might have never seen a game before. That’s totally fine. But there’s certainly something you enjoy outside of your day-to-day work that others can enjoy with you, learn from you, and celebrate with you. Don’t be afraid to do just that. Even if they say “rubbish” and spell the word “color” wrong. Ryan Booz [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 [Microsoft Beefs up Security of Windows AI Tool After Outcry]( From IT Pro - Microsoft Windows Information, Solutions, Tools Cybersecurity experts said Recall feature could be... [LLMs Acting Deceptively]( From Schneier on Security New research: “Deception abilities emerged in large language models“: Abstract: Large language models (LLMs) are currently at the forefront of intertwining AI systems with human communication and everyday life. Thus,... [Talkie - a simple, private, responsive interface for LLMs]( From SQLServerCentral Blogs Watch this video on YouTube I like using ChatGPT. ... Administration of SQL Server [Stop Long-Running SQL Agent Jobs]( From Curated SQL Lori Brown puts a halt to things: I have always done this by having a monitoring job that executes on a schedule that runs at… [Why Some Indexes Create Slower Than Others In SQL Server]( From Erik Darling Data Why Some Indexes Create Slower Than Others In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... [4 Reasons Why the Owner of SQL Server Agent Jobs Should Not Be User Logins]( From StraightPath Solutions SQL Blog This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the... [The Database Owner Role in SQL Server: A Call for Least Privilege]( From StraightPath Solutions SQL Blog This post is part of our SQL Server security blog ... [A Little About Fill Factor And Fragmentation In SQL Server]( From Erik Darling Data A Little About Fill Factor And Fragmentation In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... Community Interests [Jimmy Angelakos: POSETTE 2024 — How to Work with Other People]( From Planet Postgres POSETTE 2024 is an online event for PostgreSQL (formerly known as Citus Con, kindly sponsored by Microsoft) which took place on June 11-13, 2024. It was wonderfully organised, and... DMO/SMO/Powershell [Exporting SQL Server Query Results to an HTML Table]( From Curated SQL Vlad Drumea builds a table: In a previous post, I�... Database Design, Theory and Development [Concepts and Issues in Test Data Generation]( Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you need plenty of data of exactly the right type, size and verisimilitude in order to develop and test a database. It has got to look right. There exist several Data Generation tools that are used to provide development data, but you need to be sure of your requirements before selecting a particular tool. DevOps and Continuous Delivery (CI/CD) [How Platform Engineering Can Help Enterprises Comply with EU AI Act]( From IT Pro - Microsoft Windows Information, Solutions, Tools Effective platform engineering integrates end-to-e... DocumentDB/Key-Value/Graph/other NoSQL Databases [Deleting Documents from a MongoDB Collection]( So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a MongoDB collection. This article continues that discussion by explaining how to use MongoDB Shell to delete documents from a collection. Once you know how to delete documents, you’ll have the foundation you’ll need to perform the basic create, read, update, and delete (CRUD) operations in MongoDB, assuming you’ve been following along in this series. From this foundation, you can start moving on to more advance CRUD operations. ETL/SSIS/Azure Data Factory/Biml [Saving Sensitive Parameters in SSIS Configurations]( From Curated SQL Andy Brownsword doesn’t just leave passwords in plaintext: Configuring SSIS projects or packages can necessitate parametering information which may include sensitive values such as authentication… Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines]( From SQLServerCentral Blogs When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in Fabric, not to be confused with deployment pipelines), you will most likely have some activities... The... [Get started with the On-Premises Data Gateway in Microsoft Fabric]( From Guy in a Cube Trying to leverage on-premises data? Can't connect... [System Views and Distributed Processing in Microsoft Fabric]( From Curated SQL Koen Verbeeck runs into an annoying error: I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate SQL statements that load data from… [Choosing Between the Lakehouse and Warehouse in Microsoft Fabric]( From Simple Talk Microsoft Fabric is a new centralized, AI-powered ... Microsoft News [Microsoft Pulls Back Wide Release of Criticized Windows AI Tool]( From IT Pro - Microsoft Windows Information, Solutions, Tools Recall was intended to create a record of all activities on a PC to help users manage tasks like sorting emails and searching files, but it faced immediate criticism... Oracle/PostgreSQL/MySQL/other RDBMS [Gabriele Bartolini: CloudNativePG Recipe 8: Participating in PostgreSQL 17 Testing Program in Kubernetes]( From Planet Postgres Join the PostgreSQL 17 testing program using Kuber... [Deepak Mahto: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 2 – Null’s Constraint and Performance.]( From Planet Postgres PostgreSQL 17 Beta was released on May 23, 2024, introducing a host of exciting new features anticipated to be part of the official PostgreSQL 17 release. In this blog... PowerPivot/PowerQuery/PowerBI [Dynamically Display Top N and Bottom N Records in One Power BI Chart]( From MSSQL Tips This article will demonstrate the step-by-step process to dynamically display the Top N and the Bottom N records in the same Power BI chart. [Different Approach to a Auto-Scaling Date Axis in Power BI]( From Havens Consulting Video by: Reid HavensLearn about an updated technique I applied after getting inspiration from another YouTube video showing this original technique. This approach achieves the result of a dynamic... Python [Combining Flink SQL, Streamlit, and Kafka]( From Curated SQL Lucia Cerchie has a pair of posts. First up, Lucia sets the stage: n part 1 of this series, we’ll make an app, hosted on Streamlit,… Software Development [API Monitoring- Key Metrics and Best Practices]( From Simple Talk Have you ever wondered how your favorite apps seem to do everything automatically, communicate with each other so smoothly, and update content in real time? Application programming interfaces, or... T-SQL and Query Languages [Fun with Query Timeouts]( From Curated SQL Forrest McDaniel gets my most coveted category: I love how there are lots of little things to SQL Server – mostly ignored details that only… [Concepts and Issues in Test Data Generation]( From Simple Talk Data generation is the science and art of providin... Virtualization and Containers/Kubernetes [Docker Logging Guide Part 1: Basic Concepts and Importance]( Docker has gained popularity as a containerization platform that allows you to develop, deploy, and execute applications faster. It packages applications and their dependencies into standardized entities known as containers. These containers are lightweight, portable, and capable of operating independently. Containers allow developers to build, deploy, and manage applications in different working environments. In addition, containers can be used for both development and production. Docker logging is an essential process in managing containers within a production setting. Web [API Monitoring- Key Metrics and Best Practices]( Have you ever wondered how your favorite apps seem to do everything automatically, communicate with each other so smoothly, and update content in real time? Application programming interfaces, or APIs, are little but mighty messengers that are the secret to this networked world. In the world of technology, where digital interactions are the norm, Application Programming Interfaces, or APIs, make it possible for disparate software systems to communicate with each other smoothly. By serving as a bridge, an API enables communication, data sharing, and the execution of capabilities between other applications.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -