Statistics in SQL Server
I’ve put together a new Curah! of links to some of the better articles on SQL Server Statistics, specifically those...
2014-09-15 (first published: 2014-09-10)
7,402 reads
The Scary DBA
It’s All Fundamentals
I’m learning how to speak German. Interestingly enough, you don’t start off reading dissertations. Instead, you begin by learning the...
2014-09-09
835 reads
Speaker of the Month: September 2014
This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to...
2014-09-05
534 reads
Left or Right?
No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a...
2014-09-08 (first published: 2014-09-03)
6,780 reads
Silliness for an Important Cause
I don’t mind saying that amyotrophic lateral sclerosis (ALS), also known as Lou Gehrig’s disease, scares me. A degenerative disease...
2014-08-21
1,242 reads
The Red Gate Way…
As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind...
2014-08-20
760 reads
Getting the Word Out
A discussion that I’ve frequently had with organizers of SQL Saturday events, our own people here at Red Gate, authors,...
2014-08-19
575 reads
A Full Day of Query Tuning
I’m excited to able to say that I’ve been given the opportunity to put on a full day workshop at...
2014-08-14
822 reads
Say Thank You
I was approached by a man at SQL Bits who only wanted to thank me for blogging. He said, “I...
2014-08-13 (first published: 2014-08-06)
8,120 reads
Speaker of the Month: August 2014
Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...
2014-08-08 (first published: 2014-08-01)
7,058 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