Your presentation matters! Do it right!
This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov...
2015-08-31
908 reads
DotNine SQL Server and more
Speaking engagements for August and September
August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday...
2015-07-03
547 reads
SQL Server 2016 Live Query Statistics
So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the...
2015-05-28
3,134 reads
Announcing Pro SQL Server Wait Statistics
I am very proud to officially announce my first ever SQL Server related book, Pro SQL Server Wait Statistics! As...
2015-04-14
645 reads
Speaking at SQLSaturday 376 Budapest
On April 18 2015 I will be speaking at SQLSaturday #376 in Budapest!
I will be speaking about one of my...
2015-03-23
550 reads
Hangout with Boris Hristov
A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL...
2015-01-17
600 reads
In-Memory OLTP Part 2 : Memory-Optimized tables
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements...
2015-01-11
4,201 reads
Looking back on 2014
When a new year comes around it is always a great time to reflect on the previous year.
2014 was a...
2015-01-06
422 reads
Video articles
While thinking of ways to improve the way I can get SQL Server information across to those who follow my...
2014-11-30
973 reads
In-memory OLTP Part 1: Introduction to In-memory OLTP
SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or...
2014-11-27 (first published: 2014-11-21)
8,415 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