2017-03-21 (first published: 2017-03-15)
460 reads
SQL
2017-03-07 (first published: 2017-03-01)
1,207 reads
2017-02-28
11,196 reads
Azure DWH part 1:Common questions about Azure SQL Data Warehouse
This article compiles some common questions and answers about Azure SQL Data Warehouse.
2016-12-28
9,221 reads
Data Mining Part 37: The Data Mining query transformation task
This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task
2016-04-14
2,478 reads
Extracting string after and before a Character/Pattern
Finding characters/string before and after some character or pattern
2017-01-06 (first published: 2015-11-09)
249,286 reads
SQL Explained
A short explanation and infographic of what SQL is. For the non-SQL people in your life.
2015-07-24
8,743 reads
10 SQL Snippets For Faster, More Effective Code
How many hours per week do you spend writing the same SQL again and again?
2015-07-16
9,449 reads
2015-06-23
2,047 reads
Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
2015-03-16
6,665 reads
Blogs
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Monday Monitor Tips: Using the PowerShell API
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
Forums
Sparse Column Defaults
Comments posted to this topic are about the item Sparse Column Defaults
The AI Budget Assistant
Comments posted to this topic are about the item The AI Budget Assistant
Why Standards are Important
Comments posted to this topic are about the item Why Standards are Important
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers