The Basic Truths about Data
In reviewing database development best practices recently I'm reminded of an attitude I've found prevalent in many development shops, that...
2009-08-03
397 reads
Blog Posts
What's new in Sql Server 2005
Its very difficult to write what all new in Sql server 2005, almost everything is new... the complete engine has...
2009-08-03
722 reads
Brian Knight’s Texas Tornado Tour!
Its been fun and fulfilling getting neck deep into the Central Texas Capitol Area Users of SQL Server again after...
2009-08-02
498 reads
Fusion-IO Update
I’ve done all the testing I can do for now. There were some unexpected developments that I will cover in...
2009-08-02
555 reads
LinkedIn References
One of the interesting features of LinkedIn is the ability to post a reference about a connection. If you think...
2009-08-02
869 reads
Active August #1
I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number...
2009-08-01
621 reads
Active August posts
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
2009-08-01
1,123 reads
Revive your User Group, part IV
Over the past three posts in this series entitled “Revive your User Group”, I’ve shared some of best practices that...
2009-08-01
521 reads
Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,414 reads
Heading to N'Awlins
I'm leaving today for SQLSaturday #17, actually in Baton Rouge. I'll be at the speaker party tonight and hope to...
2009-07-31
1,553 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