NEW WEBSITE COMING SOON
Maximise code efficiency and ensure best practices.
Identify, isolate and fix database pain points.
Build secure, scalable and highly resilient data platforms.
Server Health Check
Remove server sprawl. Improve Performance. Reduce Risks
We are a Microsoft Partner and offer support for your database platform, resolving database issues, ensuring high performance and data resilience.
We provide consultancy and guidance for technology reviews and implementors offering clients assurance, technology proof or concepts, fall back support services and outsourced database development projects.
We provide SQL Server skills that can be used alongside your existing development teams. Database design, schema design, T-SQL code and performance tuning are just some of the services we offer.
Its been a good year so far for the SQL Server community in the North West, as we’ve just had SQLBits XV in Liverpool, at which a Liverpool based user group got off the ground too! Next up is SQL Saturday Manchester, returning for a second time after it’s successful launch last year. Venue is[…]
I’m working on a project where we have recently started to use SSDT more and more. One feature I make use of, is Database References [http://schottsql.blogspot.co.uk/2012/10/ssdt-external-database-references.html], and use DACPACs as the source of these references. To keep this simple for the distributed development team and have one version of the truth, I keep the DACPACs[…]
There have been a few posts about SSMS Activity Monitor recently. First Kendra Little (b | t) talked about why she doesn’t like it and then Guy Glanster (b | t) and Matan Yungman (b | t) also discussed the failings of Activity Monitor on their SQL Server Radio podcast – mainly it’s to do[…]
I’ve just finished a few enjoyable days with the great people on SQLRelay. I only managed to get involved with the Newcastle and Leeds events, but it was an amazing experience. The interaction I got at the end of my Leeds session was fantastic – I’ve never had so many questions. Some of the questions I[…]
SQL Conference season is upon us it seems. Unfortunately I don’t get to go to the PASS Summit, but nevertheless, it’s manic here too. SQL Relay started it’s first leg (13-16 October) last week, and is now having a week of rest! On Friday 24th October, I’ll be heading down to London for the annual[…]
I’ve recently started to use SQL Server Data Tools (SSDT) a lot more in database development. And I must say that I’m quite impressed. Having previously used database projects in VS, and fought with msbuild, SSDT is much easier. If you are starting out with SSDT, then I can’t recommend enough that you read Jamie[…]
It’s a few weeks since I blogged about finding a suitable replacement for Google Reader, but I can say I’ve found it. Despite having a rocky start, Feedly has become a mainstay of my daily information overload, and they’ve come a long way to fixing a lot of the issues I found. In fact they’ve[…]
I recently passed the Microsoft exam 70-451, earning myself the MCITP certification Microsoft Certified IT Professional (MCITP): Database Developer 2008, and I’m often asked why am I actively chasing 2008 certifications especially when the SQL 2008 exams are due to retire at the end of July 2013 the SQL 2012 exams are now fully available,[…]
When I first heard about Google’s decision to close down Reader , I was disappointed, but also quietly confident that I would find a new reader and that it might even open my eyes a little, enhancing my newsfeed consumption. It also meant that I would probably have to spring clean my news feeds too[…]
Had a requirement to round some price values to the nearest £5 in a SQL stored proc. It’s easy to round to the nearest 10 using a negative value for the length parameter of the ROUND function i.e. returns 10 returns 20 but length must be of type tinyint, smallint, or int; so you can’t[…]