Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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… Read more

0 comments, 2,462 reads

Posted in Dave Ballantynes blog on 22 August 2016

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… Read more

0 comments, 1,070 reads

Posted in Dave Ballantynes blog on 17 June 2016

.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… Read more

0 comments, 302 reads

Posted in Dave Ballantynes blog on 24 March 2016

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… Read more

0 comments, 1,538 reads

Posted in Dave Ballantynes blog on 20 March 2016

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… Read more

0 comments, 289 reads

Posted in Dave Ballantynes blog on 13 March 2016

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… Read more

4 comments, 1,877 reads

Posted in Dave Ballantynes blog on 28 February 2016

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… Read more

0 comments, 255 reads

Posted in Dave Ballantynes blog on 14 February 2016

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… Read more

0 comments, 209 reads

Posted in Dave Ballantynes blog on 17 January 2016

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… Read more

0 comments, 126 reads

Posted in Dave Ballantynes blog on 5 January 2016

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 to say that on Friday 5th December i will be presenting a day long pre-con on Query Processing and internals at SQL Saturday 467 in Southampton.

We will be spending…

Read more

0 comments, 252 reads

Posted in Dave Ballantynes blog on 4 October 2015

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 to say that on Friday 5th December i will be presenting a day long pre-con on Query Processing and internals at SQL Saturday 467 in Southampton.

We will be spending… Read more

0 comments, 97 reads

Posted in Dave Ballantynes blog on 4 October 2015

Getting out of the ground with TSQL Smells.

 

At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project for static code analysis of SQL Code. The general opinion was that although the concept was sound, the process of getting it running ( and developing it further )… Read more

2 comments, 185 reads

Posted in Dave Ballantynes blog on 23 March 2015

Increasing ColumnStore compression ratio for archival and “Cold storage”

At my present client, part of the task I have to under take is to re-engineer the “Cold Storage”. This is ~20Terabytes of compressed CSVs going back over 15 years or so. Presently these are held on aging and creaking centera servers that are way past end of life. The… Read more

2 comments, 115 reads

Posted in Dave Ballantynes blog on 17 March 2015

SQLBits, Incremental Statistics and Demo Fail

So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such a great event. It’s always a pleasure and honour to be able to present here and to get to spend time with a great crowd of intelligent SQL Geeks.

I… Read more

0 comments, 111 reads

Posted in Dave Ballantynes blog on 8 March 2015

Non use of persisted data – Part Three

A long time ago I looked at some reasons as to why persisted computed columns ( and therefore indexes on those columns) are not used (Part1, Part2).
Recently I was drawn into an issue where the same thing was happening, a persisted computed column had been created… Read more

0 comments, 95 reads

Posted in Dave Ballantynes blog on 2 November 2014

Please please tell me now…

.. Is there something I should know,  sang Duran Duran many moons ago when I was young and before I knew that query optimization was even a thing.  But,  it is quite a handy little line to keep in mind when you are tuning queries,  giving SQL server a little… Read more

0 comments, 100 reads

Posted in Dave Ballantynes blog on 15 August 2014

Reasons why your plans suck : No 56,536

I have been working with SQL server for more years than I really care to mention and like to think that I am now quite comfortable with the internals, specifically the Query Optimizer. Every so often though a new problem gets thrown into the mix, just to keep me on… Read more

0 comments, 111 reads

Posted in Dave Ballantynes blog on 12 April 2014

T4 Support in SSDT

Sometimes a piece of technology passes you by completely, T4 templating happens to have done that for me.  On tuesday night, at SQL Supper, Geoff Clark ( a uk MCM ) (t) done a fantastic presentation on end-to-end datawarehouse loading, a portion of this was on t4… Read more

0 comments, 244 reads

Posted in Dave Ballantynes blog on 29 March 2014

Whats This Command Bar ?

One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out exactly what the names of the Command Bar objects internal to Visual Studio were.

Most of the advice on the internet is fairly haphazard ie guess/trial and error, but… Read more

0 comments, 85 reads

Posted in Dave Ballantynes blog on 13 March 2014

On the move

Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find a new home.

From now on (along with a few others of the UK SQL Server community) I shall be blogging on dataidol.com.  My page will be at http://dataidol.com/davebally ,… Read more

1 comments, 386 reads

Posted in Dave Ballantynes blog on 14 April 2013

Older posts