Azure SQL Database Data Integrity Checks
If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...
2017-10-04
556 reads
If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...
2017-10-04
556 reads
Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...
2017-10-03
508 reads
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
378 reads
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,728 reads
Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...
2017-09-25
541 reads
Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...
2017-09-25 (first published: 2017-09-19)
1,621 reads
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
800 reads
If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...
2017-09-14
1,380 reads
SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...
2017-09-08 (first published: 2017-08-24)
2,018 reads
Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...
2017-09-04
772 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