↓
 

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→Published 2013 → December

Monthly Archives: December 2013

Column Naming Conventions

The Intransigent Data Blog Posted on 29/12/2013 by Andrew Ing23/06/2015

Column Naming Convention I like lower case with underscores:  company_id,  first_name, telephone_nbr, booking_ref This is Uncle Joe Celko’s convention as stated in SQL Programming Style (Morgan Kaufmann, 2005), and I accept his justification that Invoices.invoice_nbr  is more readable than Invoices.InvoiceNbr in a dense melee of … Continue reading →

Posted in Uncategorized | Tagged Convention

Making Email Address Columns Behave

The Intransigent Data Blog Posted on 28/12/2013 by Andrew Ing12/02/2019

It’s a familiar situation: your email address columns contain phone numbers, important notes, credit card details…  It’s not a problem until you want to use the addresses in bulk – such as for a mailshot – and by that time … Continue reading →

Posted in T-SQL | Tagged Validation

Error Handler for T-SQL

The Intransigent Data Blog Posted on 28/12/2013 by Andrew Ing11/10/2020

This is the error handler created E. Sommarskog, with some slight alterations by me.  See http://www.sommarskog.se/error-handling-I.html. ERROR_HandleCaughtError stored procedure This is  ES’s error handler in a form that suits me: I usually want to add some additional information to aid … Continue reading →

Posted in T-SQL | Tagged SQL-Pattern, T-SQL

Syntax Formatting for blogs

The Intransigent Data Blog Posted on 27/12/2013 by Andrew Ing28/12/2013

I imagine that it’s a well trodden path seeking out a satisfactory code or syntax highlighter for wordpress. You can, just about, paste colour-formatted code from some editors into the wp text editor  (e.g. SSMS to Outlook Email to WordPress), … Continue reading →

Posted in Uncategorized | Tagged Blog

Conversion to INT failed where no conversion expected

The Intransigent Data Blog Posted on 27/12/2013 by Andrew Ing12/04/2018

I have twice now been wrong-footed by this SQL Server error message: “Microsoft SQL Server Native Client 10.0” Hresult: 0x80040E07 Description: “Conversion failed when converting the varchar value ‘abcd123’ to data type int.”. The statement causing this distress was: ISNULL(View1.long_name, View1.short_name) AS output_column … Continue reading →

Posted in T-SQL | Tagged SQL-Pattern, T-SQL

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
↑