A Friend of Red Gate No More
Don’t get me wrong. It’s been great. The beta tests. The advanced notices. The opportunity for feedback. It’s been a...
2011-01-21
787 reads
Blog Sins
Thoughts come together, and the hybridization of your thoughts give rise to new ideas. Here are the thoughts:
I have this...
2011-01-21
704 reads
Speaking at SQLSaturday #66 in Colorado Springs on February 12
I recently found out that I will be one of the speakers at SQLSaturday #66 on February 12 in Colorado...
2011-01-21
709 reads
Read from the Right End of the Index: BACKWARD Scans
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding...
2011-01-21
1,928 reads
Deprecation, Trace and Execution Plans
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or,...
2011-01-21
895 reads
SQL Saturday Tampa Follow Up
This past weekend, I had a talk on SQL Server Reporting Services down in Tampa Florida for SQL Saturday 62....
2011-01-21
760 reads
31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)
Remember, what I said last Friday? I’m going do it, again. Which means, I’m taking the day off. There will...
2011-01-21
944 reads
Disk Partition Alignment–MCM Prep
Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be...
2011-01-21
1,467 reads
Free SQL Server Training for the week of January 24, 2011
We're finally getting a handle on things with the new baby. 🙂 As a result, I've started this weekly accumulation of...
2011-01-21
845 reads
PowerShell Week at SQL University – Post 6
Yesterday we went over some loop constructs to get information out of SQL Server. While getting the information out is great, as Data Professionals our very next concern is...
2011-01-21
32 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 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
Alamat Telp BCA KCP Poris Indah (+62) 838-4945-0961
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
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