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,283 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,885 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,796 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,559 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,572 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,535 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers