Why Every DBA Needs a Buddy
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-18
1,911 reads
SQL Saturday SQLSaturday #62 - Tampa Review
For those who attended SQL Saturday #62 in Tampa I hope you enjoyed this free event.As I promised in the...
2011-01-17
1,272 reads
My Prize Has Arrived!
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to...
2011-01-17
552 reads
XQuery for the Non-Expert – @Variable Use
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In a...
2011-01-17
2,718 reads
Multi-subnet Failover Clusters
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-17
4,754 reads
EPM Framework and SQL 2008 R2
This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentationone of the cool things...
2011-01-17
1,333 reads
Notes from SQLSaturday #62
The weekend started with a later afternoon drive to Tampa, returning a couple calls and then chatting with Steve Jones...
2011-01-17
627 reads
Isolation Levels–MCM Prep
I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew...
2011-01-17
1,334 reads
Using the MERGE statement
I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...
2011-01-17
4,100 reads
2011.....So (long pause), what's next for me?
I've actually sat down to write this blog several times. I am never indecisive when it comes to my thoughts...
2011-01-17
1,084 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat BCA KCP Surya Kencana Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
Alamat BCA KCP Ketapang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
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