Getting and storing a high precision datetime
Earlier today I was working on a project where I was recording some time stamps. In order to get as...
2015-08-13
595 reads
SQLStudies
Database Master Keys can have more than one password.
Our subject for this month’s T-SQL Tuesday blog party (#69) is Encryption, hosted by a guy with an awesome first...
2015-08-11
823 reads
A pattern to match correctly on a value or a NULL
As you may have noticed if you read my blog I learn a lot from trolling various forums. In this...
2015-08-05
1,310 reads
SQL Crossword
I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF...
2015-08-03
969 reads
Some of my favorite SSMS Keyboard shortcuts
I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of...
2015-07-29
1,285 reads
Permissions Posters
I’ve been doing a lot of research recently for my permissions session and for a project at work. During said...
2015-07-27
1,439 reads
#ArgenisWithoutBorders the Sequel
Last year Kirsten Benzel(b/t) and Argenis Fernandez(b/t) did this amazing thing. They organized a campaign and raised over $13,000 for...
2015-07-22
694 reads
Filtered Index restrictions and Kendra Little’s Index Quiz
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had...
2015-07-24 (first published: 2015-07-20)
2,188 reads
SSMS 2015
Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10...
2015-07-16
999 reads
TSQL Tuesday #68: What is my configuration?
It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just...
2015-07-21 (first published: 2015-07-14)
1,454 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