Speaking at SQLSaturday #66 in Colorado Springs on February 12
I recently found out that I will be one of the speakers at SQLSaturday #66 on February 12 in Colorado...
2011-01-21
699 reads
Glenn Berry
Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2
Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...
2011-01-18
2,619 reads
New Cumulative Updates for SQL Server 2008 SP1 and SP2
Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of...
2011-01-18
701 reads
Denver SQL Server User’s Group Meeting on January 20, 2011
My good friend, Kevin Cox, of Microsoft’s SQLCAT (SQL Customer Advisory Team) will be giving a presentation on what is...
2011-01-14
559 reads
How to Obtain and Install SQL Server Service Packs and Cumulative Updates
If you are in charge of one or more SQL Server instances, whether they are on a laptop, or a...
2011-01-12
2,908 reads
Intel Processor Information
Here is a small collection of links to tools for measuring and evaluating mobile and desktop processors, along with some...
2011-01-11
1,210 reads
Fun with Extended Properties in SQL Server 2008
Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty...
2011-01-10
3,394 reads
My First Sandy Bridge Desktop System
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...
2011-01-10
1,397 reads
Bad DBA or Bad Developer?
I was browsing a public web site from a large company today, when I saw the error page shown below. ...
2011-01-08
670 reads
Microsoft Certified Master in SQL Server 2008 Knowledge Exam
I woke up bright and early this morning to take the beta version of the Microsoft Certified Master in SQL...
2011-01-08
968 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