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...
2016-12-17
517 reads
All About SQL
Locking Resources in Azure
I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it...
2016-12-16
519 reads
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...
2016-12-15
464 reads
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...
2016-12-13
446 reads
NOLOCK
NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...
2016-12-09
2,320 reads
TDE Recovery
This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...
2016-12-26 (first published: 2016-12-07)
1,496 reads
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...
2016-12-06
798 reads
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...
2016-12-12 (first published: 2016-12-02)
1,438 reads
Azure pricing
Not a technical post today (not that I am technical) but still an important one. I have been using Azure...
2016-12-01
627 reads
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...
2016-12-01
574 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...