Upgrading your databases link
I got the link from Kirk about the couse: http://www.maxtrain.com/classes/classInfo.aspx?id=SQLADV .
2006-02-02
1,323 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Upgrading your databases to SQL Server 2005 class
I attended a two day class this week that was fantastic. It was taught by the author of the course material,...
2006-02-01
1,291 reads
What's new with SSIS?
With the release of SQL Server 2005, there have been many changes in the product, but probably none as dramatic as the changes to the ETL tool. Data Transformation Services has become SQL Server Integration Services, or SSIS. It has been completely redesigned with a whole new paradigm for developing data movements. Kathi Kellenberger brings us a short introduction to this new tool.
2006-01-31
20,901 reads
Pro SSIS is Here!
My box of books arrived today! For me, a first-time author (actually co-author), this is very surreal. I remember it was...
2006-01-25
1,328 reads
Cast vs Convert
Sometimes you must "convert" a column or variable from one data type to another. For example, if you want to...
2006-01-23
1,804 reads
2005-12-29
2,045 reads
Cute comic
My son ran across this comic and was sure I would enjoy it: http://www.qwantz.com/index.pl?comic=153
2005-12-23
1,566 reads
Aggregate queries
Be sure to read my article on SQLServerCentral on building aggregate queries: http://www.sqlservercentral.com/columnists/kKellenberger/aggregatequeries.asp
2005-12-21
1,577 reads
2005-12-21
1,830 reads
Salary Survey
SQL Server Magazine has just published its annual salary survey. I don’t really recall how they did it in past...
2005-12-17
1,540 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