Log Files from Different Sources
While working with Extended Events, or with any sort of logging or tracing utility, it becomes critical to consume the data from disparate sources or even to consume the...
2015-12-30
17 reads
Blog Posts
SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.
Hi Guys,
When you generate a script to create a Stored Procedure, below three statements are generate by default.
SET ANSI_NULLS on
SET NOCOUNT on
SET...
2015-12-30 (first published: 2015-12-17)
10,297 reads
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
219 reads
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
1,217 reads
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
211 reads
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and when you use SSDT or the compare / merge...
2015-12-30
14 reads
Could not Register Service Principal Name
Have you ever seen the error below in your SQL Server log shortly after startup? You’ll actually see two of...
2015-12-29 (first published: 2015-12-17)
1,577 reads
Happy Holidays
It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do...
2015-12-29
797 reads
Slow Running Query? Where do I Begin?
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
499 reads
Slow Running Query? Where do I Begin?
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
1,825 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