By Richard Waymire, 03/21/2012
SQL Server 2012 licensing is changing, especially for the Enterprise edition. Find out what is being changed and how it can affect licensing costs.
By Richard Waymire, 02/27/2012
SQL Server 2012 promises to be an exciting release. Here are some of the new features and enhancements you can expect to see.
By Richard Waymire, 02/24/2012
Users can't simply log on to a SQL Server 2008 R2 Parallel Data Warehouse appliance to access its data. Client connectivity tools and the tools to query PDW need to be installed ...
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.