Welcome to BlobEater

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 from SQLskills.

I have written articles for SQL Server Central, TechNet, gathered 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.

 

Blog Series: Azure Cloud “Fear” Busting

Featured

I have decided to do a 4-part series on Cloud “Fear Busting” scenarios. Why? Over the past few years working with the cloud (Azure) I have come across 4 main “fears” or “concerns” that stand out in my mind that people have highlighted when adopting cloud technology for their database tier. Each “fear” with form a blog post where I am hoping that after reading each post you will be “less” fearful. More specifically I will be looking at these topic areas:

  • I have security fears for SQL Database.
  • Performance Issues that I faced – Learn from my mistakes.
  • There is no going back – can I get the data back?
  • I’m a DBA – Will I lose control?

Series Link Here.

Azure Cloud “Fear” Busting #4 – Losing Control?

So the decision to move to the cloud has been made but there is a fear from people that once it happens they will lose control of their job function. Does this sound familiar? DBA’s, you will be needed but expect some sort of change (That’s my opinion).

Continue reading

Interviews and Oranges

What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/

TSQLTues

The topic being: Interviewing Patterns and Anti-Patterns. I have had MANY (50 +) interviews over time with a lot of failures, so what have I learnt?

Continue reading

Azure Cloud “Fear” Busting #2 – Seeking for Better Performance

We all want high performing applications and when you are in the cloud that is no different, if anything it is even more important. With this post I will discuss some areas where I have been “stung” by so you can learn from my mistakes when using Azure SQL Database. Then I will dedicate a section on what tools you can use to help with your performance tuning exercises.

Continue reading

Azure Cloud “Fear” Busting #1 – Security

So here we go, the first installment of my cloud blog series. From my experience this concern is a common one, especially when relating it to the database layer. Data “leaks” via security breaches have been getting some real negative press lately, what tools and techniques do you have to protect your Azure SQL Databases? The answer is – A LOT across different components and that is what I will cover in this blog post.

Continue reading

SQL Server Rookie Mistakes

A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG http://www.sqldoubleg.com/2017/07/03/tsql2sday-92-lessons-learned-the-hard-way/.

TSQLTues

We are here to talk about mistakes we used to make. There is one mistake that I am going to discuss and is something that I used to do 10 years ago, obviously I do not do this anymore.

Continue reading

Using SQL Server Diagnostics (Preview)

I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What is it you are asking? It is an extension to SQL Server Management Studio (SSMS) where it gives you the ability to Upload / Analyse dump files created by SQL Server.

bobsql.JPG

Continue reading