| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
Give it Away Tech conference season is in full swing, and it’s only the middle of March. Between Grant, Steve, and I, we’ve attended or presented at about 10 events so far. And within my community of developers and database folks, I’ve seen pictures and posts of many more. As I’ve said a few times in previous editorials, it’s the community that makes it worth all the prep, travel, and time. The majority of what I do is with the PostgreSQL community. This past week, there was a two-day track at open-source conference Scale 21x in Pasadena, California. About two dozen volunteers presented sessions while another handful of volunteers worked the booth in the exhibit hall talking to hundreds of attendees. Among both groups were people fairly new to PostgreSQL and contributors that have been with the project for more than 20 years. I’m thankful that I have these opportunities to see such a diverse group of people working together in support of the larger community. But this time I was struck by one other thing. From new contributors to the veterans, many people were freely giving something away to those around them. Sometimes it was part of a talk and other times it was in the hallway track. Just a few examples that I witnessed included: a veteran of 15+ years telling a presenter with significantly less experience that they learned something new from the talk another veteran with 20+ years working with PostgreSQL sitting down with a few people to share the new logging and tracing work they’ve developed at their company and how others could get started themselves groups of people in the hallway track meeting new friends and inviting others into their conversations I know there were many of these encounters, each requiring someone to give away their time and knowledge freely. I was reminded, yet again, that the old saying is true - “A rising tide lifts all boats.” So once again I’d like to encourage you to give something away this week. Your time, experience, and knowledge will help raise those around you. You won’t regret it. Cheers! Ryan |
| 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 latest State of Database Landscape survey has revealed interesting database platforms insights from over 3800 data professionals: - 79% of businesses now utilize multiple database platforms - Databases attracting new users are on the rise - There has been a shift towards incorporating semi-structured and unstructured data into databases How does this compare in your organization? And what do these trends mean for skills and complexity within your business? |
| How do we capture static data in our Flyway projects, and then track and deploy any changes to it, while also ensuring that our automated deployment process doesn't try to deploy static data to databases where it already exists, such as the production database? For new Flyway projects, it's quite straightforward, but for existing projects there may be complications, depending on your database development and deployment strategy. |
| Redgate Test Data Manager will prepare, manage and deliver the test data required to support the full range of development and test activities for any database project. It allows for extensive and automated testing that leads to reliable, online deployment of database changes. |
| AI/Machine Learning/Cognitive Services |
| I focus most of my blog posts on the data platform... |
| I’ve had a ham radio license since the late 1960... |
| The European Union is enacting the most comprehensive guardrails on the fast-developing world of artificial intelligence after the bloc’s parliament passed the AI Act on Wednesday. |
| Recorded on August 10, 2023 The AI Economy Speaker... |
| The startup says new versions of Claude will be tw... |
| Microsoft is making a high-stakes bet on AI. But w... |
| Aided by the democratization of generative AI, the... |
| Administration of SQL Server |
| If you haven’t migrated your workloads to a mana... |
| In the realm of database management, particularly ... |
| This tip explores a better, more direct, and more ... |
| Introduction These are my SQL Server Diagnostic In... |
| Next in the SQL Server 2022 hidden gems series you... |
| I will be giving another Microsoft SQL Server-base... |
| bit Obscene Episode 2: SQL Server Agent Jobs Going... |
| (2024-Mar-08) Software installation typically inv... |
| Career, Employment, and Certifications |
| Making a difference involves taking meaningful act... |
| This has been a busy week – we introduced a new ... |
| You told us one of the primary reasons to adopt Am... |
| March 7, 2024: Post updated to change GB to GiB. M... |
| AWS' Sébastien Stormacq said removing data transf... |
| For a monitoring project I’m currently working on I need to get the amount of RAM an RDS Instance has. Unfortunately the aws_db_instance resource doesn’t expose this type of... |
| From April 24 – 25, 2024 I will run a brand-new ... |
| This blog post was created on March 6th, 2024. Whe... |
| Computing in the Cloud (Azure, Google, AWS) |
| With the demise of the #SQLHelp hashtag (well it s... |
| The popularity of cloud computing continues to gro... |
| Businesses should adopt measures to automate their... |
| To revitalize shared services, organizations are s... |
| There's just too many applications and too much da... |
| Jess Pomfret continues a series on replication in dbatools: This post is focusing on how to setup replication with dbatools. We support all three flavours… |
| To effectively address the complexities of telemet... |
| We got an interesting question in the RavenDB Disc... |
| Getting your audience’s attention and focusing it well are critical components of building a successful data communication. While there are several ways to capture attention, the two techniques we... |
| And another new SQL Down Under show is published! ... |
| DevOps and Continuous Delivery (CI/CD) |
| THE VIDEO THE SYNOPSIS In this video, we take a lo... |
| I had a customer ask about undoing changes made by... |
| Redgate Test Data Manager will prepare, manage and... |
| DocumentDB/Key-Value/Graph/other NoSQL Databases |
| MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with MongoDB will not be related to storing data but rather to querying data. The better you understand how to retrieve the data you need, the more effectively you can interact with MongoDB and support your data-driven applications. |
| ETL/SSIS/Azure Data Factory/Biml |
| In this article, we look at how you might go about... |
| I have always spent time learning relational databases on my own, non-work time. As the years have passed, I have spent less of my own free time on technical learning and writing for many reasons, but still, I spend plenty of my own time learning about the database technology that Codd started. |
| David J. Berg, Romain Cledat, Kayla Seeley, Shasha... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| Andy Leonard shares a tip: The more I work with Mi... |
| The more I work with Microsoft Fabric Data Factory... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| Flashpoint: have you ever watched a Sci-Fi movie w... |
| In our data hungry world, knowing how to effective... |
| After the pgconfeu23 in Prague – which has been ... |
| There’s a pretty HOT performance trick in Postgres that doesn’t get a ton of attention. There’s a way for Postgres to only update the heap (the table), avoiding having... |
| At PGConf India 2024, I delivered a lightning talk... |
| The adoption of PostgreSQL is growing each year. M... |
| Invitation from Ryan Booz Many of the PostgreS... |
| 1. Overview In my previous blog, I discussed h... |
| I recently joined Michael and Nikolay as a guest o... |
| QGIS, the Quantum Geographic Information System, i... |
| I haven’t had a MySQL post for awhile, so it’s... |
| PostgreSQL is a powerful Open-Source database mana... |
| Welcome to PG Down Under! I've worked with data mo... |
| er sideUsing AI, it’s possible to find similar t... |
| This post will look at two relatively new programs... |
| Performance Tuning SQL Server |
| I’ve been working on a project where I have to d... |
| How To Tell If Lazy Table Spools Are Slowing Your ... |
| Both TOP (1) and MAX can be used to identify t... |
| SQL Server Index Design: Getting Key Column Order ... |
| PowerPivot/PowerQuery/PowerBI |
| Reitse Eskens pushes the envelope: In my previous blog on Fabric and loadtesting, I ended with not really knowing how PowerBI would respond to all… |
| Introduction to the VISUAL SHAPE clause, which def... |
| Learn different approaches to format your DAX meas... |
| TRY_CAST() Arithmetic Overflow Error – How? It i... |
| It's been a long time coming but Visual Calculatio... |
| Navigating the Database Landscape is the headline ... |
| This is very off topic, but I’ve been a fan of R... |
| Hey there, pull up a chair, and let’s have a rea... |
| When I first starting writing this blog, I thought... |
| Disparities for women in tech for persist, despite... |
| This is today’s edition of The Download, our w... |
| Consumer Reports has analyzed a bunch of popular I... |
| It’s time for software developers to reconsider ... |
| Back in 2018, we started making Have I Been Pwned ... |
| Software optimization refers to the process of improving the performance, efficiency, and resource utilization of a software application. It involves making changes to the code, algorithms, or system configurations to enhance the speed, responsiveness, and overall effectiveness of the software. |
| I have a new video: In this video, we take a look at what GitHub has for project management, reviewing GitHub Projects and Issues. The… |
| T-SQL and Query Languages |
| In the last post we looked at how TOP and MAX�... |
| Flash Boy I think subqueries in select lists are v... |
| Situations I end up converting a lot of derived joins, particularly those that use windowing functions, to use the apply syntax. Sometimes good indexes are in place to support... |
| In this article, we look at how to manipulate stri... |
| A handful of studies have concluded that making mi... |
| One company aims to take advantage of a decade-old U.S. law in order to mine Helium-3 – a substance that can help power quantum computing – on the moon. |
| Infrastructure software providers are poised to le... |
| Virtualization and Containers/Kubernetes |
| Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes... |
| How do we capture static data in our Flyway projects, and then track and deploy any changes to it, while also ensuring that our automated deployment process doesn't try... |
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. 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. |
|
|
