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

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, 117 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, 18 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, 145 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, 7 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 ) was… Read more

0 comments, 19 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, 8 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, 9 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, 10 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, 7 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, 9 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, 22 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, 6 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, 281 reads

Posted in Dave Ballantynes blog on 14 April 2013

Sub query pass through

Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided that it is only necessary to process some data under a certain condition.  By way of example, something like this : Create...(read more)

Read more

10 comments, 3,003 reads

Posted in Dave Ballantynes blog on 22 March 2013

SQL Saturday 194

On the weekend of the 9th March 2013, the second SQL Saturday in the UK occurred.  A massive thank you must go to all the sponsors of the event, FusionIO, Confio, Nexus, Purple Frog, Redgate, Idera and Big Bang Data. Additionally big congratulations to Jonathan and Annette Allan, Thomas Rushton… Read more

0 comments, 405 reads

Posted in Dave Ballantynes blog on 12 March 2013

A year of SQL Lunchs

Time does fly, and happy birthday SQL Lunch UK.

It has been a year since the first SQLLunch UK, and over the year there have been 21 Lunchs with a total of 537 attendees.  OK, some of those will be the same people but in ‘conference speak’ each registration counts,… Read more

2 comments, 412 reads

Posted in Dave Ballantynes blog on 17 February 2013

Deploying SSRS artefacts using Powershell ( Simply)

As ive stated in the past,  i’m presently part of a team on an ALM project for a major UK based online retailer.  The aim of this project is to have fully automated app and database code and schema deployment, through development, UAT and finally live.

Most parts of this… Read more

3 comments, 2,286 reads

Posted in Dave Ballantynes blog on 12 February 2013

Photo cataloguer

If you are anything like me, by know you will have a few thousand digital images spread across multiple directories and heaven knows how many of those are duplicates!

Here’s a little powershell script I use to try and keep them in order,  it recursively scans a directory (hardcoded to… Read more

0 comments, 473 reads

Posted in Dave Ballantynes blog on 20 January 2013

Scaling out SQLLunch UK

As you may be aware, I have been running a lunch time user group ‘SQLLunch UK’  having stolen drawn inspiration from Patrick Leblanc (t|b) ’s SQLLunch webcasts.  These however are not traditional webcasts, as although we use remote speakers,  to watch you have to get away… Read more

1 comments, 467 reads

Posted in Dave Ballantynes blog on 11 January 2013

SSDT – TSQL Unit testing in multiple environments

Late in December, one the long awaited portions of functionality inside SSDT was released to an eager public, that being unit testing.  There has been a lot of noise generated about sql unit testing as a concept recently and hopefully you have decided that that is now the way to… Read more

2 comments, 1,108 reads

Posted in Dave Ballantynes blog on 7 January 2013

Older posts