Knight's Microsoft Business Intelligence 24-Hour Trainer released
Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release. In this book you will learn about...
2010-09-28
958 reads
Blog Posts
Lessons from a Great Mentor
On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He...
2010-09-28
921 reads
Open-Source Databases are Not Free, MySQL has a High Cost, According to MySQL.com Itself
After having a few heated discussions on Facebook in reference to Open-Source Relational Databases, I would like to refer those...
2010-09-28
1,188 reads
Performance Tuning Analysis Services (SSAS) Webinar Today
Thanks for coming to today's webinar. We had a great turnout and hope to see you again soon. I have...
2010-09-28
441 reads
Performing a Cross Join (Cartesian Product) in SSIS
There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS. One of...
2010-09-28
4,367 reads
SQL Saturday#52 – Colorado Recap
This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it,...
2010-09-28
2,014 reads
SQLSaturday #52 Report
I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate,...
2010-09-28
544 reads
To Be There Or Not To Be There
Are you ready for Seattle? Have you registered for the PASS Summit? Hopefully with some good reasons you will be...
2010-09-28
679 reads
Windows Power Plans and CPU Performance
Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans...
2010-09-28
2,253 reads
Can Deadlocks be Resolved by Adding an Index?
Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.
First, let me...
2010-09-27
1,358 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