-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

All About SQL

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

Archives: December 2016

Why I am called BlobEater

It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical post. I have been asked a few times over the past month where I got my online name from – … Continue reading

Read more

1 comments, 340 reads

Posted in All About SQL on 17 December 2016

Locking Resources in Azure

I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it can get quite confusing within the portal if for example you have close to 100 databases. There are 2 types … Continue reading

Read more

1 comments, 363 reads

Posted in All About SQL on 16 December 2016

CHECKDB and Page Restoring from SSMS

Did you know that you can run DBCC CHECKDB (WITH PHYSICAL_ONLY) and issue page restores from SSMS (SQL Server Management Studio). I never, and I probably will never because I rather use TSQL – however I have only just seen … Continue reading

Read more

1 comments, 289 reads

Posted in All About SQL on 15 December 2016

Don’t blink you might READPAST it

Following on from my previous post on NOLOCK (https://blobeater.blog/2016/12/09/nolock/) I want to talk about another hint called READPAST. This hint tells the database engine not to read rows that are locked by other transactions. It is best explained with an example. … Continue reading

Read more

3 comments, 288 reads

Posted in All About SQL on 13 December 2016

NOLOCK

NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and MAY cause blocking. I used to think that a NOLOCK (which is the same as read uncommitted) hint actually meant … Continue reading

Read more

6 comments, 1,818 reads

Posted in All About SQL on 9 December 2016

TDE Recovery

This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can I not get involved with this one? I have been blogging for about a year now and have covered … Continue reading

Read more

3 comments, 1,294 reads

Posted in All About SQL on 7 December 2016

Checking your Wait Stats via Power BI

Wait stats is my go to thing, however I do get bored just querying it via a  table so I decided to broaden my horizons and see how “analytical” I could get with it via Power BI. What I usually … Continue reading

Read more

1 comments, 597 reads

Posted in All About SQL on 6 December 2016

I use Elastic database pools – for now

When you have many SQL databases that are required to run your environments and  they show signs of specific usage patterns and some of the databases requires different performance levels then how can you ensure that the all the databases … Continue reading

Read more

2 comments, 1,230 reads

Posted in All About SQL on 2 December 2016

Azure pricing

Not a technical post today (not that I am technical) but still an important one. I have been using Azure for 1.5 years now and I am still fascinated by the ever-changing technology. Talking of ever-changing, I had a nice … Continue reading

Read more

1 comments, 386 reads

Posted in All About SQL on 1 December 2016

SQL Server – Playing With Trace Flags

Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. They are usually scoped to a global level or a session only level. For this blog post I thought it would be handy … Continue reading

Read more

1 comments, 431 reads

Posted in All About SQL on 1 December 2016