Book Review - The Human Edge
I've always enjoyed the science fiction writings of Gordon Dickson, and recently re-read an old copy of The Human Edge,...
2009-02-16
858 reads
Database Mirroring FAQ: If the principal fails while running in high performance mode, what options do I have for bringing the mirror online?
Question: If the principal fails while running in high performance mode, what options do I have for bringing the mirror...
2009-02-16
4,555 reads
Be Careful with String Concatenations in SQL Server with Big Strings.
Now, we are going to get slightly esoteric here. I'd noticed that the performance of string concatenation tasks didn't increase...
2009-02-16
14,609 reads
Recharged
It’s rare that I’ve taken vacation in the last few years. In fact, when I took an unwired week in...
2009-02-16
716 reads
Networking - Part 5
You can read the previous posts here. To finish up my thoughts on networking I want to brain storm some...
2009-02-15
632 reads
The Importance of the Segregation of Duties with Respect to Internal Controls
I diverge a little from the typical coding-based/oriented best practice to one that is focused on governance within public or government organisations...
2009-02-15
7,919 reads
Which is Better: Heaps or Tables with Clustered Indexes?
I have always been of the personal opinion that all SQL Server tables have a clustered index. As part of...
2009-02-13
4,298 reads
Another Reason to Avoid Cross-Database Ownership Chaining
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,163 reads
SQL Injection - It's Not Just Me!!
I have a personal web site I set up years ago, mainly so I could post stuff for my extended...
2009-02-13
835 reads
Color E-Ink
I love my Kindle, but it uses an older e-ink technology that's a little slow and doesn't support color. Not...
2009-02-13
981 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 Kantor Bank BCA KCU CILACAP Telp:08218154393
WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
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