SQL PASS Summit 2009 – Parting Thoughts
So now that we’re 7 days removed from the end of the SQL PASS summit, I’ve finally managed to arrange...
2009-11-13
834 reads
Blog Posts
SQL Server 2008 Database Mirroring in Action
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-13
1,320 reads
Super Seven Cleanup Steps Before Deploying Your Cube
Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the...
2009-11-13
1,785 reads
Why We Recommend Against xp_cmdshell
Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...
2009-11-13
21,109 reads
Book Review: The Machine, The Story of the 1975 Cincinnati Reds
I grew up watching baseball on TV and playing it too, and for reasons I don’t recall my Dad’s favorite...
2009-11-12
538 reads
Flight or Invisibility: Which do you Choose?
A colleague of mine pointed out a great podcast called This American Life - specifically an episode with John Hodgman (the...
2009-11-12
1,051 reads
How did I become a DBA
This past Tuesday night I had the honor of speaking to a small group of college students who are all...
2009-11-12
783 reads
Looking Back – PASS Summit 2009 Day 4
Thursday started off with a meeting of the SQL Saturday minds over breakfast at Top Pot Donuts a few blocks...
2009-11-12
878 reads
New HP Envy 15 Laptop
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...
2009-11-12
1,954 reads
PASS Summit 2009 – Keynotes
I’m not going to look back at the keynotes since I blogged about them. If you are interested, you can...
2009-11-12
768 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