Skip to content

Proud Salopian

A Late Developer

  • Technical
  • Humour
    • Political
    • General
    • Code Humour
  • Writing
  • Life, The Universe and Everything
  • Music
Proud Salopian

Category: TSQL

Cannot Restore Database from SQL Server Backup

16 December 2019 The Proud Salopian Database, SQL, SqlServer, Technical, TSQL

This is one of those, very short, very focused blogs that actually first got me into blogging. It was a

Continue reading

Generating Large XML Data Files

2 December 2019 The Proud Salopian Database, SQL, Technical, TSQL, xml

Just recently I needed some large example XML data files to prepare for some blog content. Now, I thought it

Continue reading

Rank and File…

18 September 2017 The Proud Salopian SQL, SqlServer, Technical, TSQL

Just recently I was asked to make some changes to an existing data warehouse, we needed to add Tender data

Continue reading

Upsert [sic] with SAP Data Services? Don’t cry though….

9 January 2017 The Proud Salopian Dimensional Database, ETL, SQL, SqlServer, Technical, Transformations, TSQL One comment

So, recently I find myself heavily involved with SAP Data ServicesĀ and data migrations, I know what you’re thinking… thats not

Continue reading

Man of Distinct(ion)

9 October 2015 The Proud Salopian Database, Distinct, SQL, Technical, TSQL

Its not often that I learn something new about the fundamentals of SQL. Sure they add to the syntax all

Continue reading

Grouping multiline SQL data using XML

17 June 2015 The Proud Salopian Database, Hack, SQL, Technical, TSQL

A friend of mine recently asked for help with a bit of SQL he was working on. True, he was

Continue reading

Improve Readability using ROW_NUMBER()

3 June 2015 The Proud Salopian Database, PARTITION, SQL, SqlServer, Technical, TSQL

What did I ever do without the TSQL Row_Number() functionality. I do remember way back in days of yore (when

Continue reading

Recent Posts

  • Short Primer – using Map Operation In SAP Data Services
  • Adding EWS ConnectivIty to your .NET Service Application
  • Lay Our Foundations
  • Leave Me Unattended
  • You Give Me Security

Recent Comments

  • Adding EWS ConnectivIty to your .NET Service Application – Proud Salopian on Leave Me Unattended
  • Adding EWS ConnectivIty to your .NET Service Application – Proud Salopian on Lay Our Foundations
  • Leave Me Unattended – Proud Salopian on You Give Me Security
  • Leave Me Unattended – Proud Salopian on Lay Our Foundations
  • Lay Our FOundations – Proud Salopian on Leave Me Unattended

Archives

  • February 2023
  • April 2022
  • October 2021
  • February 2021
  • December 2020
  • October 2020
  • September 2020
  • February 2020
  • January 2020
  • December 2019
  • October 2019
  • January 2019
  • February 2018
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • March 2017
  • February 2017
  • January 2017
  • October 2016
  • August 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • November 2015
  • October 2015
  • August 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • October 2014
  • August 2014
  • July 2014
  • June 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • August 2013
  • June 2013
  • May 2013
  • April 2013
  • February 2013
  • December 2012
  • November 2012
  • September 2011
  • August 2011

Categories

  • .NET
  • Active Directory
  • Azure
  • Bing
  • Censorship
  • Chrome
  • Code Humour
  • Data Services
  • Database
  • Delegation
  • Dirk Gently
  • Email
  • EWS
  • Flow
  • Google
  • Life
  • Life, The Universe and Everything
  • Life's Good
  • SPN
  • Technical
  • Uncategorised
  • Visual Studio
  • Web
  • Windows Authentication
  • Writing

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
WordPress Theme: Tortuga by ThemeZee.