Speaking at the first Belgian SQLSaturday!
I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium....
2016-02-15
497 reads
Koen Verbeeck
Reblog: SSIS Performance Testing
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in...
2016-02-19 (first published: 2016-02-12)
1,738 reads
The Future of SSMS
One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a...
2016-02-03
628 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,079 reads
Reblog: Building the Script Component
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People...
2016-01-28
862 reads
Overview of Published Articles – 2015Q4
Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...
2016-01-22
501 reads
Book review – Extending SSIS with .NET Scripting
Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...
2016-01-29 (first published: 2016-01-21)
2,863 reads
T-SQL Tuesday #74: Be the Change
It’s the second Tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...
2016-01-20 (first published: 2016-01-12)
1,386 reads
Happy Holidays
It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do...
2015-12-29
793 reads
Performance Tuning with sp_BlitzIndex
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,269 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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