INSIDE-SQL Discounts Available

[Reposting of the annoucement on http://insidesql.co.uk] T-7 Weeks – 7 attendees can grab a Monster discount SQL Usergroups After attending not 1 but 2 SQL Usergroups yesterday evening (London), where I enjoyed discussing the various aspects of INSIDE-SQL conference with some attendees and both events, the discussion did turned to the current discount promotions currently running. So I said […]

INSIDE-SQL – Why run a conference

Hello Most will know that I have been running Usergroup events on SQL Server / Data Platform for a few years now, the last couple of them as the leader of the PASS London Chapter http://sqllondon.sqlpass.org/  these events are held in the evening’s and usually consist of 1 or 2 presentations from different presenters across the spectrum of Data Platform topics. We now […]

.Net 4.6.1 and MultiSubnetFailover

Im not a big clustering/HA expert, but I obviously understand the need for such things to exist However, the standard SQL tooling, SSMS etc, seems to go out of its way to make the MultiSubNetFailover option as inaccessible and convoluted as possible.  Quite why this option even exists and its not done as default escapes me, […]

A journey to a movie recommender in U-SQL

I haven’t gotten to involved in the whole “Big Data” movement to much,  I’ve kept an arms length watch and played around with a few of those technologies but never really jumped in and got down and dirty.  However, with the public preview of Azure Data Lake, I thought that it was probably time to […]

A first look at SQL Server 2016–String_split

I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO, has been missing.  That is grouped string concatenation (ie forming a delimited string ) and string split ( breaking up a delimited string).  When I say missing, I really mean some form of succinct […]

My favourite wait state– ASYNC_NETWORK_IO

Sometimes it does feel that a problem is a database problem until proven otherwise.  When this does occur I have had to put a lot of time and effort into demonstrating the hows and whys.  One of the easiest ( and most common ) scenarios of this is related to ASYNC_NETWORK_IO waits. Simply put ASYNC_NETWORK_IO […]

Using PowerBI & MAP Toolkit & to review your SQL Server Environments

  This is a posting for T-SQL Tuesday #75 As the SQL Server & BI Consulting Practice lead in a Tier-1 managed Microsoft Partner consulting company www.Northdoor.co.uk , my role often involves me discussing our customer’s SQL Server environment, perhaps they are considering an upcoming version migration or need to perform some consolidations, maybe they […]

SQL Saturday 496 Exeter – PreCon Agenda

Hi Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like to thank the team though for selecting my pre-con.  Let me know if you would have liked to attend and if a viable option, I would be more than happy to still give the session […]

SQL From South West to Scotland : SQLSaturdays #496 & #502

I’m happy, honoured and humbled to be able to say that I will be presenting pre-cons and both SQL Saturday 496 in Exeter and SQL Saturday 502 in Edinburgh. SQL Saturday 496 Exeter is on Friday 11th March and Saturday 12th March The event home page is here and signup to my class is : http://sqlsatexeter.azurewebsites.net/?page_id=5561 […]

A first look at Redgate Reference Data Manager

Over the past few years one of the big drives and innovations in the SQL Server world, has been to bring database schema changes into a full ALM (Application Lifecycle Maintenance Methodology).  There are many competing products in this space, but all of them ( well, that I know of )  only solve database schema change problems.  […]