Understanding DBCC FLUSHAUTHCACHE
This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...
2018-03-14
743 reads
All About SQL
Azure SQL Database – Allow Azure Services to Access Server
When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there...
2018-03-09 (first published: 2018-03-01)
2,487 reads
How to setup Azure SQL Analytics
I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did...
2018-02-26
1,054 reads
Saving Costs in Azure
Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient...
2018-02-27 (first published: 2018-02-15)
1,788 reads
Azure SQL Database sa Connections?
I was using a query on one of my local SQL Servers where I wanted to know what logins were...
2018-02-07
1,090 reads
Deleting Azure SQL Database VNETs
This is quite a new feature (currently in preview) but an important one where we now have the ability to...
2018-02-07 (first published: 2018-01-29)
1,032 reads
The world of Automatic Tuning – SQL Server 2017
Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...
2018-01-31 (first published: 2018-01-22)
2,415 reads
Azure Portal – Bad Request
I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...
2018-01-16
269 reads
T-SQL Tuesday #98 Round Up
Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...
2018-01-11
585 reads
Azure SQL Database – Optimizing For Ad-hoc Workloads
Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...
2018-01-16 (first published: 2018-01-08)
1,603 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...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
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