Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located...
2016-02-02
2,248 reads
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located...
2016-02-02
2,248 reads
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
607 reads
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
822 reads
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server:...
2016-01-20
840 reads
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-20
419 reads
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but...
2016-01-13
328 reads
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization...
2016-01-13
261 reads
Transaction Logging & Recovery (part 2)
… Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server:...
2016-01-08
447 reads
... Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-08
326 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
288 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....
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
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