Don’t Underestimate the Importance of Good Co-workers
It is important to have people that do good work and are good to work with.
Key Lookups and ColumnStore Indexes
Erik figures out why SQL Server really doesn't like combining these two things in a query plan.
The Cloud is Better In At Least One Way
Azure SQL Database has a lot of integrity checks. Probably more than your local instance.
Timing is Everything
Phil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.
The Power of Python and SQL Server 2017
Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL Server, but it can be used for far more than this, with any Python libraries or Frameworks. To provide an example of what is possible, Hitendra shows how to use the feature securely to provide intelligent application caching, where SQL Server can automatically indicate when data changes to trigger a cache refresh.
A Lightweight, Self-adjusting, Baseline-less Data Monitor
Can data alert us that something is going on, without baselines and thresholds?
The Blame Game
Equifax is blaming a single IT person for their data breach. Steve Jones worries this is a sign of things to come.
Statistics in SQL: Student’s t-test
Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test suitable for students. In fact it was William Sealy Gosset, an Englishman publishing under the pseudonym Student, who developed the t-test and t distribution in 1908, as a way of making confident predictions from small sample sizes of normally-distributed variables. As Gosset's employer was Guinness, the brewer, Phil Factor takes a sober view of calculating it in SQL.
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 Angke TLP/WA 08216977701
Jl. Pangeran Tubagus Angke No.37, Jemb. Lima, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
BCA KCU Karawang CSTelpon : 0853-73737551
Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Jl. Panatayuda I No.37, Nagasari, Kec. Karawang...
BCA KCU GREEN GARDEN TLP/WA 08216366654
Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec. Kb....
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