SQL Server Magazine March 2003
[Focus]
Transferring data between SQL Server and other platforms such as the AS/400 isn't as tricky as it seems-- as long as you use DTS.
By Michael Otey
Many businesses run SQL Server and Oracle side by side but independently. Here's how you can open a dialog between the two and really get the information flowing.
By Michael Otey
[SQL Server Savvy]
Many people forget that UDP port 1434 needs to be open to ensure that you can correctly access and browse names instances.
By Brian Moran
You can't observe the performance of your system without affecting the system's performance so make sure you understand the impact that you're having, that the impact is reasonable, and it isn't excessively skewing your results.
By Brian Moran
Be careful when you're handling dates in SQL Server and make sure you understand how SQL Server handles date value comparisons so that your code is prepared.
By Brian Moran
[Editorial]
One of the most dangerous system attacks--SQL Injection--is code-based, and defending against it falls squarely on the application developer's shoulders.
By Michael Otey
[SQL Seven]
Here are seven important features for database developers in Visual Studio .NET 2003.
By Michael Otey
[Inside SQL Server]
See what's going on inside your large data object storage.
By Kalen Delaney
[Mastering Analysis]
Analysis Services natively supports many aggregation types, but sometimes you need to perform an aggregation that native types can't handle. Here are some ways you can use non-native aggregation types to solve real-life calculation problems.
By Russ Whitney
[Solutions by Design]
In a goods-and-services business, a complicated database structure can make customer invoicing harder than it has to be. Here’s a real-life example of how a simpler architecture makes it easier to serve customers.
By Michelle A. Poolet
[T-SQL Black Belt]
Can a cursor really out-perform a set-based solution? Put your skills to the test in calculating maximum concurrent sessions.
By Itzik Ben-Gan
[Answers from Microsoft]
A sample script shows how to remove extraneous spaces from a char column.
By Microsoft's SQL Server Development Team
Microsoft's SQL Server development team explains how to import Word documents into SQL Server, then index them.
By Microsoft's SQL Server Development Team
[Letters]
Readers offer a different way to gather database space-usage statistics and ask about advantages of moving metadata from tables to extended properties.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
