Richard Waymire

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.

Articles
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.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Fork in walking path
Aug 28, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 2: Putting AlwaysOn into Context

Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
start here sign
Aug 26, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 1: Introduction

While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
Man deciding which door to choose
Aug 15, 2014
Sponsored

Choosing the Right Health Check

For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....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) ×