Friday, 26 August 2016

TGI SQL Friday – Weekly round up 26th August 2016

The SQL Server news this week is there is no news!

No this is not the 1930’s BBC.

There are no links here this week because I have been on holiday and not keeping up with latest blogs and articles so I don’t have much to post this Friday.

I have been taking it easy, like Dude the turtle

The regular links post will be back next week. As we approach the end of summer, with the new school term just around the corner the TV here in the UK will soon be X-factor and Strictly Come dancing undoubtedly  there will be lots of interesting projects around the corner. September will be a busy month for me, I have two 534 developing SQL Queries for SQL Server to deliver and some interesting SQL Server Consulting work too.

Signup for my Learning Tree newsletter here to keep to update with the latest SQL Server news

Wednesday, 17 August 2016

Great Value IT Training from @LearningTree #SQLServer - 17th August 2016

This weeks great value IT training deals are in. This being SQL Server blog I would like to draw your attention to the following courses which are great value for £750 plus VAT

535 26-Sep-16 Developing High-Performance SQL Server® Databases
140 11-Oct-16 SQL Server® Reporting Services
532 25-Oct-16 SQL Server Transact-SQL® Programming

The full list of courses offered at £750 is here

1362  05-Sep-16 Power Pivot for Excel®: Mining Data for Business Intelligence
982 14-Sep-16 ITIL® Intermediate: Service Strategy
535 26-Sep-16 Developing High-Performance SQL Server® Databases
2411 04-Oct-16 Windows Server® 2012 Administration
1253 03-Oct-16 Introduction to Data Science for Big Data Analytics
977 11-Oct-16 Building Web Applications with ASP.NET MVC
140 11-Oct-16 SQL Server® Reporting Services
211 19-Oct-16 Business Analysis Introduction: Defining Successful Projects
998 17-Oct-16 ITIL® Intermediate: Service Offerings and Agreements
143 18-Oct-16 Linux® Introduction
532 25-Oct-16 SQL Server Transact-SQL® Programming
906 25-Oct-16 Management Skills for an IT Environment
178 26-Oct-16 PRINCE2® Practitioner and Re-registration Certification
144 25-Oct-16 Linux® Administration and Support
1803 22-Nov-16 Preparing for TOGAF® certification
3633 21-Nov-16 APMG AgilePM® Achieving Foundation & Practitioner Certification

There are some great courses in there at £750 plus VAT. If you are interested in attending any of these courses please email

Tuesday, 16 August 2016

David @postledm is at #SQLSaturday

It is that time of year when the Scandinavia holds its SQL Saturday events and once gain I have been invited to speak

