Building Better VMs
The other day I fired up my old desktop, intending to use it as background in the podcasts. It gave...
2008-07-22
1,000 reads
Blog Posts
Disabling Indexes Published on SQLServerCentral.com
It's been a while since I had anything up on SSC, a combination of Steve being in good shape on...
2008-07-22
488 reads
Tool Review: Password Safe
I think we all struggle to keep up with various credentials needed to live our internet lives (single sign on...
2008-07-21
544 reads
Delayed gratification
Call me odd, but I enjoy taking certification tests. It may be that I've always tested well, or perhaps it's...
2008-07-20
667 reads
Why Are Stored Procedures Too Hard?
Recently I was going through the buy or build process on a small segment of functionality needed for a project,...
2008-07-20
855 reads
Patching
Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS...
2008-07-19
1,912 reads
Follow Up Notes on the Custom Whiteboard
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
513 reads
JSSUG Speaking Event: Reporting Services 2008
We had a great group of about 35 people last night at the JSSUG (Jacksonville SQL Server User Group) meeting....
2008-07-17
715 reads
Tools
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,176 reads
Comments on Dissecting SQL Server Execution Plans by Grant Fitchey
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,360 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