Presenting Hardware 301 at 24 Hours of PASS on September 7
PASS just announced today the next occurrence of 24 Hours of PASS (24HOP), which is called the Summit Preview version....
2011-08-03
770 reads
Glenn Berry
August 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is August 1, 2011 (which is also my birthday), I thought it would be a good time to...
2011-08-01
1,029 reads
SQL Server Hardware Book News and Reviews
Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very...
2011-07-29
1,484 reads
Some Common Disk Drives Compared
Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of...
2011-07-27
1,117 reads
Leaked Information About AMD Opteron 6200 Series Processors
CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are...
2011-07-26
1,031 reads
Building or Buying a High Performance, Low Cost Desktop Machine for SQL Server Development and Testing
There was a lengthy discussion on Twitter this morning, where one of my friends, Grant Fritchey (Twitter) was asking the...
2011-07-24
1,733 reads
Microsoft SQL Server 2008 SP2 Cumulative Update 5 Released
Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 2. This CU has ten fixes listed in...
2011-07-18
1,578 reads
SQL Server 2008 R2 Service Pack 1 Released
Microsoft has finally (after releasing the CTP version way back in April) released the final, gold build of SQL Server...
2011-07-12
2,645 reads
Teaching Transact-SQL at University of Denver, University College
Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...
2011-07-12
615 reads
July 2011 Version of SQL Server 2008 Diagnostic Queries
Since July is only one day away, its time for the updated version of my SQL Server 2008 Diagnostic Information...
2011-06-30
1,636 reads
Blogs
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...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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