Secure File Transfer Protocol (SFTP) support for Azure Blob Storage
In this article, we walk through the steps and examples of how to use Secure File Transfer Protocol (SFTP) when working in Azure.
Stairway to SQL Server Replication: Level 2 - The Role of the Distributor
In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.
The End of Year Career Evaluation
Steve lists a few things to think about for an end of year career evaluation.
Converting Data Across Time Zones: An In-Depth Primer
This article dives into all the math required to convert historical times between time zones.
Executing Optional Code in Flyway Callbacks
This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.
Change the Instance Collation by Rebuilding Databases in SQL Server 2017
As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
Building a SQL Computational Framework for MACD Indicators
This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.
The Lock Escalation Threshold – Part 3
The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Krakatau CSTelpon : 0853-73737551
Jl. Gunung Krakatau No.51 F-G, Glugur Darat II, Kec. Medan Tim., Kota Medan, Sumatera...
BCA KCP Niaga Grisenda Telpon/wa.085373737699
BCA KCP Niaga Grisenda Telpon/wa.085373737699.Komplek, Ruko Niaga Grisenda, Jl. Pantai Indah Kapuk Jl. Kapuk...
Alamat Kantor BCA KCU WISMA ASIA Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers