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,312 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,278 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,882 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,323 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,791 reads
2005-12-29
2,039 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,558 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,571 reads
2005-12-21
1,825 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,534 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers