Technical Article

SQL Server Webinar Series #9: Streamlining SharePoint Recovery

Metalogix Selective Restore Manager streamlines the process of finding and recovering individual documents and lists directly from a SharePoint content database backup file without the need for a recovery farm. When used in conjunction with Red Gate’s SQL Virtual Restore, Selective Restore Manager can recover documents and lists without physically restoring the backup file—saving time and much needed disk space. Together, Metalogix Selective Restore Manager and Red Gate SQL Virtual Restore open up new possibilities for your SharePoint backup and recovery strategy. Apr 21, 2011, 11am EST.

Technical Article

Database Normalization Webcast

Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used among DBAs at an employer. See the changes he made after joining the BI group at this employer. The session will go through naming conventions, check list for creating a table, formatting in stored procedures, and more. A brief preview of the SQLRally talk 3rd Normal Form: That’s Crazy Talk!!! Will be given about Lookup tables. Thur, Apr 21, 2011, 12:00pm EST.

SQLServerCentral Editorial

Careful Blogging

This editorial was originally published on Sept 22, 2005. Steve Jones talks about the dangers of blogging about your job and with your company. Be sure that you are aware of what the impact of your posts will be on your image.

Blogs

Learn about Modern Microsoft Apps in San Diego

By

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

Fabric has CI/CD built in, but if you've tried to use it for database...

A New Word: Attriage

By

attriage – n. the state of having lost all control over how you feel...

Read the latest Blogs

Forums

SSRS Reminded Me of the Time Microsoft Retired TMG

By Marko Coha

Comments posted to this topic are about the item SSRS Reminded Me of the...

Getting results from a Procedure to join to a query

By bswhipp

I have a need to execute a stored procedure and return the results to...

Upgrade 2016 Standard to 2022 Express

By pdanes

Title pretty much says it all - can this be done? I've tried several...

Visit the forum

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       NULL
What is returned when I run this code: 
select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers