Understanding Windows Server Cluster Quorum Options
If you're deploying SQL Server, you are likely running business-critical applications on it and you need to ensure it's protected from downtime and data loss.
2023-01-18
Additional Articles
Bucket Sort Algorithm in Python to Sort a List of Array Values
Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.
2023-01-16
How to Find Missing Rows in a Table
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table:
2023-01-16
Database Sharding to help Improve Performance and Maintenance Tasks
In this article, we will review the benefits and drawbacks of using database partitioning (sharding) to help improve performance and maintenance tasks.
2023-01-13
How to Create a Box and Whisker Plot in Power BI Desktop
In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.
2023-01-13
Subqueries in MySQL
A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.
2023-01-11
Useful Commands for Snowflake Transactions
In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions.
2023-01-11
Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools
In this tip, we guide you through the setup of Azure Synapse Link so you can query Azure Cosmos DB data with the Synapse Serverless.
2023-01-09
Converting Data Across Time Zones: An In-Depth Primer
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t we? While some software applications can live in an ecosystem where all dates and times can be stored in a single time zone with no conversions needed, many cannot.
2023-01-09
Cross-RDBMS Code Quality Reports in Flyway
This article demonstrates how to run basic cross-RDBMS code quality checks using SQL Fluff. We analyze the results in PowerShell to produce reports and analytics on the number or types of issues found.
2023-01-06
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
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
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