Dave Ballantynes blog

Who did what to my database and when…

• by Dave Ballantyne

• Dave Ballantynes blog

One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table,...

2016-08-30 (first published: 2016-08-22)

2,798 reads

Why is creating excel sheets from SSIS so hard ?

• by Dave Ballantyne

• Dave Ballantynes blog

If there is one process that should be simpler than it is out of the box, it is creating Excel...

2016-06-17

1,391 reads

.Net 4.6.1 and MultiSubnetFailover

• by Dave Ballantyne

• Dave Ballantynes blog

Im not a big clustering/HA expert, but I obviously understand the need for such things to exist
However, the standard...

2016-03-24

840 reads

A journey to a movie recommender in U-SQL

• by Dave Ballantyne

• Dave Ballantynes blog

I haven’t gotten to involved in the whole “Big Data” movement to much,  I’ve kept an arms length watch and...

2016-03-23 (first published: 2016-03-20)

1,814 reads

A first look at SQL Server 2016–String_split

• by Dave Ballantyne

• Dave Ballantynes blog

I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO,...

2016-03-13

577 reads

My favourite wait state– ASYNC_NETWORK_IO

• by Dave Ballantyne

• Dave Ballantynes blog

Sometimes it does feel that a problem is a database problem until proven otherwise.  When this does occur I have...

2016-03-03 (first published: 2016-02-28)

2,564 reads

SQL Saturday 496 Exeter – PreCon Agenda

• by Dave Ballantyne

• Dave Ballantynes blog

Hi
Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like...

2016-02-14

474 reads

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

• by Dave Ballantyne

• Dave Ballantynes blog

I’m happy, honoured and humbled to be able to say that I will be presenting pre-cons and both SQL Saturday...

2016-01-17

377 reads

A first look at Redgate Reference Data Manager

• by Dave Ballantyne

• Dave Ballantynes blog

Over the past few years one of the big drives and innovations in the SQL Server world, has been to bring...

2016-01-05

400 reads

SQL Saturday 467 - Precon - Query processing and internals

• by Dave Ballantyne

• Dave Ballantynes blog

Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...

2015-10-04

436 reads