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,321 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,290 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,897 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,327 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,803 reads
2005-12-29
2,044 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,576 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,539 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers