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.

Top 10 Databases for 2019

by Additional Articles

Database Journal

Database

A look at ten top databases fighting for mind-share in 2019.

GDPR - A guide for the perplexed

by David Poole

SQLServerCentral.com

GDPR

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?

by Andy Warren

SQLServerCentral.com

Editorial

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

by Steve Jones

SQLServerCentral.com

Editorial

Steve talks about the need to be careful with backups in this age of malicious attackers.

Using the DAX Calculate and Values Functions

by Additional Articles

SimpleTalk

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.