Hotfix for SQL Server 2008/2008 R2 Periodically Does Not Accept Connections Bug
Microsoft has released a hotfix for a very frustrating issue that plagued me for a couple of years at NewsGator. ...
2011-11-26
9,770 reads
Glenn Berry
Speaking at Spring 2012 SQL Server Connections in Las Vegas
I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas,...
2011-11-23
1,094 reads
SQL Server 2008 Service Pack 2 Cumulative Update 7 Released
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 7, which is Build 10.00.4323.00. I count 18 fixes...
2011-11-22
1,830 reads
SQL Server 2008 Service Pack 3 Cumulative Update 2 Released
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 2, which is Build 10.00.5768.00. I count only 3...
2011-11-22
1,794 reads
Tuesday Hardware Tidbits, Nov 15, 2011
A couple of interesting developments this week. First, Intel has officially released (and lifted the embargo) on their new high-end,...
2011-11-15
848 reads
OT: Amateur Astronomy
Back in 1997, when the Mars Pathfinder bounced down on Mars on July 4, releasing the little Sojourner rover to...
2011-11-12
1,162 reads
SQL Server 2012 Licensing and Hardware Considerations
Last week, Microsoft announced some pretty fundamental changes in how SQL Server 2012 will be licensed compared to previous versions...
2011-11-11
5,552 reads
Eighty Logical Cores of Goodness!
I recently had the opportunity to specify the purchase of a couple of Dell PowerEdge R810 2U servers that will...
2011-11-09
1,831 reads
Tuesday Hardware Tidbits
There have been a few interesting developments on the hardware front over the past week that I want to cover...
2011-10-25
1,067 reads
Don’t Economize on Processors for Database Servers
In this guest editorial, Glenn Berry argues that, when designing your servers, you need to budget for processing power as your primary concern.
2011-10-24
301 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