SQL Server Magazine July 2001
[Focus]
Put your database in the palm of your hand. After you learn how to configure distributed computing with SQL Server CE and merge replication, your laptop might be taking a fewer trips out of the office.
By Morris Lewis
[Features]
Use SQL Server 2000's sql_variant data type to add user-defined extended properties to your data, tables, columns, parameters, and other objects.
By William Vaughn
Query Analyzer 2000’s templates feature lets you say good-bye to repetitive tasks and hello to speedy object development.
By Steve Jones
This copycat UDF, created in the image of VB's Split() function, helped the author parse thousands of query lines and emulate variable-length parameter arrays
By Burton Roberts
[Lab Reports]
Laserweb’s SQL Server development tool lightens your load with a powerful find-and-replace feature, an online T-SQL syntax reference, and more.
By Chad Phelps
[SQL Server Savvy]
SQL Server MVP Brian Moran answers readers' questions about importing Microsoft Access tables into SQL Server 2000, encrypting a column, managing Windows-authenticated logins, and more.
By Brian Moran
[Editorial]
Is Visual Basic .NET simply a much-needed evolutionary step for VB or a completely new language?
By Michael Otey
[Reader to Reader]
Readers share their tips for using the Textcopy utility to copy a text or image value, working with change-audit columns, and more.
By Various Authors
[SQL Server Q&A]
Richard Waymire answers readers’ questions about installing the MSDTC Resource, calling a DoEvents in VBScript, securing tables, and more.
By Richard Waymire
[SQL Seven]
SQL Server comes in no fewer than seven editions; here's a quick guide.
By Michael Otey
[Inside SQL Server]
Tune your indexes and queries for better performance.
By Kalen Delaney
[Mastering Analysis]
Analytic applications let you monitor key metrics, then analyze those measurements to find out whether your business is moving toward its business objectives.
By Russ Whitney
[Solutions by Design]
Use this metamodel to design your own contact manager database.
By Michelle A. Poolet
[T-SQL Black Belt]
Using an auxiliary table can give you an efficient solution to aggregating bitwise OR calculations.
By Itzik Ben-Gan
[XML Q&A]
Rich Rollman examines XML Bulk Load and OpenXML as data-import tools and discusses XML Schemas, soon to be a very hot topic.
By Rich Rollman
|
