Presentation Slides For Hardware 201 at SQLSaturday #66 in Colorado Springs
I will be giving my Hardware 201: Selecting and Sizing Hardware for OLTP Performance presentation at SQLSaturday #66 at 1:30PM...
2011-02-12
860 reads
Glenn Berry
Windows Instant File Initialization and SQL Server
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-11
1,783 reads
Service Pack 1 for Windows Server 2008 R2 and Windows 7
Microsoft’s Brandon LeBlanc announced the upcoming availability of Service Pack 1 for Windows Server 2008 R2 and Windows 7 on...
2011-02-09
1,639 reads
Promoted to MSDB Rockstar Blogger
I just found out this morning that I was promoted from TempDB to MSDB on Thomas LaRock’s (blog|Twitter) Rockstar blogger...
2011-02-07
492 reads
Five DMV Queries That Will Make You a Superhero in 2011!
Way back in January, 2008, I wrote a blog post called “Five DMV Queries That Will Make You A Superhero!”...
2011-02-04
2,814 reads
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-02
1,930 reads
Building an Extremely Power Efficient Intel Sandy Bridge Desktop System
Since I have a 3.15Kw grid-tied Solar PV System on the roof of my house in Parker, I pay pretty...
2011-01-31
2,157 reads
Microsoft Support Policies for Windows Server and SQL Server
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack...
2011-01-31
4,842 reads
My Thoughts on the Intel Sandy Bridge Chipset Recall
I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I...
2011-01-31
2,166 reads
Speaking at the Rocky Mountain Tech Trifecta on March 5
I just got the notification that I will be one of the speakers at the Rocky Mountain Tech Trifecta on...
2011-01-28
680 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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