Come to SQL Saturday 92 in Portland
Are you In Portland, Oregon?
Do you plan to be in Portland on Saturday, October 8th?
Can you be in Portland on...
2011-09-09
514 reads
24 Hours of PASS & SQL Saturday(s)
I survived 24 Hours of PASS! Just wrapped up delivering my presentation for the 24 Hours of PASS (24HOP) on...
2011-09-09
663 reads
SQL Saturday #97 – Austin TX
The schedule for SQL Saturday 97 has been posted and I was selected to give my “It’s TempDB, Why Should...
2011-09-08
474 reads
Prepping for Certification
Having prepped for, taken, and then failed the MCM exam this year, perhaps I’m not the best person to give...
2011-09-08
1,353 reads
I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED
Edit: See end of blog for solution.
I have MS Visual Studio 2008 (BIDS) x86 with SP1. Recently it’s started shutting...
2011-09-08
701 reads
I need #sqlhelp! BIDS shuts down unexpectedly
I have MS Visual Studio 2008 (BIDS) x86 with SP1. Recently it’s started shutting down without warning whenever I hit...
2011-09-08
604 reads
SQLSaturday #97 Speaker Selection Process
Hard Choices
First, thank you for submitting to speak at SQLSaturday #97 in Austin, TX. Myself, Richard Heim and Mike Byrd...
2011-09-08
798 reads
Configuring Windows 7 For Paired Storage
In recent years solid state drives (SSD for short) have dropped in price enough to be an affordable option in...
2011-09-08
1,193 reads
TPC-H generate test data , test queries and sql database benchmark
This is a followup on my earlier post ofSQL Server test data generation testing tools.
I had some requests for my...
2011-09-08
5,660 reads
SQL Server DMV Views: Getting slow queries within stored procedure
SQL Server DMV Views might be very helpful. Let’s imagine that you have a couple of nested stored procedures and...
2011-09-08
1,924 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