How to Tell if Execution Plans are Reused
I try to watch the search phrases that point people to the blog because sometimes, you get a sense of...
2010-10-04
455 reads
I try to watch the search phrases that point people to the blog because sometimes, you get a sense of...
2010-10-04
455 reads
Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I’ve...
2010-10-04
402 reads
I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.”...
2010-09-27
1,043 reads
I was privileged to be able to attend and present at SQL Saturday 46 in Raleigh, NC, this last weekend....
2010-09-20
841 reads
Normally, I try to stick to posting technical info or community stuff on the blog, but there were a couple...
2010-09-07
577 reads
I am not a Reporting Services guru and nor do I play one on TV. I am however forced to...
2010-09-03
2,662 reads
Blogging has been a bit quiet of late. That’s because I’ve been spending a lot my spare time getting ready...
2010-08-30
770 reads
There are a lot of things I’d like to say about the PASS elections. I was on vacation last week...
2010-08-23
693 reads
Registration is open for the second 24 Hours of PASS this year. This one is going to be a preview...
2010-08-11
571 reads
I won’t be going to Las Vegas, but I will be presenting to the Las Vegas SQL Server Users Group,...
2010-08-11
634 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