I will be at SQL Saturday Gothenburg ( on 27th August to showcase some of the new features in SQL Server 2016 

I will  then be speaking at SQL Saturday Copenhagen ( September 17th for my most selected talk on Kerberos for the SQL DBA. 

Looking forward to visiting these wonderful cities again. Hope to see you there


Monday, 15 August 2016

What is Enterprise Architecture?

This is an interesting question. Lets look at couple of definitions starting with Wikipedia’s definition

“Enterprise architecture (EA) is "a well-defined practice for conducting enterprise analysis, design, planning, and implementation, using a holistic approach at all times, for the successful development and execution of strategy. Enterprise architecture applies architecture principles and practices to guide organizations through the business, information, process, and technology changes necessary to execute their strategies. These practices utilize the various aspects of an enterprise to identify, motivate, and achieve these changes.”

The Wikipedia definition is actually a quote from Federation of EA Professional Organizations, Common Perspectives on Enterprise Architecture, Architecture and Governance Magazine, Issue 9-4, November 2013 (2013).

ISO/IEC 42010:2007 defines "architecture" as:

"The fundamental organization of a system, embodied in its components, their relationships to each other and the environment, and the principles governing its design and evolution."

TOGAF has two definitions for Enterprise Architecture that incorporates the ISO definition the:

1. A formal description of a system, or a detailed plan of the system at component level to guide its implementation
2. The structure of components, their inter-relationships, and the principles and guidelines governing their design and evolution over time

I like to think of Enterprise Architecture as way of aligning technology to business goals and principals. Analogies to traditional architecture approaches are often used when discussing enterprise architecture. One that I have heard quoted many times is the example you wouldn’t build a house room by room with no idea about how you wanted to the final house to look upon completion. It would end up out control with a very haphazard look and feel to it.

Enterprise architecture is intended to provide you with a design, a view, a model of what your technology and application infrastructure will look like that is designed to meet the purpose of your organisation. 

It important to remember that traditional architecture looks at building physical things. Enterprise Architecture   looks at building virtual things. Both provide a view of how the thing or object will look like after the building/development work has been completed.

Friday, 12 August 2016

TGI SQL Friday – Weekly round up Friday 12 August 2016

This week has seen the launch of my new SQL Server newsletter in conjunction with Learning Tree. If you would like to sign up go to and you’ll start receiving the regular newsletter, keeping you  up to date with the latest news and views in the world of SQL Server

Aside from the newsletter it’s been a busy week of client work -  SQL Server Consulting. Specifically migrating a SQL Server Reporting Services environment to a new version.

Here’s a round-up of the links that have interested me this week. There is some SQL Server and SQL Server 2016 specific links included in the list. There are  links in the list from other technology areas too along with some fun stuff for a Friday.

SQL Server

Other posts

Why Did the Olympic diving pool turn green? I don’t know I’m not sure these guys do either but its quite amusing

Enjoy your weekend and do check out our Great Value IT Training Page for this week’s latest offers.

Wednesday, 10 August 2016

SQL Server Newsletter @LearningTree

As many of you know I have been delivering Learning Tree training courses since way back in 2010. Combing training course delivery along with my other SQL Server consulting work has been very rewarding. Delivering training with Learning Tree are always very enjoyable weeks for me. My main focus in that time with Learning Tree in that time has been on SQL Server training courses.

In that time, I have also been writing about SQL Server here on I have written two SQL Server training courses for  Learning Tree. One course has since retired the other course  SQL Server 2012 Skills upgrade course is still running.  I have also written two books with Packt Publishing:

Well now I will be writing on an additional platform. I will be writing and contributing to Learning Tree’s SQL Server blog and also writing Learning Tree’s SQL Server newsletter. We are still working on the frequency that these will be delivered but we are initially going for a bi-weekly schedule. So signing up you’ll get your newsletter delivered once every two weeks. You can sign up for the newsletter here

The first edition of this newsletter is scheduled to go out tomorrow. Without giving too much away I will be discussing some of the reasons why I think my SQL Server 2012 skills upgrade is course is still running and has not yet been retired despite SQL Server 2016 being launched in June. We’ll be looking at why people are sometimes reluctant to upgrade SQL Servers to the latest version.

I will also be making  contributions to the Learning Tree's  SQL Server blog. If you would like to subscribe to the Learning Tree SQL Server blog the feed is

Learning Tree SQL Server Feed

If you would rather a non-feed url you can read the blog posts here

I'll still be blogging here too, I'm notgoing anywhere and no doubt I'll be posting links to the blogs and articles I write on the Learning Tree site

Tuesday, 9 August 2016

Great Value IT Training 9th August – Automate with PowerShell

It’s that time of the week when the Great Value IT training page gets its weekly update and this week there are some great courses on offer.

One course that  I would like to draw you attention to is 969 Windows PowerShellAutomating Administrative tasks. PowerShell is undoubtedly a very powerful tool in the Microsoft world. It can work with on-premises windows deployments Azure and SQL Server and is undoubtedly a very a useful tool in both system administrators and DBAs toolkit. You can attend the London event starting 13th September either in class at the London Education centre or online via AnyWare for the bargain price of £750 plus VAT

There are some other great courses in the list too for anyone from business analysts, developers and project managers. Drop me an email if you would like to attend any of these events for the bargain price £750 plus VAT

3504 7th September Soft Skills Training for Business Analysis
969 13th September Windows PowerShell: Automating Administrative Tasks
195 19th September Power Excel: Analysing Data to Make Business Decisions
933 20th September Agile Software Development and Modelling 
1905 20th September Python Programming Introduction
468 27th September System and Network Security Introduction
177 3rd October PRINCE2® Achieving Foundation & Practitioner Certification
276 3rd October Project Management Professional (PMP)® Exam Prep
315 11th October Developing User Requirements: The Key to Project Success
177 17th October PRINCE2® Achieving Foundation & Practitioner Certification

Don forget to check out the Great Value IT Training page regularly to find the latest offers

Monday, 8 August 2016

Top 5 books on Enterprise Architecture

My post the top 3 books for becoming TOGAF certified punlished   last week looked at books on preparing for the TOGAF certification. Those books were specific to passing the TOGAF exams. 
What if you wanted to learn about Enterprise Architecture without the focus being on passing a certification exam? 

I like the following books

  1. Enterprise Architecture Principals at Work: Modelling Communication and Analysis -
  2. Architecture Principles: The Cornerstones of Enterprise Architecture -
  3. An Introduction To Enterprise Architecture: Third Edition -
  4. Enterprise Architecture As Strategy: Creating a Foundation for Business Execution - 
  5. Enterprise Architecture - the Eight Fundamental Factors: A practical guide to the eight fundamental factors that are common to all EA approaches and frameworks 

If you have a preference of your own do leave a comment and I’ll add it to the list  

Wednesday, 3 August 2016

Great Value IT Training early August Update

Its that time of the week when get the latest Learning Tree courses that have been available for £750 plus VAT. I'm sure that you will agree that this is great value IT Training

There is something in here for everyone. As a data and SQL Server person I think the SSIS 134 course is great value. I also think the Technical Writing Introduction is a great course too. (I have in fact taught that one before, although I'm not teaching this event)

If you would like to join any of the courses listed below for £750 plus VAT please email

517 Developing Enterprise Java Applications with Spring & Hibernate 4 Days 30th August
319 Technical Writing Introduction 4 days 30th August
1254 Extracting Business Value from Big Data with Pig, Hive & Impala 4 days 6th September
327 C++ Programming Introduction 4 days 6th September
296 Project Management: Skills for Success 4 days 6th September
286 Risk Management for Projects, Programmes and Operations 4 days 6th September
294 Influence Skills: Getting Results without Direct Authority 4 days 13th September
1814  Certified Scrum Product Owner® 2 days 19th September
1610 JQUERY Introduction 4 days 20th September
3505 Introduction to Business Process Improvement (BPI) 3 days  28th September
316 ISTQB Certified Tester: Achieving Foundation Certification 3 days 28th September
134 SQL Server Integration Services 4 days 4th October
447 Introduction to Modelling for Business Analysis 4 Days 4th October
288 Organisational Change Management: Achieving APMG Change Management™ Practitioner 5 Days 10th October

Monday, 1 August 2016

Top 3 books for Becoming TOGAF Certified

I  often get asked what books are useful for preparing for the TOGAF certification exam. The resources are generally from the open group but you can get them from Amazon and other leading book stores:

  1. The Full TOGAF 9.1 document - you can get this document free from the Open Group website 
  2. The TOGAF 9 Foundation Study Guide. This is ideal if you are taking the part 1 foundation paper
  3. The TOGAF 9 Certified Study Guide is an excellent resource for the Part 2 paper.

If you have any resources that you would recommend for preparing for the exam do leave a suggestion in the comments.

Featured post

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database? If you work in a hybrid environment with some databases stored on your on ...