Welcome to www.BlobEater.blog

Featured

I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure.

During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP of SQLskills.

I have written articles for SQL Server Central, TechNet, built the SQL Performance dashboard project on CodePlex with over 1600 downloads and I have helped gather data for SQLskills Waits and Latches Library. I have also helped the SQL Server product team with testing SQL Server vNext adaptive query processing feature.

My aim is to help you in your day to day work or to reinforce specific areas that I am interested in, so I try to keep things short and simple.

Sometimes I will reinforce basic concepts via a quick SQL Server video clip – https://blobeater.blog/sqlserver-video-library/

Arun Sirpal – BlobEater

p.s. I am no longer afraid to mention that I like Sheep.

paulie

I have actually lost Paulie in the garden.

Copyright © All rights reserved. You are free to use any of the content here for personal use but need permission to use it anywhere else on the internet.

 

Getting intimate with Brent Ozar (The First Responder Kit)

Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL Server databases and it is a battle just to keep the lights on.  If this sounds like you then you need all the help you can get. You can find this help from https://www.BrentOzar.com/first-aid/ where Brent, his team and community members (found here https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/graphs/contributors) have developed something known as the First Responder Kit and let me tell you, it will make your life “easier”. (In the long term)

Continue reading

Microsoft Data Platform is changing – so am I

This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever changing times within our technology space. Personally I love this new era of cloud computing and do not feel threatened in anyway.

TSQLTues

Continue reading

Azure: SQL Database Elastic Pool and using Elastic Jobs

I want to show you how I went from having multiple single SQL databases in Azure to a database elastic pool within a new dedicated SQL Server. Once setup I create and use elastic jobs. This post is long but I am sure you will find it useful.

Continue reading

Azure – SQL Database Premium RS

A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section and came across an edition that I had never seen before and I became very intrigued. It is called Premium RS (currently in preview mode) meaning we now have four tiers to select from – basic, standard, premium and premium RS.

Continue reading

SQLBits 2017

I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which is just over a week away. The Data Platform has evolved so much and this is the chance to get some quality training under my belt especially in areas I know I need a “refresh” in.

Continue reading

Why did my SQL Server database just go offline?

Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely use SQL Server Management Studio GUI to do day-to-day tasks, I rather just load a window and start typing stuff (I learn better that way). Recently I became lazy and just loaded up the tool and found something quite quirky, let me explain.

Continue reading

TDE: Looking inside your database and backups

TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabling TDE and comparing it to when enabled.

Continue reading