PASS Subcommittee
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer....
2011-03-31
1,549 reads
Jason Brimhall
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have...
2011-03-30
22 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-03-30
3,904 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts...
2011-03-29
15 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain...
2011-03-29
944 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is really not too big of a deal. While demonstrating...
2011-03-28
33 reads
ShowPlan XML
I just ran into something that I hadn’t noticed in SQL Server. It struck me as somewhat interesting but is...
2011-03-28
1,967 reads
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either...
2011-03-25
1,313 reads
Tools note
I was asked a few months ago to allow some advertising on my blog. I hadn’t given the idea a whole lot of thought but was reminded again today...
2011-03-24
15 reads
Tools note
I was asked a few months ago to allow some advertising on my blog. I hadn’t given the idea a...
2011-03-24
850 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Alamat Telp BCA KCP Sulawesi (+62) 838-4945-0961
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Question of the Day
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