Últimas postagens de blog

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 »

Ligue-nos +44 7876644436

Jarrin Consultancy Ltd.

22, Chatsworth Drive,

Bedlington.

Northumberland.

NE22 5YS

Registrado no Reino Unido nº 7616093 |Registo do IVA n. ° 112 2308 74

contact@jarrinconsultancy.com

Compartilhar

Tweet

Compartilhar

Correio

Nós usamos cookies para garantir que você tenha a melhor experiência em nosso website. Se você deseja mudar suas preferências, você pode fazer seguindo as instruções aqui.

×

Share by: