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
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Abdul Muis Telpon. 083135766741
WhatsApp 083135766741 Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101,...
BCA KCP Siantan Telp:Cs.083831618816
WhatsApp:083831618816 Jl. Khatulistiwa No.16, Siantan Hilir, Kec. Pontianak Utara, Kota Pontianak, Kalimantan Barat 78242
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers