New Book from Celko - Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in...
2008-02-20
1,528 reads
Blog Posts
A Welcome Delay
I get a bit of a delay in working on the set down in the basement thanks to the weather....
2008-02-19
1,402 reads
Dry Erase Board v2
When we first set up shop for End To End Training we knew we wanted both a flip chart and...
2008-02-19
1,604 reads
Errata for SQL Server Certification Books
Back in this blog post, I indicated which books I was using to complete the MCITP certifications for SQL Server....
2008-02-19
1,734 reads
How Stable is SQL Server 2005?
I've been calling for Service Pack 3 and I've been debating the need, the criticality, and even the problems with...
2008-02-19
1,530 reads
SQLSaturday #3 - Jacksonville 2008 - Registration and Call for Speakers is Open
My business partnerBrian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University...
2008-02-19
1,218 reads
Ideas for Managing Cables
I had to run all the cables for all the machines in our classroom recently and you know how messy...
2008-02-18
1,459 reads
Management Article Posted on SSC
I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for...
2008-02-18
651 reads
SQLSaturday #2 (Tampa 2008) Notes
Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very...
2008-02-18
1,414 reads
Turning off a server causes a flood of memories
I just shut down a SQL Server that has been in production since 2003. Next week I'll let the server...
2008-02-17
401 reads
Blogs
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
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...
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