| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
|
| Life Moves Pretty Fast Driving my soon-to-be granddaughter to school today (my son is getting married and will adopt the young lady), we saw a dead armadillo, a turtle in the road (rescued it) and an escaped cow (left it alone). THEN... old soon-to-be granddad had forgotten lunch, so had to deliver that back at the school (cow must have gone back into its field). But only after I caught my son's dog which had slipped his collar while I was walking him. Oh, AND, I've still got work to do, including writing this editorial. Anyway, how's your day going? I may not have mentioned this previously, but I work for Redgate Software. I love the job. A lot. However, let me tell you about one of our products, Redgate Monitor. It started life as a monitoring tool for SQL Server. Now it also supports PostgreSQL. Oh, and we have limited Oracle and MySQL support as well with much more to come. All the cloud platforms are in there. In fact, there are eight (8) teams of developers working on the product right now. This means, almost every time I demo the product, I get to say the phrase, "Oh, that's new." Keeping up is frequently just an act of discovery. There is a lot going on in the world, in technology, in our lives. Keeping up with it, well, ain't always easy. But, keep up we must. However, don't forget the Ferris Bueller quote: Live moves pretty fast. If you don't stop and look around once in a while, you may miss it. Grant Fritchey 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. |
| Vendors/3rd Party Products |
| Getting realistic test data from large production databases can be a challenge, especially when you're trying to keep dev environments lightweight and secure. Redgate Test Data Manager includes a subsetting CLI that simplifies this by letting you generate smaller, fully representative subsets automatically. This article will walk you through getting started: from setup and configuration to running and refining simple subset operations. |
| Oracle maintains its top-ranking spot; persistent growth trends from PostgreSQL and Snowflake highlight Q1 2025 DB-Engines rankings analysis. |
| AI/Machine Learning/Cognitive Services |
| Does saying 'please' and 'thank you' to ChatGPT re... |
| Two recent developments in AI and astrophysics mig... |
| The financial industry is evolving at an unprecede... |
| OpenAI’s March update responded to user preferen... |
| As someone deeply involved in the world of data sc... |
| A contractor used AI to create 23 out of the 171 s... |
| What insurance companies need to know about the Fundamental Rights Impact Assessment (FRIA) The EU Artificial Intelligence Act (EU AI Act) is ushering in a new era of accountability... |
| AI agents are no longer confined to labs and prototypes. They’re shaping how we live, work and make decisions. From customer service bots and self-driving cars to robotic surgical... |
| Administration of SQL Server |
| Business insights are only as good as the accuracy... |
| Indexes 101: What, Why, and When? “What Is an In... |
| Analysis Services / BI on the MS Stack |
| SAS programmers love to brag that the SAS will sti... |
| Reading Time: 5 minutesIn this post I want to co... |
| Azure SQL Managed Instance |
| I do believe most people know about the ability to... |
| Last week, we had the AWS Summit Amsterdam, one of... |
| AWS introduces new EC2 instance families (C8gd, M8... |
| Developers can connect Lambda functions, DynamoDB tables, and other resources to create sophisticated real-time applications with features like data transformation, persistent storage, and validation. |
| AWS is adding a new Availability Zone in Maryland to the US East (Northern Virginia) Region by 2026, enhancing redundancy and supporting growing AI workloads while maintaining high-bandwidth, low-latency... |
| On the weekend of April 5, 2025, I attended (and R... |
| After an amazing Redgate Summit in London earlier ... |
| If you’re looking to master SQL Server, Power BI... |
| Computing in the Cloud (Azure, Google, AWS) |
| Organizations are deepening their cloud investment... |
| In this blog post, we will audit the dbatools comm... |
| As AI continues to evolve, many of us are looking ... |
| Data Mining / Data Analysis |
| Data used to be a physical thing, stored on paper ... |
| Your website can’t grow without data. Learn how to connect WordPress and Google Analytics to improve your website performance. |
| DevOps and Continuous Delivery (CI/CD) |
| This article will discuss testing and introduce the concept of Test Operations (testOps). By the end of this article, you should see testing in a broader picture and see cases where testOps come in. You’ll also know a variety of the tools you can use to implement testOps in your development workflow. |
| In the first article of this series, you learned h... |
| Explore the differences between MLOps and DevOps �... |
| Getting realistic test data from large production ... |
| Once the domain of developers, Git is fast becoming essential for IT operations, offering powerful benefits for managing infrastructure, automation, and documentation in a DevOps-driven world. |
| I recently upgraded to a powerful developer-class ... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
| I would like to start off because I am by no means... |
| With the popular data transformation tool dbt (dat... |
| Oracle/PostgreSQL/MySQL/other RDBMS |
| A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents. String data types allow you to do just that and store and represent text. They handle everything from simple names and addresses to complex data. |
| After the initial overview of memory monitoring in... |
| Performance Tuning SQL Server |
| Yeah, yeah, second AI post in a row. I promise not... |
| All About SQL Server Stored Procedures: Temporary ... |
| If you ever wondered why a query that looks harmle... |
| Introducing sp_IndexCleanup! Going Further If this... |
| I was chatting with a customer recently and they w... |
| I wrote an article about PostgreSQL 18. It is in... |
| © Laurenz Albe 2025 Saving storage space shou... |
| Today, I would like to discuss additional techniqu... |
| Working on TRAKTOR again. The good news is, it sti... |
| When disaster strikes, whether a natural disaster ... |
| A small follow up on my previous post on various Postgres scale-up avenues in my preferred order. The post received quite a bit of interest - meaning people at... |
| Learn how to create a log rotation policy for postgresql logs based on size The post LogRotate Policy For PostgreSQL appeared first on Performance Tuning And Infra Automation. |
| pg_cron is a simple cron-based job scheduler for P... |
| Check TRAKTOR 2 - less complicated, more stable, cloud ready! Compatible with PostgreSQL 16 and 17. |
| PowerPivot/PowerQuery/PowerBI |
| The series of blog posts I wrote last year on sema... |
| This article describes how to implement a dynamic ... |
| Implement a dynamic Pareto calculation in Power BI... |
| Although it’s a rewarding career, the job of chi... |
| When the prison doors first closed behind him more... |
| Even the most dedicated IT team is vulnerable to b... |
| As workforce reductions sweep through federal agencies and beyond, technology leaders face the difficult task of preserving capabilities and trust while making irreversible decisions. |
| As AI reshapes the tech landscape, a growing gap b... |
| Improve WordPress performance with practical tips to test your site speed, optimize loading times, and deliver a faster experience for your visitors. |
| Android phones will soon reboot themselves after s... |
| Introduction A contained user can create a Windows... |
| T-SQL and Query Languages |
| This installment of our three-part series on SQL c... |
| I preface a lot of what I write with whether or no... |
| In the final part of this series, learn how to use... |
| I heard someone say recently that you can’t chan... |
| Time to read: ~ 2 minutes Words: 417 Postgres Blogs We’re getting more and more Postgres instances at work. To get up to speed on Postgres, I’ve started to... |
| Domain vs hosting: they’re not the same. Learn t... |
| One costly and time-consuming step in constructing... |
| In 2018 astronomers at MIT and elsewhere observed ... |
| Scientists have known for decades that certain neu... |
| Tiny flying robots could perform such useful tasks... |
| Ariel Aberg-Riger is the author of America Redux: ... |
| Something appears to be broken in how NASA procures launch services. |
| When Steve's employer went hunting for a new custo... |
| Using 47 seasons of Survivor data, this analysis explores what gameplay traits correlate with winning, applying Python and SAS Viya Workbench to build predictive models. While stats like challenge... |
| Virtualization and Containers/Kubernetes |
| Strengthening Deployments and Runtime Protection I... |
| The first Kubernetes release of 2025 introduces 64 enhancements — including sidecar containers, user namespaces, and advanced AI workload support — marking a new era of cloud-native "magic." |
| An ancient Chinese army set fire to an enemy capital, but things got out of hand. |
| 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. |
|
|
