How implicit data type conversion slows down your query
Implicit data type conversion is one of those things you hardly think about or notice when writing your queries. But...
2013-08-08
1,494 reads
Best Practices to Deliver BI Solutions
If your company is planning to build a data warehouse or BI solution (see Why you need Business Intelligence), you need...
2013-08-08
1,532 reads
Survey: Are you a SQL Server Professional and running on Mac?
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
I know a...
2013-08-08
1,157 reads
Share Your Ideas for Improving PASS on September 9th (Suggestion Tsunami!)
My friend Aaron Nelson was in Florida recently for SQLSaturday #231 and we always find a few minutes to catch...
2013-09-06 (first published: 2013-08-08)
1,030 reads
Connecting to the Hortonworks Sandbox v1.3 through IP 192.168.56.101
I recently downloaded the Hortonworks Sandbox v1.3 Hyper-V VM and had a hard time connecting to the included web interface...
2013-08-08
1,669 reads
Extracting Data From Multiple Files with Power Query
In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time...
2013-08-08
972 reads
Normalisation
The purpose of normalisation is to remove redundancy and prevent conflict. 1st Normal Form (1NF) – Every field can have only...
2013-08-07
556 reads
How are COALESCE and ISNULL different?
At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...
2013-08-16 (first published: 2013-08-07)
8,919 reads
SQL Training – Introduction to SQL Server Data Tools
Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...
2013-08-07
861 reads
SQL Training – Introduction to SQL Server Data Tools
Introduction
This document will provide a basic understanding on SQL Server Data Tools (SSDT) and its integration into Visual Studio 2012...
2013-08-07
6,066 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 Tmn. Harapan Indah Telp:0821°8200°233
Telp/Wa 628218200233 Komp. Taman Harapan Indah Blok EE No.1, RT.14/RW.7, Jelambar Baru, Kec. Grogol...
Alamat BCA KCP Rajawali Telp:0821°8200°203
Telp/WA 628218200203 Rukan Multiguna, Jl. Rajawali Selatan Raya Blok C5. 2, Blok 2, Pademangan...
Alamat BCA KCP Mangga Dua Mal Telp:0821°7555°651
Telp/Wa 628217555651 Mal No. RM, Jl. Mangga Dua Raya No.49, RT.1/RW.12, Mangga Dua Sel.,...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers