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 FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -