SQL Server Waits and Queues
Useful link. This is a great best practice article/white paper from Tom Davidson and Danny Tambs.
The word document (880kb) can...
2010-02-07
588 reads
Blog Posts
A New Season (A Networking Success Story)
I’d like to share a networking success story. Last year, I blogged about my experience at the PASS Summit of...
2010-02-05
1,182 reads
Another free tool for SQL Server...
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that...
2010-02-05
1,130 reads
Interviewed by Andy Leonard
As I mentioned earlier in the week I had promised Andy an interview, we finished it up yesterday and the...
2010-02-05
350 reads
Log is Filling Up
Today I ran across Paul Randal’s latest post showing how to find open transactions and such. This is a nice...
2010-02-05
528 reads
My Reading List
A couple weeks back I asked for reading suggestions, and I got a bunch! Here’s the list so far:
Wizard’s First...
2010-02-05
431 reads
PASS 2009 DVDs
I was really excited when my PASS DVDs arrived last week. I had purchased the DVDs (or maybe CDs) back...
2010-02-05
949 reads
Speaking in Portland, OR and Tumwater, WA the Week of February 8th
I’ll be speaking in Portland, OR and Tumwater, WA the week of February 8th, 2010. The details, and the session...
2010-02-05
375 reads
SQL Server 2008 R2 Update for Developers Training Kit
It is a good news for developers! Microsoft published the Training Kit for SQL Server 2008 R2.
The content of...
2010-02-05
590 reads
SSRS Commonly Required Date Expressions
Reporting Services has many expressions that can manipulate date fields. These expressions can be used just about anywhere in SSRS...
2010-02-05
5,869 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