Azure SQL Database – Reduce the workload before initiating another service objective update
Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...
2019-01-21
242 reads
Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...
2019-01-21
242 reads
You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that...
2019-01-15
262 reads
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
335 reads
Once again I would like to share with you an article I wrote about backing up (and restoring) a SQL...
2019-01-01 (first published: 2018-12-19)
2,764 reads
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
884 reads
Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an...
2018-12-11
240 reads
I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated...
2018-12-06
469 reads
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
245 reads
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
278 reads
This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I...
2018-11-14
246 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers