Object Grouping Best Practices: Using Schemas for Logical Separation
Originally written in French last year, now revised for you in my native language below:
You've probably all noticed a change...
2009-07-06
3,497 reads
Blog Posts
Presenting at SQL Saturday Baton Rouge
I'll be presenting two sessions at the SQL Saturday event in Baton Rouge on August 1. I'll be presenting a...
2009-07-06
482 reads
Recovering Missing Templates in Visual Studio
Recently I decided to expand my coding knowledge and picked up a Visual Basic book. I’ve been working in this...
2009-07-06
785 reads
Richmond SQL Server Users Group
Actually a combination meeting of the Richmond .NET and SQL groups, put together for me. They normally meet on consecutive...
2009-07-06
740 reads
So Now I’m Gilligan, Finally
Okay I was tagged by Tim Mitchell on the Deserted Island scenario started by Tim Ford which goes like this:
So...
2009-07-06
490 reads
SQLSaturday Blog Launched
Since the beginning of SQLSaturday I’ve covered most of the news here on my blog, beginning this week I’ll be...
2009-07-06
464 reads
Fourth of July
Read the Declaration of Independence and then it’s time for fireworks and grilling, maybe some apple pie too!
2009-07-03
504 reads
Book Review: Rolling Thunder
Rolling Thunder ($7.99 @ Amazon) by John Varley is the third book in the series. I previously reviewed Red Thunder and...
2009-07-02
703 reads
HP Mini Netbook – Day 2
I arrived in Richmond, VA this morning earlier than expected. I was meeting a few people and things were pushed...
2009-07-02
1,463 reads
How to Become an Exceptional DBA, 2nd Edition, Now Available Free
About a year ago, the first edition of my book, How to Become an Exceptional DBA, was published. It was...
2009-07-01
1,815 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