Azure SQL Elastic Pools – Moving Databases
If you read official Microsoft documentation about naming conventions for your SQL elastic pools, it is hard to find any...
2018-07-09 (first published: 2018-07-02)
1,950 reads
All About SQL
SQL Server 2017 – SELECT INTO [A SPECIFIC FILEGROUP]
Forget about Adaptive Query Processing for a minute, what other feature have I been waiting for? SELECT INTO a specific...
2018-06-19
582 reads
Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.
Now that I have your attention with a powerful title how about some context? It is quite common to get...
2018-06-26 (first published: 2018-06-15)
2,304 reads
Azure SQL Database – Stairway Series
Hello all – I am excited to announce that I will be doing a Stairway series on Azure SQL Database hosted...
2018-06-13
400 reads
Linked Server to Azure SQL Database
You may (or may not) have a requirement to setup a linked server to Azure SQL Database from a locally...
2018-06-13 (first published: 2018-06-05)
1,861 reads
Azure SQL Database – The Default Isolation Is?
So what is the default isolation level for Azure SQL Database? I ran the following code to check it out....
2018-05-30
419 reads
Azure SQL Database / SQL Server – Paused Index Rebuild
I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when...
2018-05-30 (first published: 2018-05-22)
1,889 reads
Handy TSQL for Azure SQL Database
I do not always use the Azure portal to make database changes or to check for certain information. I use...
2018-05-14
323 reads
Extended Events – Using Azure Storage
Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/) and gave an example where I was capturing deadlocks...
2018-05-21 (first published: 2018-05-08)
1,429 reads
Getting my Twitter Data via Azure Logic Apps
As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...
2018-05-02
338 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