Get in touch

Office: +44 (0)1670 221 737

Mobile: +44 (0)7876 644 436

Latest Blog Posts

AI Generated Blog of “New Features in SQL Server 2022”

PLEASE NOTE: The generated content in this blog post has in no way shape or form been verified for correctness and purely used as an example of what can be generated, please do not take what the AI model has generated as verbatim Well, no idea where to start with this. I’m not an AI&ellipsis;Read the full post »

Resumable Online Index Operations

This is more of a heads up for me / reminder regarding some of the caveats to using ONLINE / RESUMABLE index operations with SQL Server. Don’t get me wrong, there’s a ton of advantages to using ONLINE and RESUMABLE which I will highlight below but here is the link to the Microsoft Learn page&ellipsis;Read the full post »

Microsoft Ignite 2022 – Book of News

Now that Microsoft Ignite 2022 is over, we’ve all had time to reflect on the announcements made. A little disappointed in the lack of SQL Server 2022 stuff but plenty of exciting Azure changes! If, like me, you couldn’t attend every session you would like to, well Microsoft have this covered with their Book of&ellipsis;Read the full post »

Little shortcut: https://shell.azure.com/

A very short blog post to give a great little shortcut/snippet for those that want to access / work with Azure via the cloud shell but don’t want to navigate to the portal, click, click etc. Simply use the url: https://shell.azure.com/ and if you’re already logged in it will take you straight to a cloud&ellipsis;Read the full post »

Newcastle Power BI YouTube Channel

Myself, Glen and Mark have been back up and running with the Newcastle Power BI meetup from October 2021 running virtual events which have been a huge success! We have been recording some of the sessions where the speaker is happy for the content to be shared and have been uploading them to a brand&ellipsis;Read the full post »

tempdb – size matters!

tldr: Over the years I’ve read a lot of blog posts and watched a lot of videos where they mention that you should have your tempdb files all the same size. What I haven’t seen much of (if any) is what performance impact you actually see if they are not configured optimally. This blog post&ellipsis;Read the full post »

DBCC ShrinkFile Error Message: File ID 1 of database ID ‘nn’ cannot be shrunk as it is either being shrunk by another process or is empty

We’re currently working with a customer on an Archiving project and as part of it trying to reduce their 8.5tb database down to where it should/needs to be (~5tb) in order to be able to restore it in their dev/test environments. Unfortunately adding more disk space in these environments is not an option so as&ellipsis;Read the full post »

SQL Server Corrupt / Suspect database with In-Memory OLTP

The Problem Late last week (20th) we had an emergency call from a company that had a production database go into Suspect mode and needed help. Now this isn’t a great situation to be in so when they then go on to tell us that the last valid backup they had was from the 12th&ellipsis;Read the full post »

Microsoft Ignite 2021 – Book of News

Microsoft Ignite 2021 is currently underway and if, like me, you can’t attend every session you would like to, well Microsoft have this covered with their Book of News. There’s a ton of new stuff (very little for Data which is my primary focus) but this gives a great overview of all the latest information.&ellipsis;Read the full post »

Should I split my SQL Server Drives on a SAN in 2021?

NOTE: This blog post references HPE as our example but is relevant to other storage vendors out there. I am in no way affiliated with HPE 😉 Back in the day, “when I was a lad“, the recommendation for SQL Server was to split your data, logs and tempdb files onto separate drives/luns to get&ellipsis;Read the full post »

Jarrin Consultancy Ltd

22 Chatsworth Drive

Bedlington

Northumberland

NE22 5YS

Registered in the UK No 7616093 | VAT Reg No 112 2308 74

Share by: