$10 to Support Wikipedia Too
I just donated $10 to Wikipedia. I use it and find it useful, so I don’t mind contributing so that...
2015-12-22
575 reads
Blog Posts
Benefits from Data Lifecycle Management
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,752 reads
CISL 1.0.4 is released
I am glad to share that the latest version of CISL – Columnstore Indexes Scripts Library 1.0.4 is finally released.
By all...
2015-12-22
474 reads
How to Compare Tables in SQL Server
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
552 reads
How to use CISL – the Columnstore Indexes Scripts Library
Around 3.5 Months ago in September of 2015, I have announced the first public release of the CISL – Columnstore Indexes...
2015-12-22
884 reads
Immunizations – Not Just for Kids
It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations....
2015-12-22
644 reads
Reflections and Looking Forward
Time is slowly ticking toward 0:00 on the clock. As I look around I couldn’t help but reflect back on...
2015-12-22
507 reads
The transaction log for database 'ABC' is full due to 'ACTIVE_BACKUP_OR_RESTORE'
I have recently had a client with a problem each morning where they were having processes fail with this message...
2015-12-22
20,073 reads
Which Secure Protocols are Allowed on Your Servers
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance.
This one...
2015-12-22 (first published: 2015-12-15)
1,804 reads
Demystifying the Type 2 Slowly Changing Dimension with Biml
Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...
2015-12-21
1,006 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Alamat BCA KCP Gudang Peluru Telp:0821°8200°233
Telp/Wa 628218200233 Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar Blok A No....
Alamat BCA KCP Bulevar Hijau Telp:0821°8200°203
Telp/Wa 628218200203 Ruko Sentra Niaga 2, Jl. Harapan Indah Raya No.1A Blok SN-2, RT.001/RW.024,...
Alamat BCA Rukan Patria Telp:0821°7555°651
Telp/Wa 628217555651 Rukan Patria Park, Jl. DI. Panjaitan No.6 RK 05, RT.6/RW.11, Cipinang Cempedak,...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers