SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump.
Just like a water pump, you...
2009-04-13
1,229 reads
Blog Posts
PASS Connector Editorial For March 25, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-12
304 reads
What's my (fully qualified domain) name?
What's my name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring...
2009-04-11
9,417 reads
You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially....
2009-04-11
1,415 reads
No Opening Day
For the second year in a row I didn’t purchase opening day Rockies tickets. I had a nice streak of...
2009-04-10
795 reads
Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,777 reads
Book Review: Red Lightning
Back in December 2008 I wrote up a quick review of Red Thunder, and then received Red Lightning as a...
2009-04-09
284 reads
My Kingdom for a Port
A Port, a Port! My Kingdom for a Port!!
One of the steps in setting up database mirroring is to assign...
2009-04-09
1,062 reads
My Mini Identity Protection
Last week, on April Fool’s Day, I woke up to find quite a few birthday congratulations in my email. I...
2009-04-09
385 reads
NULL is not = to anything
One of the fun facts about SQL Server and the relation model is the
whole concept of three valued logic. Now...
2009-04-09
1,107 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