Undocumented Virtual Column: %%lockres%
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,680 reads
One of my development teams needed a mechanism for identifying the value of a key that was part of a...
2010-03-18
4,680 reads
Aaron Bertrand showed up to teach us tips and tricks for SQL Server Management Studio. We had to move our...
2010-03-15
618 reads
I got a little distracted after lunch and was reading through some of the various bloggers reactions to the decision...
2010-03-11
625 reads
There has been some discussion recently around the location of the PASS Summit. The debate was centered on the results...
2010-03-10
867 reads
Two years old. In March of 2008 I received a whopping 96 visits. I’m up to 1900 so far this...
2010-03-09
541 reads
Who the heck is MacGyver? Television program you say? Hang on. I need to visit imdb.com…
Oh, the late eighties… Yeah,...
2010-03-08
694 reads
I’m right in the middle of moving one of our databases from Oracle to SQL Server (and I just love...
2010-03-01
1,701 reads
If you’re not reading Buck Woody’s blog, why not? Today he posted a helpful hint for getting performance counters directly...
2010-02-26
1,423 reads
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
711 reads
I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s...
2010-02-16
786 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....
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
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