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 by Richard Waymire
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.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups 1

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws 1

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×