Data Analytics and Data Management

Read through for comprehensive resources on data analytics and data management.

Enter your email above to receive messages about offerings by Informa, its brands, affiliates and/or third-party partners, consistent with Informa's Privacy Policy.

Leave this field blank

How can I run a DTS package from within SQL Server - e.g. a stored-procedure? - 11 May 1999

May 10, 1999

A. You can either :...

How can I get file information using SQL Server?

May 10, 1999

A. Using the undocumented xp_getfiledetails procedure :...

If I lose my data file (MDF) in SQL 7 I can't backup the log to recover to a point in time - why not?

May 10, 1999

A. A small oversight on MS's part - which will be fixed in the next major (not service-pack) release of SQL...

Querying & Reporting: Reporting with Visual Basic 6.0

Apr 30, 1999

Data Report Designer delivers power, not glitz

WTS Alert

Apr 30, 1999

SQL Server 7.0's SP1 will reportedly support Windows Terminal Server (WTS). In the meantime, IBM's DB2 Universal Database (UDB) client will work with Microsoft WTS. However, all users must share the same DB2 instance (configuration, database...

Using Data Environment Events

Apr 30, 1999

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...

Unleash the Power of DTS

Apr 30, 1999

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...

Using Data Connections with SQL Server and Visual InterDev 6.0

Apr 30, 1999

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...

T-SQL for Starters: Working with Character Data

Apr 30, 1999

How to handle character data in queries

Obtaining Record Counts

Apr 30, 1999

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...