This week sees the closing of a chapter in my career. It was starting to feel like the right time for an all-around change and after a lot of thought and support of close friends and family I set out to find my next adventure. So, after nearly 15 years working through various roles at […]
In SQL Server you can use partitioning to split a table into multiple segments based on the data contained within it. This feature can be used to bring improvements to performance and provide more flexibility with maintenance for those tables which are partitioned. The impact of these will be key for large data sets where […]
This month’s invitation from Glenn is to write about what we’ve been doing with SQL Server 2022 as we’ve now had a release candidate unleashed upon the world. Personally I haven’t had the time to adventure through the new features or put any stress onto the version as of yet – the exception being testing […]
I’d previously inherited a legacy SQL environment running SSAS with a handful of multi-dimensional models. The models were actively being used however development on them had ceased a number of years earlier so it was just a case of keeping the lights on. The problem Fast forward to the point we wanted to start winding […]
Andy Brownsword 