| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| The Weather Outside Is Frightful Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days at home. It's Oklahoma. They do not deal well with snow, so we wanted to be sure we only went out on the roads if it was vital. Put in a bunch of wood for the furnace. A bunch of other stuff, including assuming there's a chance we'll lose power (again, Oklahoma, snow, not dealing well). It's not a lot different than the checks we do when tornadoes are on the way. It all goes back to a Navy saying: Prior planning prevents p*** poor performance. Apologies. The Navy can be a little bit profane. However, this very much ties back in to data. Why have I always harped so much on the need for backups AND the need to test those backups by doing a restore? Because of the 6 Ps. Why did we set up a tiger team, an emergency response team, at my last job and hold quarterly practice sessions? 6 Ps. Why do I like automation and automated testing? 6 Ps. Most of us will probably never have a major data outage. Your servers will run, just fine, your entire career. You'll never see a corrupted database, or it'll only be a nonclustered index that you can drop & recreate (honestly, the only corruption I've experienced in a database). You won't ever have to deal with the potential emergencies that could occur. For those of us so lucky, that's great. However, some of us, we're going to experience a true emergency. I'm here to tell you, if you don't prepare for it now, right now, when it happens, well, the last three of those Ps are likely to be the outcome. It is exceedingly hard to learn, on the fly, when your entire business is offline. So, adopt the 6 Ps (or, make it less profane and 5 Ps). 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 |
We all know what it means, colloquially, to google... |
Rising fraud and shrinking staff signal an urgent ... |
As generative AI transforms IT operations and busi... |
This story originally appeared in The Algorithm, o... |
Large language models (LLMs) are the backbone of m... |
Making public services as easy as online shopping ... |
Explore Google DeepMind's innovative approach to AI through world models, a groundbreaking initiative that seeks to simulate reality and advance toward artificial general intelligence. The post Google Building AI World... |
ITIC challenges new U.S. AI chip export regulations, arguing they threaten national innovation and could shift technological supremacy to international competitors. The post AI Chip Export Sanctions: Protecting or Impeding... |
AI is increasingly prevalent in our daily lives, and this trend is unlikely to change anytime soon. This comes with risks, but by understanding these risks, we can build... |
Administration of SQL Server |
I recently had an interesting production SQL Server issue that turned out to be very easy to fix. The fix doesn’t fit every workload or server, but for the limited use cases described below, it’s a simple configuration change. The general best practice for server level configurations is to leave things at default, unless there is a specific reason for changing the settings. This will outline a use case for using memory-optimized tempdb metadata. |
It’s hard to destroy data. Even when a column is... |
How to clear the SSMS cache? If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for... The post How to clear... |
querinous – adj. longing for a sense of certaint... |
Azure Databricks, Spark and Snowflake |
Built on Apache Spark, Delta Lake provides a robus... |
Recently, I was asked to compare data from a table... |
Azure offers several SQL-related services, each ta... |
Happy New Year! We are witnessing technology augme... |
AWS launches Asia Pacific (Thailand) Region with 3... |
Ah, SQL, CPUs and licenses... you've got to love it. Our SQL servers have specific loads, patterns and resource requirements. We've... |
Did you know? We’ve partnered with Ippon Technologies in the launch of Data Sips, a video miniseries showcasing quick conversations with industry experts that took place during last month’s... |
Computing in the Cloud (Azure, Google, AWS) |
Rising cloud expenses, the AI cost crisis, and org... |
As cloud computing matures, 2025 will bring a push for measurable sustainability, growing interest in supercloud architecture, and the normalization of multicloud environments. |
This guide walks you through creating a PowerShell GUI with Windows Presentation Foundation. We will examine key differences from Windows Forms, focusing on how WPF uses a grid layout... |
Data Mining / Data Analysis |
This article is the last in a multi-part series sh... |
Synthetic data has emerged as a powerful tool for ... |
Video by: Reid HavensAs a follow up to a my previo... |
Data Privacy, Compliance, and Governance |
Businesses engage in mergers and acquisitions (M&a... |
Data Storytelling and Visualisation |
It’s cold in the United States right now. Really... |
Database Design, Theory and Development |
Clinical trials for medical devices hold a unique significance due to their direct application in patient care and the rigorous scrutiny they undergo from regulatory bodies. Unlike pharmaceutical trials,... |
Data quality and consistency is key to the service... |
With the growth of generative AI, developer productivity is on everyone's mind these days. But measuring developer productivity is challenging. Learn how focusing on alignment can help eliminate the... |
Building a digital fortress with modern data management In an era where stone walls and moats are relics of the past, the battleground has shifted to the digital realm.... |
DevOps and Continuous Delivery (CI/CD) |
GitOps applies DevOps best practices to infrastruc... |
One of the neat enhancements made to Flyway was th... |
Read on to learn about how you can automate even more things with Flyway like project setup and state-based deployments. We’ll share how you can get the latest version... |
Core Ultra 200U, 200H, and 200HX will all fall sho... |
The carrot of "new features" and the stick of "no ... |
Dell won't make Precision or Inspiron PCs anymore,... |
Waymo software fix addressed "looping events" afte... |
New Ryzen AI CPUs boost speeds, but cheaper laptop... |
Sony's first electric vehicle doesn't come cheap. |
Circumstantial rumors suggest a new hybrid hardwar... |
It's intentional, and eligible users can get cash ... |
Project DIGITS can run a local chatbot or other AI... |
Yes, there are still visible creases. |
Nvidia leans heavily on DLSS 4 and AI-generated fr... |
Production of the Honda Zero SUV begins in Ohio in... |
Accessory maker says 3D mock-up at CES is sourced ... |
NVIDIA’s new Project Digits mini supercomputer is designed for developers, researchers, students, and data scientists who need to run AI models and will be small enough to fit in... |
But at $120, the new board has to compete with a wider universe of mini PCs. |
Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Data Pipelines can orchestrate many activities, creating a flow for data ingestion. One of these activities is the notebook execution activity. |
Reading Time: 6 minutesIn this post I want to co... |
You don't want to store your secrets in plain text... |
In this blog post I am going to determine which it... |
Data Pipelines can orchestrate many activities, cr... |
One of the questions I often get these days is what are the benefits of Microsoft Fabric for Power BI users and developers. Questions like: “If I am not... |
What happens when you sign up for Microsoft Fabric... |
When we perform data integration and ETL processes, the most effective way is only read the source data that has changed since the last time the pipeline ran, rather than... |
Oracle/PostgreSQL/MySQL/other RDBMS |
RavenDB is a transactional database, we care deeply about ACID. The D in ACID stands for durability, which means that to acknowledge a transaction, we must write it to a persistent... |
Performance Tuning SQL Server |
The hidden costs of using TOP versus TOP PERCENT c... |
I recently had an interesting production SQL Serve... |
Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills. First appeared on Performance and TempDB Spills – SQL in Sixty Seconds 208 |
A short review of PostgreSQL post rankings in 2024... |
On 18th of December 2024, Michael Paquier committe... |
Redgate Monitor is growing to include more than ju... |
The number of cool things you can do with the http... |
Introduction PostgreSQL 18 will normally (as t... |
I did a couple of posts previously on dumping/rest... |
I’ve had a wish list for a few years now of observability-related things I’d love to see someday in community/open-source Postgres. A few items from my wish list: ... |
HexaCluster is back with its Summary of PostgreSQL in 2024 like our article in 2023. We would first like to thank all PostgreSQL Users, Contributors, Organizations, and Sponsors who... |
If you’re managing a PostgreSQL database and handling sensitive data or PII, the answer is simple: You need data-at-rest encryption. This isn’t just a “nice-to-have” feature—it’s often a legal... |
Yup, you read it right. Idle transactions can cause massive table bloat that the vacuum process may not be able to address. Bloat causes degradation in performance and can... |
PowerPivot/PowerQuery/PowerBI |
Power BI reports are usually used to display numer... |
An IT pro asks us about reintroducing a sense of c... |
Most of us know that spending a lot of time on soc... |
As technological change accelerates and outdated training methods falter, AI-driven digital humans offer businesses a scalable solution to reskill employees with greater engagement, retention, and efficiency. |
Let’s play with some words. More in particular w... |
Ever wanted to have a clock on the wall or in the ... |
From the Washington Post: The sanctions target Bei... |
Video feeds from at least 150 Motorola license pla... |
How do you stash 18,000 keywords into a descriptio... |
In-the-wild attacks tamper with built-in security tool to suppress infection warnings. |
404 Media is reporting on all the apps that are sp... |
When using IFTTT, there’s an option to call an I... |
Video by: Reid HavensLearn how to leverage the new... |
In 2024, our most popular software development art... |
Generative models can be powerfully useful—if yo... |
T-SQL and Query Languages |
How To Write SQL Server Queries Correctly: IN and ... |
How To Write SQL Server Queries Correctly: Common ... |
How To Write SQL Server Queries Correctly: Views v... |
I’m familiar with using the OVER clause and don’t think it’s too uncommon to see it used for including row numbers by using ROW_NUMBER() and aggregating data. But even... |
How To Write SQL Server Queries Correctly: UNION and UNION ALL Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about,... |
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro.... The... |
How To Write SQL Server Queries Correctly: INTERSECT And EXCEPT Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll... |
The shift aligns with Elon Musk's X, but raises ri... |
85 percent of invalid papers continue to be shared... |
"We are strong if we remain united and defend our ... |
Judge: Reasonable juror may find Google profited from misappropriation of data. |
"I think we’ve got more questions than answers at this point." |
Starship will test its payload deployment mechanism on its seventh test flight. |
Steve Young's passion built a business that keeps ... |
Remake of 1993 classic lets you drink wine and eat... |
Antonio's team hired some very expensive contractors and consultants to help them build a Java based application. These contractors were very demure, very mindful, about how using ORMs could... |
This recently mapped Bronze Age fortress is just o... |
My Arcade's "GameStation" partnership means authentic portable Tempest, Missile Command, etc. |
And a few months later, the Internet's first password. |
The large ring weighs nearly half a ton and does n... | 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. |
|
|