SQL Server Quiz – the last time a stored procedure was executed
A developer rushes up to you and asks "can you tell me the last time this stored procedure was executed?"....
2011-09-13
1,153 reads
T-SQL Tuesday #22 - Data Presentation - My Example with CTE
Hey, everybody! Welcome to T-SQL Tuesday #22! Today's topic is Data Presentation, and the importance of formatting data to the...
2011-09-13
3,869 reads
T-SQL Function: EOMONTH
We have all been in a situation where we had to get the last day of the month with T-SQL....
2011-09-13
5,788 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
914 reads
How to prevent blocking in your SQL Server database
As a SQL Server DBA, usually the largest databases in size and in number of users that I had to manage was an ERP...
2011-09-12
846 reads
Checkers, Chess, and Politics
There are few games that don’t have some kind of strategy, from tic-tac-toe on up. Sometimes we take the time...
2011-09-12
1,165 reads
Great Tools for Formatting T-SQL
I have a big rant I add to….well, to every single SQL session I give. That rant is on formatting...
2011-09-12
1,199 reads
My Sessions & Schedule at the 2011 PASS Summit–Early View
I was just checking the event calendar and saw that my Building a Professional Development Plan presentation is on Wednesday...
2011-09-12
768 reads
PASS 2011 Countdown – 4 Weeks To Go
One week down and we are now 4-weeks from this years PASS Summit. Hopefully, you have already registered for the...
2011-09-12
632 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
830 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