Return of Index Analysis
Now that I’ve finished going through some of the details for sys.dm_db_index_operational_stats, it’s time to take that information and incorporate...
2010-10-04
446 reads
Blog Posts
Slides & Samples for my SQLbits workshop & session
As announced in my SQLBits workshop & session last week in York/UK, you can find the
session/workshop material here.
Have fun!
-Klaus
2010-10-04
407 reads
SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
425 reads
SQL Saturday #53 – Kansas City Wrap Up
Another weekend, another new city, another SQL Saturday. This was my first trip to Kansas City, and it was a...
2010-10-04
1,606 reads
SQL Saturday in New England
Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I’ve...
2010-10-04
397 reads
SQL Server Database Maintenance Checklist
In this blog post, I continue my series of SQL Server Health Checklists that I am developing for a new...
2010-10-04
3,607 reads
SQLRally Event Flyer is Ready
The SQLRally marketing team put this flyer together last week. We’ll be trying to get Chapters and SQLSaturdays to link...
2010-10-04
335 reads
SQLSaturday #52 – Colorado Recap
I had the good fortune of being able to travel to Denver for SQLSaturday #52 the weekend of September 25,...
2010-10-04
671 reads
Maintain Change Data Capture Configuration when restoring a database
I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...
2010-10-03
1,350 reads
SQL Saturday #53 review
The KC PASS chapter has successfully executed the latest SQL Saturday. Thanks to all the organizers and volunteers for a...
2010-10-03
2,007 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