Powershell to Script out SQL Server Objects using a CMS list
I’ve recently decided I’ve got to get with the times and started dabbling with Powershell. Up until now i’ve not...
2011-09-19
2,249 reads
Blog Posts
Presenting “Tangled Code” at Charleston UG Tuesday 9/20
On Tuesday, September 20 at 5p CST (6pm Charleston time), I will present “Unraveling Tangled Code” via LiveMeeting at the...
2011-09-19
609 reads
Presenting Banish RBAR! to Hampton Roads UG
On Wednesday, Sept 21, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Hampton Roads SQL Server User...
2011-09-19
646 reads
SQL Saturday 85 – Orlando
Grab your computer and get registered for SQL Saturday 85 in Orlando. If you’re new to the SQL world and...
2011-09-19
1,054 reads
SQL University: Architecture for Small Businesses
Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at...
2011-09-19
839 reads
SQLInspire NYC - SQLPeople Just Got Even More Inspiring!
is all set for Saturday, November 12, 2011, with only 53 days remaining to this fantastic gathering
of assorted SQL Server,...
2011-09-19
1,630 reads
Find the largest tables in a database (II)
I once wrote a post to find the largest tables in a database, and now after studying PowerShell, I feel...
2011-09-18
2,057 reads
Overcome update conflict in P2P replication
When we have Peer to Peer (P2P) replication in place on SQL Server 2008, probably we would see a conflict...
2011-09-18
1,787 reads
PASS First Timers Guide
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
643 reads
PASS First Timers Guide and Schedule
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
782 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