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
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers