| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| Shout Your Successes I was at a customer this week (sorry, can't share who). I spent the day talking about Redgate Monitor and how it can help with query tuning, server management, and estate management. Through the day, the data pros at the company were sharing how they were managing hundreds of servers and several thousand databases. They were good. No, scratch that. They were pretty great. These people had a thorough and deep knowledge of their systems, how they worked, and what was needed to keep the whole thing up and running. Sure, I contributed a little to their knowledge, but they were already great at their jobs. Oddly, and this isn't meant to be a criticism, just an observation, they were just almost apologetic about how good they were. It felt a little weird. Cause let's be clear, if I was doing as good a job as these people were, I'd be standing on my desk crowing about it pretty much non-stop. I think you should too. What we do isn't easy. In fact, it can be pretty darned hard. When you've been in fire fighting mode for a while, just dealt with major outages, or had a few rough deployments, it can feel like your best bet is to hide in a corner and hope no one notices you're there. Instead, stand up. Square your shoulders. Share your accomplishments with the company. Scream about it. Let them know you're busting your behind for the organization. Don't be humble. Brag. There 100% is a time and place for humility, especially in inter-personal conversations. However, when it comes to broad talks to your company, not individuals, shout your success. Let them know what you and your team are accomplishing. They need to hear it. Let's also be honest about it, you could use that bit of ego boost too. Nothing wrong with that, especially when you are in fact doing a good job. Still gotta own your mistakes, but we don't have to be loud about those. Just clear & honest. Thump your chest and shout, "We did good. Our team rocks. Look at our accomplishments!" 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 |
Last year, Redgate announced the launch of their latest in test data management (TDM) technology – Redgate Test Data Manager. This year, they’re proud to have been recommended in Bloor’s 2024 Test Data Management Market Update! This paper highlights the increasing adoption of TDM technology among enterprise organizations and offers insight into the trends and approaches to look out for when looking for a TDM solution. |
AI/Machine Learning/Cognitive Services |
Learn how to use Windows Copilot to write SQL code... |
This story originally appeared in The Algorithm, o... |
OpenAI reportedly sent warnings to developers acro... |
The Microsoft co-founder says data centers will be less energy-intensive in the future as artificial intelligence makes computations more efficient. |
Developments in AI are bringing automation and con... |
This article first appeared in The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, and read articles like this first, sign up here. This week... |
Administration of SQL Server |
I wrote a piece of SQL that had some new T-SQL syn... |
This post is part of our SQL Server security 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... |
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... |
One such tool is the DATETRUNC function, introduce... |
Where I work, we will be migrating data from one s... |
Amazon SQS boosts performance, scaling capabilities, and energy efficiency without impacting existing behavior - a behind-the-scenes look at AWS's continuous improvement journey. |
Trace data from origin to insights with an intuitive visual graph, empowering engineers, analysts, and admins to validate provenance, troubleshoot pipelines, and ensure governance with ease. |
Streamline virtual desktop management: provision non-persistent desktops, configure apps and resources, and automatically scale capacity based on demand, all from a centralized platform. |
Yesterday, I announced a call for applications fo... |
Instead of just sharing the slides from the keynot... |
What topics do you want to see presented at a futu... |
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put together an interesting collection of data over on GitHub. It’s titled DBA Resources, but it... |
Computing in the Cloud (Azure, Google, AWS) |
These key insights from FinOps X 2024 will help guide your FinOps decisions, says Kyle Campos, chief technology & product officer at CloudBolt Software. |
For many organizations, SaaS and commercial off-the-shelf software are at best an 80% solution to the business need. Find out how cloud-native development can help close the gap. |
PowerShell enables dynamic code generation by cons... |
In a recent comment on a my post about combining CSV files using PowerShell, a reader named Oliver asked how duplicate values should be handled when combining multiple CSV... |
Explore these string manipulation techniques, including converting strings to arrays, inserting and removing text, and correctly using single and double quotes, to dynamically construct commands. |
Data Mining / Data Analysis |
“Advanced analytics” has been the new buzzword... |
Social benefits are crucial government services, e... |
Elastic weight consolidation (EWC) is a technique ... |
Customer analytics is becoming imperative for organizations that desire to create and provide personalized and satisfying customer experiences. To understand and anticipate customer needs, preferences and behaviors in a... |
Predictive analytics is a branch of analytics that identifies the likelihood of future outcomes based on historical data. The goal is to provide the best assessment of what will... |
DevOps and Continuous Delivery (CI/CD) |
I recently had an issue in one of my Git repos, an... |
Change is inevitable. It's also challenging. Here'... |
Stress test From Technology Review Feed - Tech Review Top Stories |
Elizabeth Sajdel-Sulkowska was just three months o... |
Business applications are rarely self-contained, o... |
DocumentDB/Key-Value/Graph/other NoSQL Databases |
So far in this series, we’ve looked at different... |
ETL/SSIS/Azure Data Factory/Biml |
I recently ran into an issue when trying to call a... |
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a typical scenario where you retrieve some metadata from a database and then loop over... The... |
In a November 1984 story for Technology Review, Ca... |
I'm impressed by almost everything Microsoft's first Snapdragon X-powered device has to offer. |
When Micron announced plans to build two new fabs in the U.S. in 2022, the company vaguely said both would come online by the decade's end. Then, in 2023,... |
Recent years reflect medical device manufacturers ... |
GenAI's creative and analytical capabilities, integrated with IoT devices' connectivity and data insights, could lead to remarkable advancements. The market could become a mega-value creator, potentially exceeding $4.5 trillion... |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Easily scale up or scale down your Fabric Capacity... |
In today’s data-driven landscape, organizations face the challenge of integrating diverse data sources efficiently. Whether due to mergers and acquisitions (M&A) or the need for advanced insights, a robust... |
Performance Tuning SQL Server |
SQL Server provides a variety of ways to tune XML ... |
There are quite a few different ways that you’re... |
This article examines whether creating SQL indexes... |
Some Notes On Query Tuning With Batch Mode In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about,... |
Learn how to use SQL Server Query Store to identif... |
As a PostgreSQL developer, I am inevitably stumbli... |
An option I was not aware of… pg_dump and �... |
The upcoming CloudNativePG 1.24 introduces a game-changing feature: the ability to declaratively manage PostgreSQL cluster switchover across cloud regions or different Kubernetes clusters. This advancement enables the seamless demotion... |
TL;DR: If you’re a Postgres extension developer interested in understanding what to expect from core API and ABI stability, please review and give feedback on this patch (or pull... |
Cut the number of required PostgreSQL server round-trips by up to 50% using the `AND CHAIN` parameter of the `COMMIT` and `ROLLBACK` statements. |
PowerPivot/PowerQuery/PowerBI |
P-SKUs, A-SKUs, EM-SKUs and now we also have F-SKU... |
Video by: Reid HavensLearn how to combine a series... |
Do you feel the need to be flawless in your work t... |
The philosopher Karl Popper once argued that there... |
The United States has an official web design syste... |
From avoiding unclear meeting invitations to gossiping more, these are some rules of the modern workplace. |
Presently sponsored by: Push Security. Stop identi... |
Gen Z and mid-career jobseekers are enrolling in c... |
The Postal Service approves thousands of requests ... |
Ticketmaster, Santander Bank, and other large firm... |
The extortion group has demanded tens of millions ... |
Unlike traditional security models, zero trust ass... |
This story first appeared in China Report, MIT Tec... |
This move has been coming for a long time. The Bid... |
A group of cryptographers have analyzed the eiDAS 2.0 regulation (electronic identification and trust services) that defines the new EU Digital Identity Wallet. |
Learn strategies and tools to effectively scan and... |
A failure to imagine — and prepare for — threats to outer-space related assets could be a huge mistake at a time when nation-states and private companies are rushing... |
Take these five actionable steps to improve the jo... |
THE VIDEO THE SYNOPSIS In this video, I get past t... |
Today I got in my car to drive to work and realize... |
There are pros and cons to using AI-assisted development tools versus low-code/no-code platforms for creating applications with minimal coding. Here are the key differences between the two techniques. |
.NET Aspire has similar goals to NuGet in that it ... |
Most people’s sweat contains a protein that can ... |
Colonoscopies are a boon for preventing colon canc... |
In a series of painstakingly precise experiments, ... |
Using engineered mini-livers derived from donated ... |
It’s hard not to laugh at NASA’s blooper reel ... |
Applying Quality of Service techniques at the appl... |
Stijn Lemmens has a cleanup job like few others. A... |
The company has removed online steps for switching from a Microsoft account to a local one and has killed off a past trick for choosing a local account in... |
There are differences between Microsoft business and consumer accounts. Here's what those contrasts mean. |
Companies offer high-tech ways to make growers more efficient. |
Alexander sends us this snippet, where we change o... |
Virtualization and Containers/Kubernetes |
Serverless computing has become increasingly popul... |
Serverless computing has become increasingly popular in the field of cloud computing, with more organizations opting for cloud-based architectures. The introduction of serverless technologies has led to server management abstraction, where the focus has shifted towards coding and services rather than hardware and infrastructure. With Knative you can now leverage the benefits of serverless computing, such as scalability, reduced operational overhead, and cost efficiency within your own Kubernetes clusters. | 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. |
|
|