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,761 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,082 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,820 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
840 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,150 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,546 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,826 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,066 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
292 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers