Transaction Logging & Recovery (101)
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
465 reads
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
465 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
219 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
190 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
217 reads
Documenting Your Database with Diagrams
Don’t get too excited. I know you love documentation, and just can’t wait to spend some...
2015-12-09
377 reads
Documenting Your Database with Diagrams
Don’t get too excited. I know you love documentation, and just can’t wait to spend some...
2015-12-09
1,156 reads
Best Tools for Taking Notes In Development
Developers have a lot to juggle. Do a few of these things sound familiar:
Juggle...
2015-10-14
651 reads
------------ UPDATE: 2016-04-08 10:12 ------------
Been working through some issues with Clarify app on my personal computer, something I messed up. @trevordevore...
2015-10-14
283 reads
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
386 reads
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
923 reads
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,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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