↓
 

The Intransigent Data Blog

Getting data to toe the line

The Intransigent Data Blog
The Intransigent Data Blog
  • Home
  • About this Blog
  • Links
  • Toolset
Home 1 2 3 … 5 6 >>

Post navigation

← Older posts

Alternatives to the (slow) FORMAT function

The Intransigent Data Blog Posted on 16/01/2022 by Andrew Ing26/02/2022
stopwatch in a hand

At first sight the FORMAT function introduced in SQL Server 2016 looks like a useful addition. It allows freedom in formatting dates and numbers using C#-style format strings  along with locale awareness.  Although formatting is strictly the preserve of the … Continue reading →

Posted in T-SQL

Disable non-clustered indexes during data load

The Intransigent Data Blog Posted on 24/06/2021 by Andrew Ing14/07/2021

Indexes slow down INSERTS into SQL Server tables, especially in Azure SQL where bulk logged inserts are not available. This procedure can disable and then rebuild all non-clustered indexes on one specified table.  Disabling non-clustered indexes is a zero cost … Continue reading →

Posted in Data Warehouse, T-SQL

Script the creation of ODBC DSNs

The Intransigent Data Blog Posted on 03/05/2021 by adminUsr16/05/2021

Automate the creation of ODBC data source names (DSNs) with a PowerShell script. The aim of this script is to apply a complete set of DSNs on a server, regardless of the previous state.  The script begins by deleting existing … Continue reading →

Posted in Automation, Data Warehouse

DAX: partitioned conditional aggregations

The Intransigent Data Blog Posted on 23/08/2020 by Andrew Ing23/08/2020

We want to find how often customers are behind in their payments or calculate their average debt when they are in debt.  The question might be How many customer-months of debt am I experiencing (counting 1 for each month that … Continue reading →

Posted in DAX

Referential integrity checks

The Intransigent Data Blog Posted on 18/08/2020 by Andrew Ing18/08/2020

This script is aimed at data warehouse relational databases which don’t have foreign key constraints.  Using column names it matches key column values between fact and dimension tables to identify orphans.

Continue reading →
Posted in Data Warehouse, T-SQL

Understanding errors from Tabular Analysis Services

The Intransigent Data Blog Posted on 21/06/2020 by adminUsr18/08/2020

Despite its many advantages Tabular Analysis Services represents a step backwards in developer experience, particularly in the feedback following an exception. This is a short list of some of the more head-scratching error messages that occur when processing a Tabular … Continue reading →

Posted in SSAS

Error flows in Azure Data Factory

The Intransigent Data Blog Posted on 29/12/2019 by Andrew Ing29/12/2019

Azure data factory pipelines consist of activities that are controlled for execution precedence and flow by constructs similar to SSIS precedence constraints.     However, unlike SSIS, ADF has no error event  that can be given pipeline-wide scope which is … Continue reading →

Posted in Azure Data Factory

The effect of RAID cache backup battery failure

The Intransigent Data Blog Posted on 20/03/2019 by Andrew Ing20/03/2019

RAID write times are improved by writing to a cache.   This is a quick operation, the calling program can get on with its business, and the RAID controller can solidify the cached changes to disk(s) in its own time.  The … Continue reading →

Posted in DBA

Maintenance – Record Deletion

The Intransigent Data Blog Posted on 11/02/2019 by Andrew Ing14/07/2019

A simple framework for implementing a time-framed record deletion policy: deleting records that are older than a certain threshold. Consists of a logging table and a stored procedure which deletes the records.   The procedure deletes rows in batches and provides … Continue reading →

Posted in T-SQL

HTTP Access to Analysis Services (multidimensional)

The Intransigent Data Blog Posted on 04/12/2018 by Andrew Ing21/06/2020

In retrospect this was a simple task: the steps set out in the invaluable video Configuring HTTP for SSAS  all work.  However, in the middle of a long process trying to get it to work the first time it seems … Continue reading →

Posted in SSAS | Tagged SSAS

Post navigation

← Older posts

Recent Posts

  • Alternatives to the (slow) FORMAT function
  • Disable non-clustered indexes during data load
  • Script the creation of ODBC DSNs
  • DAX: partitioned conditional aggregations
  • Referential integrity checks
  • Understanding errors from Tabular Analysis Services
  • Error flows in Azure Data Factory
  • The effect of RAID cache backup battery failure

Pages

  • About this Blog
  • Links
  • Toolset

Categories

  • ASP.Net
  • Automation
  • Azure Data Factory
  • Data Warehouse
  • DAX
  • DBA
  • IIS
  • MDS
  • MDX
  • Permissions
  • SSAS
  • SSIS
  • SSRS
  • T-SQL
  • Uncategorized
  • VBA

Archives

  • January 2022 (1)
  • June 2021 (1)
  • May 2021 (1)
  • August 2020 (2)
  • June 2020 (1)
  • December 2019 (1)
  • March 2019 (1)
  • February 2019 (1)
  • December 2018 (1)
  • November 2018 (1)
  • August 2018 (1)
  • April 2018 (1)
  • October 2017 (1)
  • April 2017 (1)
  • January 2017 (2)
  • November 2016 (1)
  • September 2016 (1)
  • May 2016 (2)
  • April 2016 (1)
  • March 2016 (1)
  • February 2016 (2)
  • December 2015 (3)
  • October 2015 (1)
  • July 2015 (1)
  • May 2015 (1)
  • April 2015 (2)
  • February 2015 (1)
  • January 2015 (1)
  • December 2014 (1)
  • October 2014 (2)
  • September 2014 (2)
  • August 2014 (2)
  • July 2014 (3)
  • June 2014 (2)
  • May 2014 (2)
  • April 2014 (1)
  • March 2014 (1)
  • January 2014 (1)
  • December 2013 (5)

Tags

Blog Convention SQL-Pattern SSAS SSIS SSRS T-SQL Validation

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2022 - The Intransigent Data Blog - Weaver Xtreme Theme
↑