SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2009-11-07
2,758 reads
Blog Posts
Tampa Code Camp 2009
I presented a 1 hr session at Tampa Code Camp 2009: PowerShell for Developers In this sesssion we will look...
2009-11-07
653 reads
Thursday at the PASS Community Summit
The last full day of the 2009 PASS Community Summit was the first day I have had at the conference...
2009-11-07
697 reads
Worldwide Operating System Market Share for October 2009
Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already...
2009-11-07
1,455 reads
Geek of the Week
I made geek of the week. I’m sorry, but I’m excited by that. I’m very proud to be a geek....
2009-11-06
647 reads
Great Post on Parallel vs.. Series SSIS
Mike Davis, Author and consultant extraordinaire recently posted a great new take on parallel vs. series SSIS packages. Some interesting...
2009-11-06
523 reads
Identity Issues
Have you ever received the following Error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-11-06
359 reads
Montreal as a City State: Can a DBA Go Beyond their Workplace to Provoke Change in their Region?
I am very impressed with Michel David’s work, and openly endorse much of his great piece of work at MontrealCityState.ca...
2009-11-06
1,751 reads
OFF-TOPIC: Surviving, Missing Folks, Glad I'm Home
I certainly wish circumstances were different and I would have been able to attend the PASS Summit this week. I...
2009-11-06
732 reads
PASS Summit 2009 Day 3
The day started off with a mixed bag. First we had an honestly tearful farewell with Wayne Snyder saying goodbye to...
2009-11-06
1,530 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