What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
6 reads
Blog Posts
Aliases in SQL Server 2008
Recently I set up replication and as the target server was not on our domain I initially used an IP...
2010-09-20
982 reads
Breaking Into SQL Showbiz
You can tell by my face, I'm an expert
Matthew Velic (blog, Twitter) just asked this question on Twitter:
And really that’s...
2010-09-20
684 reads
Free SQL Server Training for the Week of September 20, 2010
Monday
PASS Data Warehousing/BI Virtual Chapter - Adaptive BI: Engineering a BI Solution - Davide Mauri
Tuesday
SQL Lunch - Restartability in SSIS - Kyle Walker
Pragmatic Works...
2010-09-20
647 reads
Home Theater Upgrades
Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home...
2010-09-20
609 reads
Kimball University: Microsoft Data Warehouse in Depth
Several years ago, late 2006, I decided to focus my career on Data Warehousing and Business Intelligence (DW/BI). I was...
2010-09-20
1,167 reads
Most SQL Server DBAs Still Don’t Know About Instant File Initialization
In my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers....
2010-09-20
904 reads
PASS Update #43
Last Friday saw the end of the 2010 PASS election and it was very nice to find out I had...
2010-09-20
629 reads
Review: Choosing to Cheat
Cross-posted from The Goal Keeping DBA blog.
I first heard about this book at SQL Saturday #51 when I was talking...
2010-09-20
866 reads
Roadtrip! SQL Saturday #53 - Kansas City
After speaking this coming weekend in Denver at SQL Saturday #52, I’m heading to SQL Saturday #53 in Kansas City...
2010-09-20
825 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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