By Richard Waymire, 10/06/2010
The books intent is to publish questions and answers to issues that Pike has seen (and figured out) during his years of working on the product.
By Richard Waymire, 10/06/2010
This book covers installation topics, database and file information, and the basic objects within SQL Server.
By Richard Waymire, 09/20/2010
Database mirroring can be a great way to improve database availability because it’s fairly easy to deploy, administer, and maintain.
By Richard Waymire, 12/19/2001
Microsoft’s SQL Server development team explains how to accommodate the most SQL Server connections on one node.
By Richard Waymire, 12/19/2001
Microsoft’s SQL Server development team explains why dynamic snapshot processes articles for replication multiple times.
By Richard Waymire, 12/19/2001
Microsoft’s SQL Server development team tells a reader how to enforce a trigger’s unique value by using a custom CHECK constraint or, in SQL Server 2000, INSTEAD OF triggers.
By Richard Waymire, 12/19/2001
Microsoft’s SQL Server development team provides code that retrieves extended properties in a Web-based SQL Server administration application.
By Richard Waymire, 12/19/2001
Microsoft’s SQL Server development team explains why a transaction log expands and offers remedies for the problem.
By Richard Waymire, 11/20/2001
Richard Waymire helps a reader fetch 5 million records.
By Richard Waymire, 11/20/2001
Richard Waymire answers a reader’s question about transferring passwords during a backup and restore.
By Richard Waymire, 11/20/2001
Richard Waymire tells a reader how to shrink a ballooning database and log file.
By Richard Waymire, 11/20/2001
Richard Waymire tells a reader how to avoid passing old server and database names to a new server.
By Richard Waymire, 11/20/2001
Richard Waymire provides a VB code example for a reader’s question about inserting an image into a column.
By Richard Waymire, 11/20/2001
Richard Waymire explains why you should avoid Autoclose and Autoshrink when you choose your database options.
By Richard Waymire, 10/24/2001
Richard Waymire answers a reader’s question about resetting the password for the SQL Server and SQL Server Agent services.
By Richard Waymire, 10/24/2001
Richard Waymire helps a reader use SQL-DMO to test a connection between VB and SQL Server.
By Richard Waymire, 10/24/2001
Richard Waymire helps a reader retrieve existing DDL information for rows in a new SQL Server 2000 table.
By Richard Waymire, 10/24/2001
Richard Waymire answers a reader’s question about dependency tracking.
By Richard Waymire, 10/24/2001
Richard Waymire tells a reader how to replace the Named Pipes Net-Library.
By Richard Waymire, 10/24/2001
Richard Waymire answers a reader’s question about estimating the time a query will run.