The Exceptional DBA’s Code of Conduct
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
731 reads
Blog Posts
Two Tools For Discovering Hardware Information About Your Servers
One thing that I think is very important for a successful DBA to be aware of is their hardware environment. ...
2009-12-21
1,299 reads
Webcast: SQL Server 2008 R2 Support for Up to 256 Logical Processors
If you are a low-level, bare-metal type of SQL Server geek, you will probably enjoy watching this 60 minute webcast...
2009-12-21
655 reads
String Manipulation - CHARINDEX()
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-19
4,440 reads
Anaylsis Services Partitions and Aggregations PASS Session
For a little more than a year now I've been a part of the PASS BI SIG and have tried...
2009-12-18
431 reads
Have Lunch with Me
I know you all are clamoring for the opportunity to have lunch with me so I agreed to do a...
2009-12-18
342 reads
iPhone Stockholm Syndrome?
I’m not sure it’s true. I don’t think I have iPhone Stockholm Syndrome, as suggested by the article. It’s actually...
2009-12-18
1,472 reads
Stop Splashing with –NoSplash
Many times when I'm teaching a class or working with a group, they express frustration at the load time for...
2009-12-18
487 reads
Taking Notes When You Don't Have a Computer
Yesterday I talked about taking notes using Google Docs. It's a great way if you've got multiple systems (especially with...
2009-12-18
1,563 reads
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,262 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
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...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
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