SQLServerCentral Article

SQL Server Consolidation : how to decide on the right approach

The PASS DBA VC hosts this session today that will focus on helping to choose between using a virtualization, instance, or database consolidation option. We will highlight a few of the key areas to consider as well as some of the important differentiators to keep in mind. We will provide a decision tree to help guide administrators through the process of selecting a consolidation option.

External Article

Celko's SQL Stumper: The Class Scheduling Problem

What can we use in SQL instead of E. F. Codd's T theta operators for best-fit? Joe Celko returns with another puzzle that isn't new, in fact it already features “Swedish”, “Croatian” and “Colombian” solutions in chapter 17 of Joe's 'SQL for Smarties' book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!

Blogs

PlanTrace Now Supports PostgreSQL

By

PlanTrace Now Supports PostgreSQL The same plan analysis you know from...

A New Word: the Kinder Surprise

By

the kinder surprise – . the point in your early adolescence when you realize...

Crash-Consistent Snapshot Cloning - Hyper-V Edition

By

If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...

Read the latest Blogs

Forums

BCA KCP Kapuk Muara Telpon/wa.085373737699

By cungphu

BCA KCP Kapuk Muara Telpon/wa.085373737699.Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok...

BCA KCP Plaza Medan Fair Telp/WA.0821°3111°179

By gi8hey

Telp/WA.0821°3111°179 Gedung Plaza Medan Fair, Jl. Gatot Subroto No.30 GF-1G, Sekip, Kec. Medan Petisah,...

Cara buka blokir permata bank salah pin 3×

By jeksen

Cara buka blokir Bank Permata (rekening/ATM/mobile) dapat dilakukan melalui PermataTel di 1500-111, whatsapp, 0821"3737"9963...

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers