• Interests: Classical music (especially Bruckner and Shostakovich), beer, fishing, whiskey, theology, wine, trombone, martinis, not necessarily in that order.

Technical Article

Bitmap an Integer Value

Do you hate using bitwise operands?  I do, a lot.  I wrote the following function to try to minimize the need for using them.  When testing 'status' variables in the 'sysobjects' table, for example, I decided there just had to be an easier way to see if bit 31 is set than asking if STATUS […]

2003-03-07

415 reads

Blogs

Daily Coping 26 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Seeding an Availability Group Replica from Snapshot

By

Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...

Microsoft Build event announcements

By

There were a number of data platform announcements at Microsoft Build yesterday that I...

Read the latest Blogs

Forums

Account logging - pwd change/db access change

By Warren Peace

Is there a way to continuously log account changes? For SQL accounts log for...

Starting on Monday

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Starting on Monday

Charindex values of a substring inside a long sentence

By SQL_Hunt

I need to gather the starting position of the keyword "sql" from a sql...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers