SQLSaturday #122, Louisville
Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-07-10
670 reads
Colleen M. Morrow
SQLSaturday #164, Cleveland
Date: August 18, 2012
Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...
2012-07-10
705 reads
SQL Audit 101 – Creating a basic audit
SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in...
2012-07-09
2,387 reads
SQL Server Auditing – Getting started
In my organization, one of my jobs is auditing our database environment. I’ve been tasked with this responsibility for several...
2012-07-03
1,861 reads
Goals – The end of one year, start of another
Just about a year ago, I talked about the importance of setting goals for yourself, both personally and professionally, making...
2012-06-25
1,028 reads
Slacking Off: The Right Side of the Brain
I think it’s only fitting to follow up a post about performance reviews and self-evaluations with a post about slacking...
2012-06-15
1,018 reads
Performance reviews – Self-evaluations
My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit...
2012-06-11
3,072 reads
PAGE_VERIFY – Checksum vs. Torn Page Detection
All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a...
2012-06-07
10,807 reads
SQLSaturday #164 Cleveland – Tick tock, people!
If you haven’t already heard, Cleveland is hosting SQLSaturday #164 on August 18. That date is coming up fast and...
2012-06-06
643 reads
Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?
Is it just me, or does there seem to be a lot of discussion these days about testing backups and...
2012-06-04
1,519 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
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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