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
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....More
iceberg
Oct 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 8: Dynamic Detection Gotcha #1 1

Learn about why the option of dynamically detecting whether or not to run a SQL Server Job at execution time is quite a bit more problematic than you might think....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) ×