Powershell to Automate SQL Compare
A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...
2011-01-31
4,285 reads
Blog Posts
Presentations Materials From Last Week
Last week I spoke at the PASSMN meeting here in Minnesota and then via a webcast to the Edmonton PASS...
2011-01-31
1,375 reads
SQL Lunch - Introduction to Change Data Capture
Join me tomorrow for a little CDC.
#47-Introduction to Change Data Capture
Speaker: Patrick LeBlanc
Add To Outlook: Add To Calendar
Meeting URL:https://www.livemeeting.com/cc/usergroups/join?id=269DRP&role=attend
Date and...
2011-01-31
1,970 reads
SQL Rally 2011 Voting - Reporting Services Boot Camp
All,
Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every...
2011-01-31
1,542 reads
SQL Saturday #57 – Houston
SQL Saturday #57 was this weekend! Sean and I went, talked, webshow-ed, and then presented a total of SIX sessions!
Travel
Sean and...
2011-01-31
1,645 reads
SQLSaturday, Rocky, and a CheeseSteak - Upcoming Event
As you know, the SQLSaturday sensation has exploded all over the nation. So many events scheduled this year, there is...
2011-01-31
2,107 reads
31 Days of SSIS – Exporting Execution Plans (29/31)
31 Days of SSIS
A day late for the twenty-ninth post of the 31 Days of SSIS, but it is still...
2011-01-30
2,378 reads
Invest in Yourself
Hey folks. I think we can all agree that there is some really quality training available for free on the...
2011-01-30
1,442 reads
I've been in Alabama
Let me start of by saying I could have taken this picture in Florida. But I didn’t. I was in...
2011-01-30
1,316 reads
SQL Lunch #48 Advanced SSIS Tips & Tricks
I had the privilege of giving a SQL Lunch presentation today. The slide deck for that can be found here:...
2011-01-30
1,896 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