Richard Waymire


Richard Waymire is a consultant and trainer, as well as a mentor with SolidQ. Richard is also a contributing editor to SQL Server Pro.

Microsoft SQL Server 2012 Licensing Options
SQL Server 2012 licensing is changing, especially for the Enterprise edition. Find out what is being changed and how it can affect licensing costs.
Welcome to SQL Server 2012
SQL Server 2012 promises to be an exciting release. Here are some of the new features and enhancements you can expect to see.
screenshot of SQL Server Data Source Connection
Connecting and Configuring SQL Server Parallel Data Warehouse (PDW) Clients
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 on the users' computers. Here's how.
illustration of people, mirroring concept, and databases
Database Mirroring in SQL Server 2008 R2 and SQL Server 2008 1
Database mirroring can be a great way to improve database availability because it’s fairly easy to deploy, administer, and maintain.
Accounting for Transaction Log Growth 1
Microsoft’s SQL Server development team explains why a transaction log expands and offers remedies for the problem.
Using a CHECK Constraint to Enforce a Trigger’s Unique Value 3
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.
Determining the Maximum Number of Connections to SQL Server 2000 1
Microsoft’s SQL Server development team explains how to accommodate the most SQL Server connections on one node.
Accessing Extended Properties in a Web-Based Application
Microsoft’s SQL Server development team provides code that retrieves extended properties in a Web-based SQL Server administration application.
Using Dynamic Snapshot for Merge Replication 1
Microsoft’s SQL Server development team explains why dynamic snapshot processes articles for replication multiple times.
Shrinking a Bloated Database and Log File
Richard Waymire tells a reader how to shrink a ballooning database and log file.
Inserting an Image into a Column 1
Richard Waymire provides a VB code example for a reader’s question about inserting an image into a column.
Transferring Passwords Between Different SQL Server Releases
Richard Waymire answers a reader’s question about transferring passwords during a backup and restore.
Updating SQL Server’s Internal Server Name
Richard Waymire tells a reader how to avoid passing old server and database names to a new server.
Retrieving Many Records in Query Analyzer
Richard Waymire helps a reader fetch 5 million records.
Avoiding the Autoclose and Autoshrink Options
Richard Waymire explains why you should avoid Autoclose and Autoshrink when you choose your database options.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Nov 3, 2015

Climb the Steps Toward Data Quality Success

Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×