Smart As A Bear?
I got this at Hobby Lobby for $7 on sale, it’s about the width of a license plate and a...
2014-05-14
312 reads
SQLAndy
Warrant Canaries & Transparency
I recently ran across the warrant canary FAQ from the Electronic Frontier Foundation (EFF). The concept is simple – put up...
2014-05-14
550 reads
Announcing the 2014 SQLSaturday Orlando Seminars
On September 25, 2014 we’re pleased to have David Pless presenting an all day seminar on Enterprise Management and Monitoring...
2014-05-13
370 reads
Verizon PCI and Data Breach Investigation Reports
If you deal with security and especially credit cards it’s worth spending an hour or two to read the 2014...
2014-05-13
441 reads
Writing Another Question of the Day
The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...
2014-05-12
355 reads
Notes From SQLSaturday #298
The trip didn’t start smoothly for this one. Wed night I was really sick with some kind of stomach flu....
2014-05-12
427 reads
Off to Jacksonville for SQLSaturday #298
I’m looking forward to returning to Jacksonville after missing a year (or two?) to speak at SQLSaturday #298. I’m driving...
2014-05-09
338 reads
Speaking at MagicPASS on May 28, 2014
If you’re wondering who the mystery speaker is – it’s me! I’ll be doing two presentations at Magic Pass on May...
2014-05-08
339 reads
Another User Has Locked My File!
I had an SSIS package fail in a script task this morning. As part of the why process I opened...
2014-05-07
346 reads
Datatypes In Your Mind–Question Of The Day
My latest question Datatypes In Your Mind is live today and it’s generated quite the discussion. I wrote here about...
2014-05-06
470 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
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