Azure Data Lake Analytics using U-SQL Queries
This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.
How Perfect Should Our Software Be?
Steve talks about the level of engineering effort we need in software development.
Learning about DML Triggers
Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.
GDPR - A guide for the perplexed
If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?
We Want Maturity, But Is It Fun?
Today we have a guest editorial from Andy Warren as Steve is away on vacation. This was originally published on Dec 23, 2014. I was reflecting recently on my first real IT job. It was a small-ish company when I joined it, perhaps a hundred employees or so, and still using a mishmash of software […]
You Need Offline Backups
Steve talks about the need to be careful with backups in this age of malicious attackers.
Using the DAX Calculate and Values Functions
In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.
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 Mal Taman Anggrek TLP/WA 08216977701
Jl. Letjen S. Parman No.Kav. 21 Lahan Bawah. C 07, Slipi, Kec. Grogol petamburan,...
Cara mengatasi saldo tertahan/pending di KlikBCA
Cara mengatasi saldo tertahan/pending di KlikBCA cukup menghubungi nomor resmi KlikBCA di 08213111109 dan...
BCA KCP Ruko Swadaya TLP/WA 08216977701
Jl. Swadaya Raya No.39 Ruko Swadaya City Square Blok 1.11-23, Kec. Grogol petamburan, Daerah...
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