| | The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | | Hand-picked content to sharpen your professional edge |
| Let's Talk Certifications In just over a week, I'm going to be in Valencia, Spain, for pgConf.eu. While there, I'm planning to take the first certification to come out of the Open Alliance for PostgreSQL Education. I'm more than a little nervous because I'm not sure I'm ready. However, I've been studying and reading, watching videos, practicing my psql skills, even having an AI generate a series of practice tests for me (75/80 on the last one). I'm doing what I can to be ready. However, that's not the purpose of this editorial. I don't want to talk about this particular cert, but rather all certs. I've got a weird relationship with certifications. In my (failing because of old age) memory, I believe I received two certifications, both of them back in the 1990s. Pretty sure I went through a Token Ring certification and a Sybase 4.2 cert. Yes, it was that long ago. And that's it. I'm coming up on 40 years working in IT and that is my entire certification history to date. It gets worse. I didn't even go to college for IT. I went to film school... and dropped out. In short, by many standard measures, I'm not qualified to do what I do. No degrees. No certifications. No actual proof that I know what I'm doing. I mean, as long as you don't count 40 years in IT. Never getting fired for incompetence (only actually got laid off one time and that was because the company was going under). 22 books with my name on them. Speaking at events, large and small, all over the world. Blogs, articles, podcasts, interviews. If you don't count any of that, I'm unqualified. I'm sure you get by now that I'm totally doing a bit of a dig on certifications. So why am I both promoting and planning to take a certification test (and fingers crossed, pass, good gosh failing will be so embarrassing)? Because certifications are a useful tool. Have they done anything for me and my career? Nope. Does that mean that all certifications and the people that take them are wasting their time? Hell no! Quite the opposite. I'm not going to sit here and tell you that when I look at someone's CV/resume that I look for certifications. I don't. If they're there, great. If not, OK, let's see what you claim you've done. What I am going to say is that the process of getting the certification is extremely useful. The main reason for this is because it provides a structure to your learning. Several years back, when I started learning PostgreSQL, the very first thing I did (after figuring out how to get it running) was explore restoring databases. Now, do I recommend that as a starting point for learning? Nope. Not at all. It just so happens that I wanted to simply explore Postgres. However, preparing for this certification has put me through several topics that I just hadn't explored through my slap dash learning style. An interesting one to call out is upgrades. I'd been in the habit of tossing one container and starting another, no upgrade needed. However, a fundamental fact of data management is upgrading your databases. So, I had to spend quite a bit of time learning about upgrades (article or three inbound, btw). It's that structure, that set of definitions for what a certification points out as important, that, at least to me, is the power behind a certification. Yes, there a whole slew of other benefits as well. However, the structure that learning requires in preparation for a certification, that's hard to discount. You'll see an article (or articles) from me discussing whether I passed or failed (and yeah, I'll be brutally honest, more fool me). I hope that you too will use the learning structures of certifications to expand your knowledge. Do you then have to take the test? Nope. I just think the structure will help you learn more, better. Wish me luck. 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. |
Learn how to secure MCP database access: stop conf... |
In 2026, the question for enterprise AI is no long... |
Your AI found the company policy. It summarized it... |
I was in Italy for a month. While I was gone, somebody got sysadmin out of SQL Copilot with a variable. The vulnerability is CVE-2026-65669, the SSMS 22 Copilot bug... |
Over the summer I talked to the CEO of Springboard... |
For all the data that AI systems continually amass... |
Developers already have useful capabilities expose... |
WordPress.com MCP connects AI assistants like ChatGPT and Claude to your site. Here are seven practical ways to publish and refresh content, check traffic, organize your site, and handle... |
The story is a collaboration between MIT Technology Review and Aventine, a non-profit research foundation that creates and supports content about how technology and science are changing the way... |
| Administration of SQL Server |
AI row count estimates arrive with tremendous conf... |
Welcome back to the series on internals of storage... |
I caught this interesting item over on Pinal Dave?... |
I use color-coded connections in SSMS to distingui... |
Discover ways to manage AWS SQL Server licensing e... |
SQL Server network latency can make a fast databas... |
Explore the Romberg Method, a powerful technique i... |
Words: 375Time to read: ~2 minutes Hey! … Now that I have your attention, can you see what’s wrong with this query? Prep Like every food recipe out there,... |
For a while now, I really have wanted to learn the Windowing Functions in great detail. I know them well enough to make it through a lot of needs,... |
Understand SQL Server indexing to reduce CPU utili... |
For more than 20 years, many small and medium SaaS companies have built products with complicated business logic and a flexible user experience on the .NET stack using an... |
| Career, Employment, and Certifications |
Sometimes I take the bait and I read some form of ... |
Data leadership drives smarter decisions, stronger... |
This is the final post in a four-part series about post-training. If you missed them, check out part 1, part 2, and part 3. Time to get your hands... |
Last week, we announced a public preview of Amazon... |
Amazon Prime Day 2026 was exclusively for Prime members and ran June 23–26, 2026 with millions of deals across more than 35 categories. As part of our annual tradition... |
A few years ago I took a new job at Microsoft, wor... |
Last week me and the team were in Barcelona for FabCon Europe, alongside nearly 5,000 other data professionals. This year’s keynote had a clear message: Fabric is now the... |
In this blog post, I will cover topics such as classes and objects to provide a better understanding of how PowerShell works with objects. Classes, Objects, Properties, and Methods... |
| Data Mining / Data Analysis |
A convolution is a mathematical operation on two d... |
Discover the power of SQL analytical functions. Th... |
When combining and curating data in your Silver l... |
Organizations have access to more data than ever before. The challenge has shifted from finding data to making sense of it. Understanding where programs are already making an impact... |
| Data Privacy, Compliance, and Governance |
Struggling with SOC 2 audits? Learn how test data management protects customer data outside production and keeps testing compliant.… The post Why test data management is essential for SOC 2... |
| DevOps and Continuous Delivery (CI/CD) |
Here are the resources for my talk at Day of Data ... |
Defining the right contract is a key activity for ... |
| Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) |
Pilot versus enterprise-wide is the wrong debate — the real question is which one your organization is actually ready for. Here's how to start narrow, learn fast, and earn... |
Parallel scans need a minimum table or index size ... |
`min_wal_size` sets a floor under WAL recycling, n... |
When one long transaction holds row locks on thous... |
In this post, we’ll look at how to upgrade a Pos... |
PostgreSQL connection poolers lie to both sides of... |
pgvector 0.8.7 fixes CVE-2026-103484: a database u... |
Two EXPLAIN ANALYZE runs on statistically identica... |
The `notify_buffers` GUC tunes a 128kB cache for P... |
This is part 2 of a series about Postgres logical ... |
My tool tells you things like “this index cuts t... |
Dive deeper into connection pooling with five more PostgreSQL poolers: Odyssey, pgagroal, Supavisor, PgDoorman, and ProxySQL, plus where your cloud already… (I consult on PostgreSQL through PGX Inc..) |
PostgreSQL 18's new `num_os_semaphores` preset reports how many OS semaphores the server needs—a formula that drifted wrong for twelve years until the… (I consult on PostgreSQL through PGX Inc..) |
Last week I ported Apache Cloudberry to PostgreSQL 19 as a set of extensions and described where the port falls behind the original fork. On ClickBench, columnar engines beat... |
| Power BI/PowerPivot/PowerQuery |
As you’ve probably seen in the blog post for the... |
Sh*t sucks right now. Microsoft is explicitly posi... |
LIVESTREAM DATE/TIME ??October 16th 2026 - 9:30 AM... |
Your blogs, newsletters, and social feeds in one free RSS reader, plus new ways to catch up, get organized, and find your next favorite writer. |
What share of students who start at a US four-year... |
In 2016 a developer pulled an 11-line JavaScript p... |
Zillow’s typical US home value reached another record in August 2026: $368,697, the highest since its series begins in 2000, and 17 of Zillow’s… |
This post is a quick public service announcement t... |
This one is from 1809, written by Napoleon’s nep... |
Norway plans temporary restrictions on AI glasses ... |
Wikimedia says OpenAI-linked agents made millions of requests and may have contributed to a May outage. Here’s what we know about the activity. |
| T-SQL and Query Languages |
This proverb is one of the age old classics. “Ev... |
Researchers designed a superfluid helium qubit tha... |
Google, Meta, Microsoft, and other AI infrastructu... |
Demand for energy storage is surging, with capacit... |
As sea levels rise and flood risks worsen due to g... |
Brimstone is making strides on two industrial prob... |
X-energy is developing small modular reactors to s... |
A junior dev on the team had a simple question: in Java, how do I correctly read user input from the CLI and act on it? Now, we can wonder... |
  | 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. |
|
|