SQL Server Migration
Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.
The Challenge of Failure and of Being Unwired
About to embark on a vacation, Steve talks about the difficulty in letting go.
Segment Data into Deciles
This short article shows a simple example of how to segment data into deciles
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.
SQL Server Reporting Services Rest API
What functionality is available in the SQL Server Reporting Services REST API and how should you use it?
ETL Performance Auditing - Part 1: Introduction to ETL Auditing
This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.
Setting Permissions to Drop a Database
Learn which permissions are required to drop a database and see a test to show that these apply.
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 Kelapa Gading Raya CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Boulevard Raya No.1 Blok L, Klp. Gading Tim., Kec. Klp....
BCA KCP Menara Thamrin TLP/WA 08216977701
Menara Thamrin, Jl. MH Thamrin No.Kav. 3 Lantai 1 Ruang 106, Kb. Sirih, Kec....
BCA KCP Reg.Tanah Abang TLP/WA 08218573837
Ps. Regional Tanah Abang, Blok F, Lt. Dasar, Kp. Bali, Kecamatan Tanah Abang, Kota...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers