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,...
2016-08-30 (first published: 2016-08-22)
2,804 reads
Dave Ballantynes blog
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...
2016-06-17
1,402 reads
.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...
2016-03-24
935 reads
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...
2016-03-23 (first published: 2016-03-20)
1,816 reads
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,...
2016-03-13
580 reads
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...
2016-03-03 (first published: 2016-02-28)
2,747 reads
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...
2016-02-14
476 reads
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...
2016-01-17
379 reads
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...
2016-01-05
409 reads
SQL Saturday 467 - Precon - Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
439 reads
Blogs
SQL Server on Kubernetes Book Published!
I’m super proud to announce that Ben E. Weissman and I have published SQL...
Gathering More Digital Data with Tile Slim
By Steve Jones
After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...
Accessibility is not just about slides
Although I don’t write about it much on this website, I am on the...
Forums
Nested Join Alternative
Is there a better way to write this nested join query? I'm concerned about...
How to determine whether SSIS is being used?
Hello I've inherited some dev environment which looks like was abandoned, but I'd like...
xml output from sql query
The script runs but gives me "no data to export" I see data in...
Ask SSC