Articles

External Article

What are the Key DevOps Performance Metrics You Should Track?

Successful DevOps teams rely on data-driven decision-making to continuously improve software delivery and operational performance. Understanding the right DevOps performance metrics is crucial for identifying bottlenecks, improving efficiency, and maintaining high availability. Metrics provide insight into how well your team deploys software, how quickly issues are resolved, and how stable the production environment remains over time.

2025-06-16

External Article

Real-time Data Streaming in Snowflake

Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams from IoT sensors, financial transactions, and application events with minimal latency. Snowflake offers two robust approaches to meet these real-time data needs: Snowpipe for near-real-time file-based streaming and Direct Streaming via Snowpark API for true real-time data integration.

2025-06-13

SQLServerCentral Article

SQL Automate - A DBA's Time-Saving Toolkit

SQLAutomate is a lightweight PowerShell tool that simplifies SQL Server deployment by automating both installation and post-installation configuration. Whether you're setting up one instance or dozens, this guide shows how to use SQLAutomate to save time and reduce manual work.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2025-06-06

9,909 reads

External Article

Index Scans and Table Scans

There are several things that you can do to improve performance by throwing more hardware at the problem, but usually the place you get the most benefit from is when you tune your queries. One common problem that exists is the lack of indexes or incorrect indexes and therefore SQL Server has to process more data to find the records that meet the queries criteria. These issues are known as Index Scans and Table Scans.

2025-06-06

External Article

Purging Data from a Large Table in SQL Server

Purging data from a table is a common database maintenance task to prevent it from growing too large or to stay in compliance with data retention. When dealing with small amounts of data, this can be accomplished by a simple delete with no issues; however, with larger tables, this task can be problematic. Deleting records requires a lock that can block other processes from writing or even reading the data (depending on your isolation level). In this article I will share a technique I have used to work with some very large tables.

2025-06-04

Blogs

Getting SQL Server 2025 RTM Running in Containers on macOS

By

SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...

The PASS Data Community Summit 2025 Recap

By

It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...

Microsoft Post-Quantum Crypto APIs Are Now Generally Available

By

I mentioned this in my talk on Quantum Computing at the PASS Data Community...

Read the latest Blogs

Forums

The Ending Substring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Ending Substring

Done is Better than Good

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Done is Better than Good,...

Configuring the On-Premises Data Gateway: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...

Visit the forum

Question of the Day

The Ending Substring

In Azure SQL Database and SQL Server 2025, if I run this, what is returned? 

SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'

See possible answers