OLE DB
|
97 results found, displaying items 1 - 20
|
Integrating with a Remote Database and Indexes
In this issue, I explain how to integrate SQL Server Express with other SQL Server installations, use indexes in tables to speed up data retrieval, and answer questions from readers about the Shared Memory Provider and view performance.
SQL Server Magazine
—
Michael Otey
SQL Server Express UPDATE--June 19, 2006:Integrating with a Remote Database, Indexes, Reader's Questions
In this issue, I explain how to integrate SQL Server Express with other SQL Server installations, use indexes in tables to speed up data retrieval, and answer questions from readers about the Shared Memory Provider and view performance.
SQL Server Magazine
—
Michael Otey
, et al.
Integrating SQL Server & Office 2003
All the major Microsoft Office 2003 applications include tools that let you incorporate and use data from a SQL Server database. These instructions for importing data into Word, Access, and Excel will get you started.
SQL Server Magazine
—
Michael Otey
Calling All COM Objects
SQL Server stored procedures and extended stored procedures perform a variety of database-related functions. Here are seven sp_OA stored procedures that you can use for OLE Automation.
SQL Server Magazine
—
Michael Otey
54 Administration Tips
Got a question about managing or tuning your SQL Server system? Check out this array of top tips--we've got the answers you're looking for.
SQL Server Magazine
—
Various Authors
34 Development Tips
If you develop database applications or you're simply looking for more efficient code for your SQL Server system, stop here. We've collected dozens of our best development tips in this issue--and more are on the Web!
SQL Server Magazine
—
Various Authors
|
[February 17, 2004]
|
|
38 Extra Development Tips
Our 5th-anniversary issue is bursting at the seams with great tips for SQL Server developers. Here are some that spilled out of our pages.
SQL Server Magazine
—
Various Authors
A Deeper Look at Drillthrough
Microsoft provides an example of how to create drillthrough support for Excel’s PivotTable components, but the example can be hard to follow. Here’s an explanation to help you use the example better.
SQL Server Magazine
—
Russ Whitney
ADO Connection Strings
These connection-string examples illustrate the seven most common connection scenarios.
SQL Server Magazine
—
Michael Otey
Reporting Services
SQL Server Reporting Services, set for release by the end of the year, will fill the only hole in the SQL Server product--the lack of a built-in reporting component. Here are Reporting Services' seven most important features.
SQL Server Magazine
—
Michael Otey
Swimming in the .NET Connection Pool
If you’re diving into ADO.NET, you might be wondering how you can use connection pooling to improve your applications’ performance. Here are some basic connection-pooling concepts you’ll need to know when you’re ready to get your feet wet.
SQL Server Magazine
—
William Vaughn
The Direct Connection
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.
SQL Server Magazine
—
Michael Otey
Managing Secure Database Connections with SQL Server
Learn how to use SQL Server to protect your valuable data and create and manage secure database connections.
Windows IT Pro
—
William Sheldon
Microsoft Releases MDAC 2.7 SP1
Microsoft announced the availability of Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 (SP1).
WinInfo
—
Various Authors
Patch Prevents Logins from Acquiring Unauthorized Rights
Microsoft reports that logins that use the SQL Server Authentication (Standard) security mode might be allowed rights that the login wouldn't normally have.
WinInfo
—
Various Authors
Analysis Services Interfaces
Learn about three of Analysis Services' programmatic interfaces that you can use from your analysis application.
SQL Server Magazine
—
Russ Whitney
Creating Indexed Views
Nick discovers that adding indexed views to a few of his queries to speed up performance changes the way the queries behave. Readers know just how to solve the problem.
SQL Server Magazine
—
Umachandar Jayachandran
SQL Server Magazine UPDATE, August 15, 2002
Read about Oracle support in the new .NET Framework Data Provider, a tip on using QUERYOUT with bulk copy program (bcp), and more!
SQL Server Magazine
—
Various Authors
Oracle Provider Might Boost .NET Success
Microsoft's .NET Framework Data Provider for Oracle boasts such smooth interoperability that you might start wondering how a homogenous environment could be any nicer.
SQL Server Magazine
—
Brian Moran
Microsoft Announces and Ships .NET Framework Data Provider for Oracle
The announcement goes a long way toward giving credence to Microsoft's commitment to industry cooperation and openness.
Windows IT Pro
—
Tim Huckaby
|
|
Register
