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.

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
Feb 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....More
Jan 22, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....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) ×