On the addition of useless where clauses
I remember a forum thread from a while back. The question was on how to get rid of the index...
2016-02-10 (first published: 2016-02-02)
2,427 reads
Speaking at OPASS on February 25, 2016
Last month I visited MagicPASS, this month I’ll be at oPASS and presenting again on my pattern for automating database...
2016-02-02
560 reads
Pausing PASSWatch & What’s Next
I just posted Pausing PASSWatch on the PASSWatch blog, wrapping up a project that ran about 16 months. It’s hard...
2016-02-02
618 reads
SSC Question of the Day: DBCC Error 6
My latest question of the day on SQLServerCentral is DBCC Error 6. Text of the question below:
As the on-call DBA,...
2016-02-02
2,068 reads
Book Review – Expert Performance Indexing
A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in...
2016-02-11 (first published: 2016-02-02)
2,085 reads
Azure SQL DB – technical deployment
Take a look this awesome document for the Azure SQL DB technical deployment with lot of the details that you need...
2016-02-02
535 reads
Should I use option(recompile)?
This will probably be a multiple stage discussion. The notes I’m providing today were sparked off of the content located...
2016-02-02
2,248 reads
Advent of Code – Day 2 – Using Cross apply
For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...
2016-02-02
319 reads
Excel Power Map vs. Power BI Globe Map visualization
[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...
2016-02-09 (first published: 2016-02-02)
5,885 reads
Microsoft Azure Stack in Preview!
Microsoft made available the first technical preview of its new Microsoft Azure Stack offering today. It was announced last week. Azure...
2016-02-09 (first published: 2016-02-01)
1,891 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