| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| Personal Contact Is Vital I'm writing this while in hiding at the PASS Data Community Summit that's taking place in Seattle this week. I just had a real surprise, finding out that DocumentDB is PostgreSQL under the covers and always has been. However, as much as I enjoy talking PostgreSQL, for the moment, I'll shut up about it. Instead, I'd like to take some time and share a couple of lessons I had this week that have reminded me just how important direct, personal, contact between humans really is. I'm not speaking for anyone but myself when I say, it's easy to lose sight of how important creating, and then maintaining, direct communication with other people is. I screwed up this year and I didn't reach out to a few people who I absolutely should have been in contact with. Either, I just wasn't paying attention, or I thought other people would do it. Regardless of the excuse, I dropped the ball. I didn't talk to them through any of the mediums I had available. Because of it, frankly, we're missing a few voices this year. That's my fault. I'll own it. Don't worry, this isn't all Debbie Downer talk. I also, just a couple of minutes ago, had a great moment. Wonderful in fact. I was hanging out at the PostgreSQL Community booth (hey, it's fair within the rules, I'm talking about the community, not the data platform). I had someone walk up and thank me, because years ago, I gave them a little advice during a session. It was almost a throwaway line, but it resonated and they've been applying it for years to great success. It gave me such a warm and fuzzy, I just had to share. I know a lot of you are like me, introverts. Please, don't lose sight of keeping in touch with the people around you. I know it's not easy, but it's so important. I just had my positive and negative reminders. Get out there, make your reminders all positive ones. And in case anyone wants to know, the advice was simple. Before you get into all the complexities of query tuning, try just getting a WHERE clause in there to filter the data you're dealing with. That's it. Simple, but evidently effective. 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 |
Headlines surfaced by a simple “job market” se... |
Training an AI model to predict equipment failures... |
Everyone wants to move faster with AI, but few are truly ready for it. This is where organizations can position themselves better as AI readiness isn’t just about algorithms,... |
SQL Prompt AI can repair certain types of broken SQL almost instantly, saving hours of clean-up time. Just prompt it clearly, check the results are exactly what you intended,... |
Manufacturing is getting a major system upgrade. As AI amplifies existing technologies—like digital twins, the cloud, edge computing, and the industrial internet of things (IIoT)—it is enabling factory operations... |
Discover how to establish a foundation for success with AI in insurance. The post The AI paradox: A path to success – and failure appeared first on SAS Blogs. |
Digital resilience—the ability to prevent, withstand, and recover from digital disruptions—has long been a strategic priority for enterprises. With the rise of agentic AI, the urgency for robust resilience... |
| Administration of SQL Server |
SQL Server Management Studio (SSMS) has recently a... |
Last week I asked you to write about SQL Server 20... |
Writing Better Dynamic SQL This updated and "sort"... |
As many expected, Microsoft kicked off their Microsoft Ignite conference today by announcing that SQL Server 2025 is now generally available with new features like built-in regex, AI capabilities,... |
As I was working on another problem the other day, I had the need to compare two tables that had been created and modified by AI. I created fairly... |
Batched deletions are a common strategy in SQL Server to manage large datasets without overloading the system, but poorly tuned deletes can cause blocking, long-running transactions, and heavy log... |
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting... The... |
Slow queries are one thing, but under heavy pressu... |
Since Microsoft Ignite and PASS Summit is this week, I figured a quick RegEx post was in order. I will be shocked if SQL Server 2025 is not released... |
The terminology around reliability is a mess If you’ve ever said, “We’re covered, it’s replicated,” you’re in good company. SQL Server is a massive, 35+ year-old product that... |
AWS Lambda introduces tenant isolation mode, enabling separate execution environments for each tenant within a single function to meet strict security requirements without managing dedicated per-tenant infrastructure. |
Thank you for attending my PASS Summit 2025 sessio... |
| Computing in the Cloud (Azure, Google, AWS) |
What a journey! I’m very happy to announce that ... |
Google today unveiled Gemini 3, a major upgrade to... |
| Data Mining / Data Analysis |
It is difficult to evaluate high-dimensional integ... |
This is the fourth in a five-part blog post series... |
Picture this: You’re a data analyst on day one a... |
| Data Privacy, Compliance, and Governance |
How do we protect sensitive data and still get realistic test databases without creating a masking process that is slow, brittle, or impossible to maintain? This article sets out... |
| Database Design, Theory and Development |
You’ve been there. It’s late. You’re staring... |
Redgate Monitor v14.1.0 now provides a simple, built-in integration with ServiceNow that uses its REST API directly. This replaces the older webhook-based approach and removes much of the setup... |
A few weeks ago I wrote a blog post about how you ... |
Differences between model-dependent and model-inde... |
This article explains the distinction between mode... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Holy cow FabCon Vienna was incredible! This recap ... |
Discover how to build ultra-fast mapping applicati... |
The beautiful Old College building at the University of Edinburgh. Photo by LWYang from USA (CC BY 2.0). I'm thrilled to announce that the PostgreSQL Edinburgh meetup is... |
Unlike the standard multi-node Postgres replication cluster, when managed by Patroni, all failovers are automatically executed. However, this is not the case when dealing with inter-datacentre failovers when for... |
Berlin PostgreSQL Meetup on Thursday, November 13 ... |
Just got home from KubeCon. One of my big goal... |
Do you need a PostgreSQL license for critical prod... |
The TLS server provides an alternative to using SS... |
I recently watched a video about Starbucks and how... |
When creating data models in PostgreSQL (or any ot... |
Everyone’s freaking out about AI taking their jo... |
Postgres 18, released on September 25, 2025, intro... |
| PowerPivot/PowerQuery/PowerBI |
The Power BI Enhanced Report Format (PBIR) will so... |
Microsoft has released a Power BI modeling MCP server. The responses have ranged from “This is awesome!” to “I have no idea what any of this means”. So, in... |
One of the common challenges I’ve seen in organizations is when a team member leaves and their Power BI reports are stored in their personal My Workspace. These reports... |
It isn’t terribly difficult to rebind a thin report to another model in the Power BI service. I’ll let you ask your favorite LLM how to do that. When... |
Feeds I Read Page | Other Feedly Friday Posts Welc... |
Redgate took the main stage earlier today to open PASS Data Community Summit with our keynote, where we shared our vision for the future of the database development experience... |
When I created the website on WordPress, I was expecting all the features I had on our WordPress.com which powers this website. As I called out in my previous... |
Google has filed a complaint in court that details the scam: In a complaint filed Wednesday, the tech giant accused “a cybercriminal group in China” of selling “phishing for dummies”... |
Open source is the reason WordPress is the way it is — flexible, customizable, and fully yours. This guide breaks down what that actually means and how it compares... |
One of the things that makes legacy code legacy is... |
Someone wanted to make sure that invalid routes logged an error in their Go web application. Artem found this when looking at production code. if (requestUriPath != "/config:system") && ... |
  | This email has been sent to {email}. 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. |
|
|