Using SQL Server Diagnostics (Preview)
I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What...
2017-06-27
592 reads
I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What...
2017-06-27
592 reads
I have decided to do a 4-part series on Cloud “Fear Busting” scenarios. Why? Over the past few years working...
2017-06-22
410 reads
A really quick one today, something that made me think for a minute and I thought it might make others...
2017-06-19
683 reads
I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx...
2017-06-14
640 reads
Thanks to Grant for hosting this month’s T-SQL Tuesday found (http://www.scarydba.com/2017/06/06/t-sql-tuesday-091-databases-devops/) where it is a chance to share our DevOps...
2017-06-13
566 reads
Following on from my previous blog post I mentioned that I had to find a solution to the “unable to...
2017-06-07
439 reads
I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was...
2017-06-05
416 reads
A very quick post for today, recently I have been working on some code to gather metrics around SQL Server...
2017-06-02
478 reads
They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made....
2017-06-01
443 reads
A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database...
2017-05-25
335 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