Upcoming October Events
During October I’ll be presenting at several online and in-person events
LocationDateSessionSQL Saturday #49 Orlando 2010Oct 16th ETL with PowerShellPASS PowerShell...
2010-10-06
859 reads
Blog Posts
VMWare vSphere database maintenance
I recently did a VMWare/SAN assessment for a client. The expressed reason, or the reason relayed to me (not always...
2010-10-06
3,936 reads
Converting Dates to Integers
While working on a project recently, I came across a conversion that was trying to convert a date to an...
2010-10-05
808 reads
How Do I Spot Identity Columns That Are About to Max Out?
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
1,325 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
755 reads
MongoDB
I found a comparison of MongoDB and SQL Server recently, from a C# MVP and a person that works with...
2010-10-05
1,618 reads
MSDB Job History Duration Conversion
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...
2010-10-05
2,778 reads
Reminder – Deadline for SQLRally Pre-Con Abstracts is October 15th
See my previous post on the topic,or just go directly to the application.The application has full details, but MVP’s, Summit...
2010-10-05
359 reads
Return of Index Analysis Part 1
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-05
951 reads
SQL Lunch: Change of Schedule
There has been a slight change to this weeks SQL Lunch meeting. Our scheduled speaker cannot present this week, therefore...
2010-10-05
420 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 Kontak Bank BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
Alamat Kontak Bank BCA KCP Maluku Telp:08218154393
WA:08218154393 Jl. Maluku No.10, Dauh Puri, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
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