Page Inspect

SQLServerCentral – The #1 SQL Server community





- Articles
- Editorials
- Stairways
- Forums
- Forums home
- Active threads
- Latest topics
- Most popular
- Leaderboard
- Scripts
- QotD
- Books
- Blogs

- Register
- Login

- Write for us
-
- Menu

- Articles
- Editorials
- Stairways
- Forums
- Forums home
- Active threads
- Latest topics
- Most popular
- Leaderboard
- Scripts
- QotD
- Books
- Blogs
- Write for us
- Register
- Login



# Is Rolling Back The Same as Failing?

- by Andy Warren

- SQLServerCentral.com

- Editorial

When you must rollback a deployment of changes, is that a failure of the process? The development effort? Or something else?

# Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

- by Chandan Shukla

- SQLServerCentral

- Uncategorized

In this level of the Stairway to Azure SQL Hyperscale we learn about the read-only layer that speeds up queries.

# Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions

- by Additional Articles

- MSSQLTips.com

- T-SQL

Searching for a string in database tables has been discussed over the years. There are several approaches to the problem (see References at the end of the article). See how to use SQL to find a string in different types of SQL Server objects and data.

# Find Invalid Objects in SQL Server

- by Nisarg Upadhyay

- SQLServerCentral

- Advanced SQL
- Database Administration
- Database objects
- MSSQL administration

This article shows how you can find which objects in your database might not be valid after schema changes.

# Getting Fired

- by Steve Jones

- SQLServerCentral.com

- Editorial

When should a DBA get fired? Steve Jones thinks it should be rare and gives you two cases.

# SQL Server 2025 Makes Memory Troubleshooting Easier.

- by Additional Articles

- Brent Ozar Blog

- Performance and Tuning
- SQL Server 2025

SQL Server 2025 introduces a new sys.dm\_os\_memory\_health\_history view to make it easier for meatbags like you and robots like Copilot to know if the SQL Server has been under memory pressure recently.

# Lessons from the Postmark-MCP Backdoor

- by dbakevlar@gmail.com

- SQLServerCentral

- Artificial Intelligence (AI)

The Koi Security team recently uncovered the first known, malicious MCP server in the wild: a package called postmark-mcp, downloaded over 1,500 times per week, that silently BCCs every outgoing email to an attacker-controlled domain. So, what happened?  High-level, a lot: The attacker cloned the legitimate Postmark MCP repository, made one small but nefarious change \[…\]

# Cleaning Up the Cloud

- by Steve Jones

- SQLServerCentral

- Uncategorized

Trying to clean up a cloud subscription is an interesting experience.

# Oracle Performance Tuning: Practical Techniques Every DBA Should Master

- by Udaya Veeramreddygari

- SQLServerCentral

- Oracle

Here are a few things every Oracle DBA should know about performance in their databases.

# Natural Language Query for SQL Server

- by Additional Articles

- MSSQLTips.com

- Artificial Intelligence (AI)
- SQL Server 2025

Data is usually the most important asset in organizations, but only SQL developers can frequently access that data. Technical teams often write queries for non-technical users. This restricts agility, slows decision-making, and creates a bottleneck in data accessibility. One possible remedy is natural language processing (NLP), which enables users to ask questions in simple English and receive answers without knowing any code. Still, the majority of NLP-to-SQL solutions are cloud-based, which raises issues with cost and privacy.

Next

- 1
- 2
- 3
- …
- 1,967

Take Our Poll

## SSC Newsletters
Subscribe to the daily newsletter to get fresh SQL Server articles, scripts and info every day, and Database Weekly for a roundup of all the big stories in the SQL Server world.

Email

SSC Daily Newsletter

Database Weekly

## Blogs

### Truncate Table Pitfalls

By Peter Skoglund

Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

### dataMinds Connect 2025 – Slides & Scripts

By Koen Verbeeck

You can find all the session materials for the presentation “Indexing for Dummies” that...

### “SQL Server Is Slow” Part 4 of 4

By Kevin3NF

Parts 1, 2 and 3 got you to the (SQL) engine room. Now we...

Read the latest Blogs

## Forums

### visual studio seems to lose "provider" on pkg imports

By stan

hi, just to get this part out of the way, if my intended target...

### ERD Tools recommendation

By Coffee\_&\_SQL

Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations?...

### Stairway to Azure SQL Hyperscale – Level 3: RBPEX Caching Layer Internals

By Chandan Shukla

Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...

Visit the forum

## Question of the Day
### Vector Datatype Dimensions

The new vector datatype in SQL Server 2025 requires a number dimension parameter. What is the maximum number of dimensions supported?

See possible answers

- About SQLServerCentral
- Contact Us
- Terms of Use
- Privacy Policy
- Contribute
- Contributors
- Authors
- Newsletters