Explore Our Tech Thinking

Is Your Large SQL Server Database Slowing Down Your Business? Learn How to Master rangeId Partitioning! 🚀

This article discusses a hot topic in database administration and how to automate partitioning with ever-increasing ids.

🚀 Stop Hardcoding! Unlock Flexible T-SQL Scripting with SQLCMD 🔑

This article quickly demonstrates the value of SQLCmd to handle repeatable T-SQL code on many different environments with variables.

$1 Million Saved on SQL Server Licensing: The Unconventional FinOps Strategy You Need to Copy

Many companies are locked into massive commercial contracts for SQL Server. And while it’s a powerhouse database, the licensing costs can be crippling.

Handling Cross-Type Equality in SQL Server to PostgreSQL Migration with Custom Operators

Migrating a database from SQL Server to PostgreSQL introduces some key differences, particularly in how the systems treat comparisons between mismatched types such as text, varchar, integer, and timestamp. SQL Server is liberal in allowing these comparisons through implicit casts, whereas PostgreSQL is more strict but often still allows common cases via its own casting rules.

A Practical Guide to Data Engineering with Google Cloud

If you’re new to Google Cloud or you’ve only used one or two services, it can feel like there are a lot of moving parts. The good news: Google Cloud’s data stack is opinionated, integrated and battle-tested. This post maps the landscape so you can pick the right tools for ingestion, storage, processing, orchestration, governance, and analytics without getting lost in product sprawl.

Sep 27, 2025

From Legacy to Leading Edge: The Case for CloudSQL on Google Cloud

Modern businesses are under constant pressure to lower costs, boost performance, and stay agile in a rapidly changing environment. Traditional, on-premise databases—though dependable—struggle to scale and adapt to these new demands. CloudSQL on Google Cloud offers a powerful solution, enabling enterprises to leave legacy systems behind and embrace a flexible, cloud-native future.

Sep 19, 2025

Don’t Let PostgreSQL Kill Itself: A Guide to Transaction ID Wraparound

PostgreSQL transaction ID wraparound isn’t a hypothetical edge case. It’s one of the few issues that will bring your database to a complete halt. If wraparound protection fails, Postgres will shut down with the message:

Sep 04, 2025

Supercharge Your Real-Time Dashboards: The Power of Dynamic Filtered Indexes in SQL Server

Many businesses rely on real-time dashboards to monitor critical metrics, but these dashboards often struggle with performance, especially when dealing with large datasets and "last day" or "last week" aggregations.

Jul 24, 2025

SQL Server: How to Improve Multi-Threaded Inserts on Frequently-Accessed Tables

One of them is a very suffessful Ecommerce that persists the shopping carts (not in cookie) and has millions of users storing in the cart products, shopping between 8AM to 10AM massively.

Feb 20, 2020

The Dynamic Filtered Indexes

I have struggled with one client on queries that were dealing with date ranges or type ranges or many filters, on very large tables with low density in many cases, and you knew one index would really improves it but it was based on some filter that was undeterministic.

Feb 20, 2020

How to Monitor Your SQL Server Jobs

When the company’s organization become large and production database servers have hundreds of jobs running with different schedule, the DBA might lose track of what job must be run successfully and in a timely matter.

Jan 28, 2020

SQL Transaction Management With JSON Input Parameter and Nested Stored Procedures on SQL Server

This article is aimed to introduce SQL developers to the management of sql transaction with the context of json parameters and nested stored procedures.

Jan 28, 2020

Moving Files and Subfolders Using PowerShell

We usually come across situations where we need to move files and folders to another directory say for archival or some other purpose.

Jan 28, 2020

The Importance of Protecting Your Data: Introduction and Focus on the Rebase Server Solution

Many organizations are now facing with a lot of compliance regulations, from SOCII to PCI, GDPR to KYC compliance and many audits are done to understand how they protect their data from external hacking but also internal employees.

Dec 14, 2019

SQL Server: Use of Views and Filtered Indexes

I have been working lately with several companies, within Ecommerce, telecommunications and payments industries and they all had a team that needed to work on looking at last week or last month invoicing and ordering from clients.

Feb 13, 2019

SQL Server: Purging Data Using Switch Out

On very large database tables, most of my clients have decided to archive the data by extracting them first and then purging old data based on a Date column using something like :

Nov 04, 2018

Clustered Columstore and Nonclustered Filtered Indexes

With a client, I have implemented a clustered columstore index on a table with the default compression and one nonclustered b-tree index.

Oct 13, 2018

Should You Shard or Centralize Your Database ?

Nowadays, business tends to get very big database very quickly and they usually need to find ways to manage functionally and physically data in a more efficient matter, both for security and performance reasons.

Sep 07, 2018

Rolling Snapshot DBS Setup to Correct Quickly Large Errors on Production

You might have wondered if there was a solution that could keep a version of your database in case you/a process made a huge mistake (large update without the where for example) on a production database.

Jul 08, 2018

Phase 2: AE and Search Patterns

This time, I implemented the same code but with encryption and hashing, encryption with a symetric key for the email addresses and hashing for the dictionary.

Jul 04, 2018

SQL Server: Indexed Views and Filtered Indexes: Making Your Very Large Database Smaller

For many clients, I have been able to manage very complex tuning with indexed views and filtered indexes.

Jul 01, 2018

Phase 1: AE and Search Patterns

As I was saying in an earlier article, Always Encrypted is a key element of the GDPR compliance implementation: how to encrypt and be able to search the personal data.

Jul 01, 2018

Data vs Database management

I wrote this article a few years ago nothing a change in paradigm where data was more important than database.

Jan 01, 2018