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
Blog Posts
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
PASS Summit 2009 Call For Speakers Extended - And Why
Please consider this a not quite official announcement, look for that on the sqlpass.org site today or tomorrow.
You may have...
2009-04-09
1,211 reads
Prius Repair Update
We decided to let the pros replace the seat belts and do the other repairs and file a claim on...
2009-04-09
371 reads
Blogs
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...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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