Notes from the Orlando Code Camp March 2010
I arrived about 7:15 and already quite a few people on hand. Registration was moved to inside this time, just...
2010-03-29
972 reads
Using Custom Connection Colors in SSMS
One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was...
2010-03-29
3,974 reads
To Get Certified or Not Get Certified
I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think...
2010-03-29
932 reads
TempDB – Relocate the TempDB Database Files
I took control of a new server recently and noticed that Tempdb was not configured to best practice. It was...
2010-03-28
1,294 reads
DBCC INPUTBUFFER vs fn_get_sql
Someone asked a question in the forums the other day and I realized it would make a pretty decent blog...
2010-03-28
8,774 reads
Making Sense of Replication Errors in Replication Monitor
Making Sense of Replication Errors in Replication Monitor If you've ever had to deal with errors in Replication Monitor, your first...
2010-03-27
12,086 reads
SQL Server Social Group a Fresh Perspective on User Group Meetings
The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type...
2010-03-27
474 reads
So you want to write a blog?
First, figure out what you want to write about. It should be something you have passion for. And it should...
2010-03-27
1,536 reads
SQL Saturday #29 Presentations & Twittering
Tomorrow, I’m presenting a couple of sessions at SQLSaturday #29 in Birmingham, Alabama. Here are the presentation materials I’ll use.
SQL...
2010-03-26
562 reads
Cross Apply Ambiguity
Cross apply (and outer apply) are a very welcome addition to the TSQL language. However, today after a few hours...
2010-03-26
1,936 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
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 ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BCA KCU BENGKULU TLP/WA 08218154374
Hub Cs:08218154374 Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu...
ALAMAT BCA KCU BUKITTINGGI TLP/WA 08218154374
Hub Cs:08218154374 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi,...
ALAMAT KANTOR BCA KCU PADANG TLP/WA 08218154374
Hub Cs:08218154374 Jl. H. Agus Salim No.10 A, Sawahan, Kec. Padang Tim., Kota Padang,...
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