Use cases of various products for a big data cloud solution
There are a tremendous amount of Microsoft products that are cloud-based for building big data solutions. It’s great that there...
2017-10-11
2,431 reads
Database Fundamentals #13: Data Entry Through T-SQL
T-SQL provides lots of functions that help to make data entry through T-SQL much more powerful. Over time you won’t...
2017-10-23 (first published: 2017-10-11)
1,889 reads
What's new in SQL 2017
SQL Server 2017 became General Availability (GA) on 10/2, I've been sharing through the different social media channels the different...
2017-10-11
194 reads
Azure SQL Database Level Firewall Rules
I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...
2017-10-20 (first published: 2017-10-11)
1,724 reads
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into...
2017-10-11
432 reads
Why I Go to Summit Each Year?
This year will be my 6thPASS Summit that I will have attended. Some people have asked me why I still...
2017-10-11
330 reads
Identity_Cache feature introduced in SQL Server 2017
Hello friends, Please find the full article at this link – https://social.technet.microsoft.com/wiki/contents/articles/40666.sql-server-identity-cache-feature-in-sql-server-2017.aspx
2017-10-11
500 reads
SQL Server Temporal Tables
Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level...
2017-10-19 (first published: 2017-10-11)
2,108 reads
Avoid “Constants” in T-SQL
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2017-10-19 (first published: 2017-10-10)
3,688 reads
How NOLOCK Will Block Your Queries
Photo by James Sutton on UnsplashNote: the problem described below applies to all SELECT queries, not just those adorned with NOLOCK...
2017-10-10
403 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