The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Does your organization run multiple database engines? Think teamwork! In this issue, see how linked servers can open a dialog between SQL Server and Oracle, learn how DTS can bridge the gap between SQL Server and the AS/400, and much more.
By Michael Otey
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
Microsoft's SQL Server development team explains how to import Word documents into SQL Server, then index them.
By Carolyn Mader
Check out the latest SQL Server-related new and improved products.
The multiple-member file concept in AS/400 databases can cause problems when you want to transfer data to SQL Server. Here's the solution.
By Brian Moran
Many people forget that UDP port 1434 needs to be open to ensure that you can correctly access and browse names instances.
One of the most dangerous system attacks--SQL Injection--is code-based, and defending against it falls squarely on the application developer's shoulders.
Here are seven important features for database developers in Visual Studio .NET 2003.
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.
Here are some common problems you might encounter when configuring the Oracle client and how to overcome them.
By Itzik Ben-Gan
Can a cursor really out-perform a set-based solution? Put your skills to the test in calculating maximum concurrent sessions.
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 Kalen Delaney
See what's going on inside your large data object storage.
By Russ Whitney
In analysis, it's important to separate relevant data from irrelevant data. Write an MDX query that finds the top five product names in each product department in the FoodMart 2000 Sales cube.
Challenge yourself to write an MDX query that returns data for a control chart. Then, display the query as a line chart.
By Michelle A. Poolet
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.
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.
A sample script shows how to remove extraneous spaces from a char column.
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.
Readers offer a different way to gather database space-usage statistics and ask about advantages of moving metadata from tables to extended properties.
advertisement