ExpressProfiler now is digitally signed.
Today I've replaced download package for ExpressProfiler with digitally signed version of standalone application and Ecosystem installation.
Unfortunately I did something wrong and...
2014-05-24
609 reads
Varchar "miracle" and best practice
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
677 reads
ExpressProfiler: The New Kid on the Block
I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...
2014-05-15
639 reads
Psst! Wanna some API?
If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool...
2014-05-11
708 reads
A few words about simplicity: Using Red-Gate Ecosystem framework
In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...
2014-05-04
547 reads
When issue is not exactly "issue"
In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...
2014-04-27
573 reads
New release 2.4.5222
Today we released new version of SQL Code Guard - 2.4.5222There are many fixes and improvements, some new rules were added.Full...
2014-04-20
353 reads
Why I Developed SQL Code Guard: A Fairy Tale from a DBA
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
842 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
