| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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 |
Cybersecurity experts said Recall feature could be... |
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,... |
Watch this video on YouTube I like using ChatGPT. ... |
Administration of SQL Server |
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 Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... |
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... |
This post is part of our SQL Server security blog ... |
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... |
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... |
Vlad Drumea builds a table: In a previous post, I�... |
Database Design, Theory and Development |
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) |
Effective platform engineering integrates end-to-e... |
DocumentDB/Key-Value/Graph/other NoSQL Databases |
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 |
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) |
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... |
Trying to leverage on-premises data? Can't connect... |
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… |
Microsoft Fabric is a new centralized, AI-powered ... |
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 |
Join the PostgreSQL 17 testing program using Kuber... |
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 |
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. |
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... |
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,… |
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 |
Forrest McDaniel gets my most coveted category: I love how there are lots of little things to SQL Server – mostly ignored details that only… |
Data generation is the science and art of providin... |
Virtualization and Containers/Kubernetes |
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. |
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. | 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. |
|
|