The Cutting Edge
|
|
| G'day Developers! |
|
Collation is a great feature for international companies. However, if you are
not consciously using it then you should have all databases using a consistent
collation.
Collation is the combination of language and sort orders. Back
in SQL Server 7, you could only define the collation at the server level and,
once it was set, you could not change it without rebuilding the master
database. SQL Server 2000 added the ability to have 'Column Level Collation'
which allows you to set it at the database or column level. It is ideal for
those who only want the column name 'FirstName' to be represented in accent
insensitive sort order. If you are not taking notice of collation, one of the
side effects can be that you end up with many different collations on many
different databases .
More Rules to Better SQL Server Databases.
|
|
Cheers until next time,
Adam
SSW Chief Architect and Microsoft Regional Director, Australia
Got a comment for Adam? Email
Adam
|
|
SSW Tech Breakfast Special Offers
|
|
Refer someone new to our Tech Breakfast sessions and you can come along for
free! There are two sessions you can choose from; From Access to the
Enterprise on the 9th of November and eXtreme Programming for
.NET Developers on the 3rd of December. These sessions are
presented by Microsoft Regional Director
Adam Cogan.
You can
register online now or contact Rebecca either via
696e666f72407373772e636f6d2e6175
or on (02) 9953 3000. |
|
Sydney .NET User Group - The best place to learn
.NET for free in Sydney *(2 weeks late)*
|
|
|
Sydney
.NET User Group 3, November 2004 |
This months User Group has been postponed by 2 weeks as Adam is climbing the
Western Breach of Mount Kilimanjaro in Tanzania, Africa - lucky guy!
The content for the User Group will be emailed to you at a later date.
|
|
Wednesday 3rd November. 6:00 pm at Microsoft, 1 Epping Road North Ryde
>See You There!! |
Sorry I can't make it
|
|
Extreme Programming Article - Simon Sharwood
|
|
|
eXtreme Programming has emerged as a grassroots solution to software
development cost blowouts. Simon Sharwood reports on a process thats turning
the developing world upside down.
"In October 2002, NSW treasurer Michael Egan asked his auditor-general to
investigate a software development project at publicly-owned Sydney Water,
Australias largest water services provider."
|
|
SSW .NET Toolkit
|
|
|
 Develop
Applications More Efficiently with the SSW .NET Toolkit
The SSW .NET Toolkit is an example of a distributed multi-layer
application based on the Microsoft Northwind database. Designed by Developers
for Developers, the real-world source can be used as a model and basis for
custom-designed applications perfect for small and medium enterprise (SME)
applications. Microsoft's examples like
Duwamish  and
IBuySpy
are code intensive and marketed towards architects, not developers. The SSW
.NET Toolkit delivers more functionality using less code.
The .NET Toolkit contains two parts. Part A demonstrates how to
use extended providers for validation, and how to implement searching through
records in a database. Part B shows how to implement SSW Exception Reporter an
extended version of the Configuration Block. More on
SSW .NET Toolkit
|
Tips
|
|
|
I want to generate a script
that updates a column on every table in my database. How do I do this? -
answered by David Klein.
|
|
|
How do I get the type name
of an object using COM Interop? I just get System.__ComObject returned when
using .gettype() - answered by David Klein.
|
