The Dog Died, and The Cat's on the Roof
Despite the title, this is a serious blog entry, dedicated to all you pet lover's out there. Although, I seek to...
2011-07-11
1,007 reads
Blog Posts
Upcoming Content Preview
It has been a few weeks since I last posted. I know, I’m a slacker, thanks for pointing that out. ...
2011-07-10
390 reads
Baseball and Scheduling Your Vacation, and a Puzzle?
I saw an article in the newspaper titled How to Visit 30 Ballparks in 35 Days This Summer. I think...
2011-07-08
668 reads
Brute-force searching for data.
Today, I needed a way of searching through a database, any database, looking for a certain string. The procedure I...
2011-07-08
3,812 reads
Count to 41
My children never cease to delight me in all kinds of ways, but never more when they come up with some...
2011-07-08
516 reads
Free SQL Server 2008 R2 Business Intelligence Training Course
If you are new to Business Intelligence (BI) and learn best by watching videos and “playing”, then this course is...
2011-07-08
5,214 reads
How to merge (combine) date intervals in T-SQL
On my current project, I am dealing with date intervals in T-SQL very heavily. I’ve hit interesting issue recently – how...
2011-07-08
2,161 reads
Learning From the Mistakes of Other DBAs
I have been a judge for the Exceptional DBA of the Year Awards ever since its inception, and one of...
2011-07-08
1,179 reads
Protected: Count to 41
This post is password protected. To view it please enter your password below:
Password:
2011-07-08
593 reads
Re-blog – July 1-July 7
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-08
460 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