Using Graph Theory To Group Records
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
Accelerating Digital Transformation: The role of DevOps and Data
SQL Server Central Editor, Steve Jones is joined by a panel of industry experts from around the globe to discuss their experiences with digital transformation, and the impact it had on themselves, their teams and the wider organization.
How to Import and Export Connections from SQL Server Management Studio
In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.
The Useful Cloud Tags
Tagging is important to keep track of resources in the cloud. Today Steve asks how you approach this topic.
Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability
In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.
The VALUES clause or building tables out of nothing
The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.
Returning To An Employer
Leaving an employer on good terms is important, and Steve thinks employers ought to consider hiring former employees, even if they were let go in a layoff.
Stairway to Columnstore Indexes Level 2: Columnstore Storage
To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.
Blogs
Install SQL Server 2025 Container on macOS Using OrbStack
My old Dell XPS that I used for personal stuff started to degrade; well,...
Flyway Tips: Immediate Code Review for Developers
By Steve Jones
At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
Forums
Alamat Kontak Bank BCA KCU GALAXY Telp:08218154393
WA:08218154393 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa Timur...
Alamat Kontak Bank BCA KCP Tidar Telp:08218154393
WA:08218154393 Jl. Tidar No.109, Petemon, Kec. Sawahan, Surabaya, Jawa Timur 60252
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers