(2019-Mar-10) A conversation between two or more people involves continuous efforts to listen and reflect on what other people have to...
2019-03-25 (first published: 2019-03-10)
11,032 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-03-25
951 reads
OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...
2019-03-25
5 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-03-25 (first published: 2019-03-11)
535 reads
This is in response to someone asking about getting started with their database in SQL Source Control and then hosting at BitBucket. I’m going to assume people can set...
2019-03-25
424 reads
Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.… Continue...
2019-03-25
591 reads
Good day! Good week! Let’s start it with some news form the Data Platform world!
SQL Internals – Physical Table Structure under...
2019-03-25
231 reads
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server ... Continue reading
2019-03-25
26 reads
Setup the DRU What is it? The Distributed Replay Utility (DRU) on SQL Server allows you to capture Profiler trace information on one or more client servers and then...
2019-03-24
199 reads
New podcast’s episode is coming (next Friday) and in the meantime, take a look you can watch that episode’s trailer....
2019-03-23
391 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Tlp/Wa_Cs:0821-8154-398 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
Comments posted to this topic are about the item A Quick Second Opinion
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