Canadian SQL Saturday speaking events
I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of...
2019-03-06
279 reads
Blog Posts
How to get Live Execution Plan using Extended Events
Introduction
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...
2019-03-06 (first published: 2019-02-19)
6,842 reads
How Your Hypervisor Can Impact Your CPU
Recently I had a client complain of chronic high CPU utilization. The performance of their SQL Server had degraded, and...
2019-03-06
580 reads
Midlands #PASS April Meeting with Matt Gordon (@SQLatSpeed)
Midlands PASS in Columbia, SC, will be hosting Matt Gordon (website | twitter) for our next meeting, which is scheduled for...
2019-03-06
267 reads
Pushing SQL Change Automation Code to Azure DevOps
Making changes on your own system for a SQL Change Automation project is great, but if you’re the only one...
2019-03-06
825 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-03-06
15 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links,...
2019-03-06
420 reads
SQL Server, What's In My Buffer Cache?
When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...
2019-03-06 (first published: 2019-02-19)
2,278 reads
Tokenization of database project in SSDT
SSDT project has something we call Variables. On the Internet (posts, forums) they also are known as placeholders or tokens,...
2019-03-06
393 reads
Writing a new session/Preparing for SQL Saturday Chicago
So, I’m presenting a session at SQL Saturday Chicago on March 23, 2019. This is a new session, called Performance...
2019-03-06
260 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers