The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
This issue shows you how to use SQL Server CE and merge replication to put your SQL Server database in the palm of your hand. We also cover SQL Server 2000's new sql_variant data type and user-defined extended properties and Query Analyzer templates.
By Brian Moran
T-SQL syntax doesn’t support an ORDER BY clause in a view or a derived table unless you also include the TOP keyword as part of the SELECT statement.
By Russ Whitney
Here is the solution to the June MDX puzzle.
By Rich Rollman
Rich Rollman examines XML Bulk Load and OpenXML as data-import tools and discusses XML Schemas, soon to be a very hot topic.
By Itzik Ben-Gan
Using an auxiliary table can give you an efficient solution to aggregating bitwise OR calculations.
By Burton Roberts
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 Morris Lewis
Handy reference resources for setting up SQL Server CE and merge replication.
By Richard Waymire
Richard Waymire answers readers’ questions about installing the MSDTC Resource, calling a DoEvents in VBScript, securing tables, and more.
This copy-and-paste method is a convenient way to script multiple objects from Enterprise Manager, using as few keystrokes as possible.
By
Readers share their tips for using the Textcopy utility to copy a text or image value, working with change-audit columns, and more.
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.
The serverproperty(propertyname) function in SQL Server 2000 is a great resource for finding out which service pack and which edition of SQL Server you’re running.
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 Michael Otey
Is Visual Basic .NET simply a much-needed evolutionary step for VB or a completely new language?
By William Vaughn
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 Steve Jones
Query Analyzer 2000’s templates feature lets you say good-bye to repetitive tasks and hello to speedy object development.
By Kalen Delaney
Tune your indexes and queries for better performance.
Analytic applications let you monitor key metrics, then analyze those measurements to find out whether your business is moving toward its business objectives.
SQL Server comes in no fewer than seven editions; here's a quick guide.
Here is the July MDX puzzle.
By Michelle A. Poolet
Use this metamodel to design your own contact manager database.
By Chad Phelps
Laserweb’s SQL Server development tool lightens your load with a powerful find-and-replace feature, an online T-SQL syntax reference, and more.
advertisement