Additional Articles

SQL Server CE: New Version Lets You Store and Upda

by Additional Articles

Microsoft MSDN

Miscellaneous

Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.

2001-07-05

802 reads

PASS 2001 North America - Register and Save $500

by Additional Articles

PASS

Unique access to more than 110 sessions and 80 presenters, including SQL Server users and Microsoft developers. Educational tracks include: data warehousing and business intelligence; developing web-enabled and line of business solutions; enterprise database administration and deployment; and, professional development. Register today and get a great return on your SQL Server investment!

2001-07-04

3,665 reads

Clonation and the Case of Table Dolly, Part 2

by Additional Articles

Microsoft MSDN

.Net

In the last installment of this column, at the end of a long and erudite discussion on clonation, I introduced the sad but instructive story of Dolly. As a real scientist, I was conducting experiments on disconnected data features applied to intermittent applications.

2001-07-03

950 reads

SQL Server 7.0 Log Shipping Frequently Asked Questions

by Additional Articles

Microsoft MSDN

Administration

This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.

2001-07-02

1,764 reads

Microsoft Certification Exams Included in VA Education

by Additional Articles

Microsoft MSDN

Microsoft Corp. today announced that veterans taking tests in the Microsoft® Certified Professional (MCP) program can now use their Department of Veterans Affairs (VA) education benefits to cover examination fees (May 23, 2001).

2001-06-29

4,208 reads

Using Stored Procedures from ADO 2.1

by Additional Articles

Microsoft MSDN

Stored Procedures

If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever.

2001-06-29

1,967 reads

Multiple paths in DTS Workflow

by Additional Articles

SQLDTS.com

This article shows you how to create multiple converging paths in workflow, and covers the use of a simulated OR constraint, not available directly from within the designer.

2001-06-28

990 reads

Optimizing SQL Server Performance Using Files and Filegroups

by Additional Articles

SQL Server Performance

Performance Tuning

Learn how to boost the performance of SQL Server by making proper use of filegroups.

2001-06-26

1,774 reads

SQL Server 2000: New XML Features Streamline Webcast

by Additional Articles

Microsoft MSDN

With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries.

2001-06-26

4,110 reads

Automate Writing Stored Procedures

by Additional Articles

DevX

Stored Procedures

This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!

2001-06-25

2,561 reads

All authors

Additional Articles

SQL Server CE: New Version Lets You Store and Upda

PASS 2001 North America - Register and Save $500

Clonation and the Case of Table Dolly, Part 2

SQL Server 7.0 Log Shipping Frequently Asked Questions

Microsoft Certification Exams Included in VA Education

Using Stored Procedures from ADO 2.1

Multiple paths in DTS Workflow

Optimizing SQL Server Performance Using Files and Filegroups

SQL Server 2000: New XML Features Streamline Webcast

Automate Writing Stored Procedures

Blogs

A New Word: on tenderhooks

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Forums

how do i map the "current" object entry in for each to one variable

Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Question of the Day

String Similarity I