Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...
2014-08-11 (first published: 2014-08-04)
8,834 reads
Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as...
2014-07-22
516 reads
Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...
2014-07-07
682 reads
Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize...
2014-06-30
1,966 reads
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
764 reads
When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...
2014-06-17 (first published: 2014-06-15)
3,628 reads
Imagine that you have a table of customers
createtable Customer
(
Name varchar(30),
LastName varchar(30),
Title varchar(30)
);
go
insertinto Customer values('Alex','Smith','Mr.');
insertinto Customer values('John','Doe','Dr.');
goNow you selecting list...
2014-06-10 (first published: 2014-06-09)
1,900 reads
It may happenthatyou have a needto check thescripts thatyou have on yourdisk. For example, it may be part of yourbuildprocess.So how...
2014-06-02
1,855 reads
What are the magic pink numbers you can see in Code Outline window?The answer is very simple - these are Code Complexity...
2014-05-28 (first published: 2014-05-23)
705 reads
Today we released new version of SQL Code Guard, 2.5.5257
Main changes:
SQL Code Guard is digitally signed now to satisfy corporate...
2014-05-26
791 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
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
