When training is just that good!
I have the privilege of attending SQL Skills Immersion Event week one in Atlanta GA this week. My expectations were...
2011-12-08
505 reads
Blog Posts
A DBA is a Data Professional
By Grant Fritchey
http://www.scarydba.com/
A DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of...
2011-12-07
2,260 reads
Create SQL Server scripts with Visio 2010
If you are using Visio 2010 and creating tables via the Database Model Diagram template, you may be surprised to...
2011-12-07
2,326 reads
DBA in Space: Behind the Scenes—Question 13
Part 1 of Question 13: The Question.Part 2 of Question 13: The follow up to the question.This is a continuation...
2011-12-07
619 reads
December AppDev Webcast
The new year is just around the corner. And before you know it, we’ll have an opportunity to start moving...
2011-12-07
524 reads
First Thoughts on the Kindle Fire
My perception of the tablet market has been that the iPad is king, but at a kingly price. If I...
2011-12-07
799 reads
MCITP: 4 Down 0 To Go
Yay. I finally took the plunge and decided to take Exam 70-451. This is the MCITP exam for the SQL 2008 Dev track. Frankly, I had taken my time with...
2011-12-07
6 reads
MCITP: 4 Down 0 To Go
Yay. I finally took the plunge and decided to take Exam 70-451. This is the MCITP exam for the SQL...
2011-12-07
599 reads
Setup Alerts for PBM
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In...
2011-12-07
1,642 reads
SQL Server Latency
Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component...
2011-12-07
1,833 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