| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| The Long Weekend In the US, this is the Independence Day weekend. I had a few spare vacation days, so I tacked one on, making this a four day weekend. My plans are simple. Prep for my family coming over on the 5th for a celebration of the 4th (Ha!). Work on my query tuning book (gotta make progress every day, or these things come and get you). Probably play a little radio. Get work done around the house. Play some more radio. Do other work around the house. And yet, I live by the military maxim, no plan survives contact with the enemy. The enemy in my case is sloth. Oh, I'll have the best intentions over the next few days. Yeah, I should fire up FT8 and try to make that contact with Alaska (I'm so close to Worked All 50 States on FT8). But, hey, look, the hammock is empty. I've worked on the book, 'cause, sloth or not, I want to get that done. Maybe I'll start a project... maybe. Look, I know some of you have a bottomless well of ambition and drive. However, others of us simply do not. We're going to try. Yes, it's probably not enough. Maybe though, that's all you can ask of us. We're trying. Hope your plans survive better than mine are likely to. 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. |
AI/Machine Learning/Cognitive Services |
AI is deemed to be the new superpower. Adoption of... |
Under Creative Commons, a CC signal can indicate t... |
Think of data engineering as plumbing for the digi... |
Artificial intelligence isn’t just changing the world — it’s soaking squirrels, too. Washington Post journalist Jeremy B. Merrill created an AI-powered contraption called the Squirrel Soaker 9000. The DIY... |
A supposed band called The Velvet Sundown has released two albums of AI slop this month. |
These AI tools are hidden gems. You might be surprised that one of the AI tools is from Google – and, no, it isn’t Gemini. The post 5 Most Useful... |
Peter sat alone in his bedroom as the first waves of euphoria coursed through his body like an electrical current. He was in darkness, save for the soft blue... |
The internet infrastructure company Cloudflare announced today that it will now default to blocking AI bots from visiting websites it hosts. Cloudflare will also give clients the ability to... |
Administration of SQL Server |
Reading Time: 3 minutesIn this post I want to sh... |
Error/Fix: Cannot Insert Duplicate Key for UPSERT ... |
I’m really excited to share some new functionali... |
The more I look to GenAI to save me minutes, short periods of time, the better it works. Here’s an example of something I do regularly where AI helps.... The... |
A while ago I was looking into some odd errors that were cropping up in an application, when I spotted that all the columns in a table were defined... |
Download StackOverflow2013 database for PostgreSQL & SQLServer to compare performance. We can figure out which if faster between PostgreSQL & SQLServer. The post Get StackOverflow2013 Database for PostgreSQL & SQLServer... |
Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.… The post Columnstore Index Improvements in SQL Server 2025 appeared... |
(2025-June-30) Working with different abbreviations or acronyms can speed up communication, but at the same time, it can exclude those who are not familiar with them. Sometimes this exclusion happens... The... |
Calling an API has been in Azure SQL since 2022, but it was only recently added to SQL Server 2025 Preview. This new feature... |
In many SQL Server environments, DBAs configure SQL Agent jobs with retry attempts (which is a smart move to handle… Read More »Hidden Risks in SQL Agent Job Logging: How... |
Career, Employment, and Certifications |
Welcome aboard! You might notice, your predecessor... |
Another of our values is this: Motivation isn’t ... |
The 2025 State of ITAM report reveals some major struggles for IT teams and provides suggestions on how to overcome them. |
Follow this step-by-step guide to create a portfolio of your coding projects that demonstrates your skills and helps you stand out in a competitive job market. |
CIOs are no longer the gatekeepers of tech. The gate itself has collapsed. Here's what you can do now. |
Is your company hiring for a database position as of July 2025? Do you wanna work with the kinds of people who read this blog? Let’s make a love... |
Amazon EC2 announces general availability of C8gn network optimized instances powered by AWS Graviton4 processors, offering up to 600Gbps network bandwidth for demanding network-intensive workloads with 30% higher compute... |
Every time I visit Seattle, the first thing that greets me at the airport is Mount Rainier. Did you know that the most innovative project at Amazon Web Services... |
Amazon DynamoDB now offers multi-Region strong consistency capability for global tables, providing the highest level of application resilience and enabling your applications to be always available. |
Today is my last day of work for six weeks. I star... |
Conferences, Classes, Events, and Webinars |
I will be back in Seattle this year attending the ... |
Hello Hello, We. Are. Back! The schedule for EightKB 2025 Edition has been announced! We’re kicking off at 1pm UTC on August 21st…here’s the schedule: – N.B. – If... |
As an AI engineer immersed in the ever-evolving world of data and machine learning, conferences offer more than just networking opportunities; they’re essential refuelling stations for inspiration, learning and... |
Data Mining / Data Analysis |
The final part of this three-part series on buildi... |
In my experiences building end-to-end analytics solutions, I often need to connect to a variety of different systems to bring data in. Most of the time, this process is... |
Data Storytelling and Visualisation |
Video by: Reid HavensTake your Power BI visuals to the next level by applying dynamic positive/negative color formatting to your first-to-last comparison line! This tutorial expands on the previous... |
In our last few posts, we’ve looked at how to: Today, we’re diving into a different, but equally powerful question: When are my Snowflake warehouses actually running? This can... |
DevOps and Continuous Delivery (CI/CD) |
Phil Factor shares some of the common ways databas... |
SAS world headquarters felt charged with momentum as Jason Mann, VP of IoT, welcomed a room full of curious minds to the 10th annual IoT Slam Live. “We are in the... |
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. When you begin modelling in DAX,... |
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. |
When running a PostgreSQL database in a High Avail... |
This blog posting compares the performance of the pg_tde by Percona extension for PostgreSQL with the performance of an unmodified PostgreSQL. The pg_tde by Percona extension provides encryption for... |
The basic promise of a query optimizer is that it picks the “optimal” query plan. But there’s a catch - the plan selection relies on cost estimates, calculated from... |
Lately, it feels like every time I go to a technical conference, someone is talking about how great PostgreSQL is. I’d think it’s just me noticing, but the rankings... |
PostgreSQL Person of the Week Interview with Samed YILDIRIM: I’m originally from Turkey. The last city I lived in Turkey was Istanbul. I am now living in Riga, Latvia... |
How targeted improvements helped us speed up bulk data loads and complex schemas. |
Most teams building production applications understand that “uptime” matters. I am writing this blog to demonstrate how much difference an extra 0.09% makes. ... |
PostgreSQL user groups are a fantastic way to build new connections and engage with the local community. Last week, I had the pleasure of speaking at the Stuttgart meetup,... |
PowerPivot/PowerQuery/PowerBI |
Here’s yet another post in my series on things I think you should be doing in Power BI Copilot AI Instructions. Today: validating values that users enter as filters... |
Agencies warn that some US targets may be needless... |
Fraud and financial scams are on the rise. Accordi... |
AV vendors have worried that this could advantage ... |
But it requires specific hardware support that is ... |
Looking for backup solutions for WordPress websites? Here are seven popular options (that are all compatible with WordPress.com). |
Official was connected to FBI probe of cartel kingpin Joaquín “El Chapo” Guzmán. |
Dozens of accounts on X that promoted Scottish independence went dark during an internet blackout in Iran. Well, that’s one way to identify fake accounts and misinformation campaigns. |
No data caps: "Four simple national Internet tiers... |
Focusing on sound production instead of word choic... |
The payload likely to spark the most interest is the Blue Moon MK1 lander. |
US tech companies escape Canada digital services tax due to Trump tariffs. |
The boomerang is a one-of-a-kind find from the last place archaeologists expected. |
What if the data behind your next prescription could help save lives – not just yours, but millions more? Behind the scenes, researchers are turning everyday health records into... |
Developer solves mystery of hidden JPEG from the b... |
In ancient times, Rob's employer didn't have its own computer; it rented time on a mid-range computer and ran all its jobs using batch processing in COBOL. And in... |
Aaron was debugging some C# code, and while this wasn't the source of the bug, it annoyed him enough to send it to us. protected override int DoCompare(Item item1, Item... |
"Ever since I saw it for the first time, it's been high on my list." |
With the rise of AI and machine learning comes data. Lots of it. For organizations today, AI is radically changing the way data is accessed, maintained and operationalized. For... | 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. |
|
|