Are you ready?
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
911 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
Your SQL Server database just failed, can you restore the backup?
It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...
2012-05-09
4,522 reads
On the road less traveled: a DBA Roadmap review
The story of why I came up with this blog is no secret to the few readers I have here. In...
2012-05-03
1,383 reads
Who are the sysadmins in this sql server?
Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...
2012-04-24 (first published: 2012-04-23)
33,126 reads
10 must follow blogs that might not be in your list
There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday)....
2012-04-16
1,806 reads
Limiting user access to your database
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,530 reads
The evolving role of the database professional
The role of the database professional is quickly evolving to conform with the ever changing demands of the business world....
2012-04-04
1,233 reads
Save yourself from despair with full database documentation
Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases....
2012-03-29
2,755 reads
I am looking for change
I am looking for a change. Yes, a change. This is the beginning of that quest. This blog will be...
2012-03-28
849 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