PASS Summit, AI, Admin, Fabric, Snicker Bars, a nd So Much More!

PASS Summit Time

As the Simple Talk Editor, I have had the privilege of attending numerous conferences these past few years, and all of them have been somewhere between great and amazing. Still, there is something a bit more special about the PASS Summit. Even before I started this position, I have been to the PASS Summit events for nearly 25 years (with a few breaks…notably a hip, a foot, and a rotator cuff, but I digress). When we weren't on a break, this week-long event has always ranked high on my list of things I was excited about each year.

From the moment you step into the venue, you can feel it. Professionals from all corners of the globe are there to share their knowledge, experiences, and insights, not to mention learning something new. Whether you're a seasoned expert or a newcomer to the field, there's always something to learn and someone new to meet.

One of the highlights of the PASS Summit is the incredible lineup of sessions. The content is curated to ensure that there is something for as many types of data community members as possible. From deep dives into the latest technologies and trends to sessions on practical topics, the content's breadth and depth is impressive.

To be fair though, while you will learn a lot that you can return to your job and make it worth the trip in the short term, that knowledge is only the start of what makes this conference awesome.

Whether this is your first conference, or one of many conferences with a similar data focus that you attend, you'll start to notice some of the same people over and over. Talk to one or two of these people over a cup of coffee, during a lunch break, or at one of the many social events.

The relationships you build may last a lifetime. I wouldn't be sitting here writing this editorial if I hadn't asked a vendor during one of my first visits to Seattle, "Are there any good books on database design?" and they answered back "We don't have any, would you like to write one?"

As I look forward to next week's PASS Summit, I want to encourage you to get out of your shell, attend sessions, ask questions, meet new people, and immerse yourself in the experience. Explore the area too (if the weather is nice that whole area in Seattle is great to explore), but go to the conference and get everything you can from it.

And whether you listen to my advice, I certainly need to be reminded of it myself because sometimes I would prefer to be sitting in my room away from tired feet and hurting muscles. The advice helped me in the past, and it can help us both today, tomorrow, and maybe 20 years from now.

Louis Davidson (@drsql)

Join the debate, and respond to the editorial on the forums

This article explores PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before they impact users.

Although it is probably true to say that “AI is ...

An AI that makes better AI could be "the last inve...

We've always used tools to build new tools, and developers are using AI to continue that tradition.

Jayita Gulati provides an overview: Anomaly detection means finding patterns in data that are different from normal. These unusual patterns are called anomalies or outliers.…

The 29th cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to...

Chad Callihan talks about an untrustworthy setting: TRUSTWORTHY is a database property change that can have far-reaching security consequences when turned ON. Let’s take a…

Eitan Blumin eats the elephant: Traditional database integrity checks in SQL Server can be time-consuming and resource-intensive, especially for large databases, even when using super…

SQL Server Ledger - has taken data integrity to the next level, integrating blockchain-style data verification directly into the database. First appeared on SQL Server Ledger – Are You Really...

I’ve been preparing my slides for my PASS Summit...

In today's rapidly evolving landscape, managing the security of large and complex database estates is a critical challenge for organizations. Join us on November 21 for a webinar on “Prioritizing security: Essential strategies for IT leaders,” where Redgate’s security experts will share their tips on how you can safeguard your database estate and minimize reputational risk. There will also be a Q&A session where you can get expert advice from our panelists.

I have a new video: In this video, I show how to perform a variety of database backup operations via PowerShell, using the dbatools PowerShell…

The post Introduction to Advanced Analytics appear...

Sandeep Pawar wants to make a change: Spark properties are divided into mutable and immutable configurations based on whether they can be safely modified during…

Microsoft Fabric is touted as a software as a serv...

Gilbert Quevauvilliers wants to know about storage utilization in Microsoft Fabric: This blog post will show you how to understand what is consuming your Fabric…

Ayman El-Ghazali solves a problem: A few months ago, an ISV customer approached with a request to have notebooks run across Microsoft Fabric Lakehouse environments…

This blog post will show you how to understand what is consuming your Fabric Storage. If you want to know how I got this data, please read my previous...

Reading Time: 7 minutes You can consider this post a Fabricators guide to version control in Microsoft Fabric. Including my unique insights and how this ties in with...

T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss the fact this is a new feature at all. Yes, it is....

Full-text indexes are special – they’re a type of index that enables fast and efficient searching through data using rather exotic search modes: in MySQL, those search modes include, but are not limited to the Boolean mode, natural language mode, and a search mode using query expansion.

David Fowler explains an error: Recently I received a cry for help over Teams. The issue was that an application was throwing up the following…

This article looks at the performance benefits of ...

Recently I received a cry for help over Teams. The issue was that an application was throwing up the following SQL error, The query processor ran out of internal...

What Missing Index Requests Miss In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my...

Learn how to use SQL Server Query Store to obtain the performance history of application queries and determine what needs to be tuned.

Umair Shahid switches dialects: To address these l...

You followed all the best practices, your sales da...

I work with hundreds of consulting clients who go through the same cycles, having the same experiences, facing the same challenges, many making the same mistakes, and many learning...

Timescale, the leading PostgreSQL database platform, today expanded its PostgreSQL AI offerings with the launch of a groundbreaking tool, pgai Vectorizer, available open-source and hosted in the cloud. Pgai Vectorizer unlocks the ability for any developer to build advanced AI applications without the need for external tools or specialized expertise. This release, along with the pgai suite of PostgreSQL extensions— pgai and pgvectorscale—slashes infrastructure costs by 75%.

I still have a tendency to talk about all the cons...

Sometimes, we encounter folks who are reluctant to add words to their data tables or visualizations. This hesitation might stem from having been taught to “let the data speak...

Steven Sanderson makes a list but doesn’t check it twice: Lists are fundamental data structures in R programming that allow you to store multiple elements…

As tech layoffs increase, they pose a dual risk to...

The German police have successfully deanonymized a...

The advance was incremental at best. So why did so...

To protect sensitive patient data, healthcare organizations are adopting strategies such as the 3-2-1 backup rule.

Solomon Rutzky shares some thoughts: Since the new UNISTR function doesn’t provide new functionality, only convenience (“syntactic sugar” as some would say; see comment below), I would…

It’s time to try another video. In this one, I�...

I looked at row_number() in a previous post. Now I want to build on that and do some counting of rows with COUNT() and the OVER clause. I’ll show... The...

bye-over – n. the sheepish casual vibe between...

How the airy nougat and chewy caramel is built.

An IT pro wore a superhero costume to delight clients but was denied reimbursement for the outfit. Should he push for it or let it go?

I was thinking about new ideas for Halloween-related blog posts. I’ve written about the Halloween problem and ghost records. Somehow I ended up wondering how different AI assistants would...

By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly,...