I Escaped from a SQL Server Service Pack Nightmare
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...
2017-04-24
369 reads
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...
2017-04-24
369 reads
Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...
2017-04-12
524 reads
This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever...
2017-04-11
327 reads
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
592 reads
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
384 reads
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
1,001 reads
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
314 reads
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
392 reads
A non-technical post but something I have been asked about few times so I thought that I would put pen...
2017-03-22
451 reads
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
325 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