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
527 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
526 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
475 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
458 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,330 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,507 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
804 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,442 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
633 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
581 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Google – NotebookLM on ThakurVinay blog
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers