Who did what to my database and when…

One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table, truncated a table, dropped a procedure….” etc.   Im sure we have all been there,  something changes ( maybe schema or data ) and we have no way of telling who did it and […]

Why is creating excel sheets from SSIS so hard ?

If there is one process that should be simpler than it is out of the box, it is creating Excel spreadsheets from SSIS.   Over the years i’ve tried doing it a number of ways, using the built in component,  Interop , OLE DB etc all suck to one degree or another.  Either unreliable or […]

Experience Innovative Online Hands-on SQL Server Learning via YouTube

  We would like to introduce you to the first Online Hands-on Learning available for SQL Server. Learn SQL Server Internals and practice the hands-on examples shown in the YouTube videos right away – LIVE – while watching! No bulky VMs to download, SQLTest tool simulates the hands-on labs for you! No registration necessary. Here […]

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 […]

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 […]