Third Party Backup Tools – Redgate SQL Backup
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,905 reads
Gethyn Ellis
T-SQL Tuesday #005 – Offloading Reporting (#TSQL2sDay)
Aaron Nelson (Blog|@SQLvariant) is hosting this months #TSQL2sDay with the theme of reporting. My post looks at some of things...
2010-04-13
670 reads
db_executor role
This process might not be granular enough for some but there is a nice simple way of creating a role...
2010-04-12
35,997 reads
Q1 - review
I didn’t post my professional goals for the year on my blog at the start of this year, my blog...
2010-04-08
674 reads
Uninstall 64 bit and reinstall 32 bit SQL Server
For reason's beyond the scope of this post I needed to uninstall a 64 bit version of SQL server standard...
2010-04-06
2,472 reads
Differential Backups
My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log...
2010-04-04
1,299 reads
Powershell – Useful Resources
One of my aims at the start of the year was to improve my Powershell and scripting skills. I run...
2010-04-01
1,143 reads
Managing Your Backup Files
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-31
1,271 reads
SP_change_users_login and SQL Server 2008 onwards
Today I discovered, from a post on the forums and a follow up dig into BOL that sp_change_users_login is to...
2010-03-30
5,804 reads
Scheduling backups in SQL Server Express
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always...
2010-03-29
1,706 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