http://www.sqlmag.com/authors/author/author/5752019/rss/5752019en-USFri, 25 May 2012 08:25:34 GMTFri, 25 May 2012 08:25:34 GMThttp://www.sqlmag.com/article/sql-server/microsoft-sql-server-2012-denali-licensing-options-141646
By Richard Waymire
SQL Server 2012 licensing is changing, especially for the Enterprise edition. Find out what is being changed and how it can affect licensing costs.]]>Richard WaymireWed, 21 Mar 2012 11:30:00 GMThttp://www.sqlmag.com/article/sql-server/microsoft-sql-server-2012-denali-licensing-options-141646http://www.sqlmag.com/article/sqlserverdenali/sql-server-2012-features-141645
By Richard Waymire
SQL Server 2012 promises to be an exciting release. Here are some of the new features and enhancements you can expect to see.]]>Richard WaymireMon, 27 Feb 2012 08:00:00 GMThttp://www.sqlmag.com/article/sqlserverdenali/sql-server-2012-features-141645http://www.sqlmag.com/article/sqlserver2008r2paralleldatawarehouse/sql-server-pdw-140868
By Richard Waymire
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.]]>Richard WaymireFri, 24 Feb 2012 14:21:00 GMThttp://www.sqlmag.com/article/sqlserver2008r2paralleldatawarehouse/sql-server-pdw-140868http://www.sqlmag.com/article/bookreview/sql-server-common-problems-tested-solutions
By Richard Waymire
The books intent is to publish questions and answers to issues that Pike has seen (and figured out) during his years of working on the product. ]]>Richard WaymireWed, 06 Oct 2010 15:58:03 GMThttp://www.sqlmag.com/article/bookreview/sql-server-common-problems-tested-solutionshttp://www.sqlmag.com/article/bookreview/inside-microsoft-sql-server-2000
By Richard Waymire
This book covers installation topics, database and file information, and the basic objects within SQL Server. ]]>Richard WaymireWed, 06 Oct 2010 15:58:03 GMThttp://www.sqlmag.com/article/bookreview/inside-microsoft-sql-server-2000http://www.sqlmag.com/article/project-plan-backup-sql-server-2008-r2-83/sql-server/database-mirroring-in-sql-server-2008-and-sql-server-2008-r2
By Richard Waymire
Database mirroring can be a great way to improve database availability because it’s fairly easy to deploy, administer, and maintain.]]>Richard WaymireMon, 20 Sep 2010 00:07:00 GMThttp://www.sqlmag.com/article/project-plan-backup-sql-server-2008-r2-83/sql-server/database-mirroring-in-sql-server-2008-and-sql-server-2008-r2http://www.sqlmag.com/article/com-and-com/determining-the-maximum-number-of-connections-to-sql-server-2000
By Richard Waymire
Microsoft’s SQL Server development team explains how to accommodate the most SQL Server connections on one node.]]>Richard WaymireWed, 19 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/com-and-com/determining-the-maximum-number-of-connections-to-sql-server-2000http://www.sqlmag.com/article/ftp/using-dynamic-snapshot-for-merge-replication
By Richard Waymire
Microsoft’s SQL Server development team explains why dynamic snapshot processes articles for replication multiple times.]]>Richard WaymireWed, 19 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/ftp/using-dynamic-snapshot-for-merge-replicationhttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-value
By Richard Waymire
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.]]>Richard WaymireWed, 19 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/data-modeling/using-a-check-constraint-to-enforce-a-trigger-s-unique-valuehttp://www.sqlmag.com/article/internet/accessing-extended-properties-in-a-web-based-application
By Richard Waymire
Microsoft’s SQL Server development team provides code that retrieves extended properties in a Web-based SQL Server administration application.]]>Richard WaymireWed, 19 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/internet/accessing-extended-properties-in-a-web-based-applicationhttp://www.sqlmag.com/article/log-files/accounting-for-transaction-log-growth
By Richard Waymire
Microsoft’s SQL Server development team explains why a transaction log expands and offers remedies for the problem.]]>Richard WaymireWed, 19 Dec 2001 00:00:00 GMThttp://www.sqlmag.com/article/log-files/accounting-for-transaction-log-growthhttp://www.sqlmag.com/article/query-analyser/retrieving-many-records-in-query-analyzer
By Richard Waymire
Richard Waymire helps a reader fetch 5 million records.]]>Richard WaymireTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/query-analyser/retrieving-many-records-in-query-analyzerhttp://www.sqlmag.com/article/passwords/transferring-passwords-between-different-sql-server-releases
By Richard Waymire
Richard Waymire answers a reader’s question about transferring passwords during a backup and restore.]]>Richard WaymireTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/passwords/transferring-passwords-between-different-sql-server-releaseshttp://www.sqlmag.com/article/log-files/shrinking-a-bloated-database-and-log-file
By Richard Waymire
Richard Waymire tells a reader how to shrink a ballooning database and log file.]]>Richard WaymireTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/log-files/shrinking-a-bloated-database-and-log-filehttp://www.sqlmag.com/article/query-analyser/updating-sql-server-s-internal-server-name
By Richard Waymire
Richard Waymire tells a reader how to avoid passing old server and database names to a new server.]]>Richard WaymireTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/query-analyser/updating-sql-server-s-internal-server-namehttp://www.sqlmag.com/article/quering/inserting-an-image-into-a-column
By Richard Waymire
Richard Waymire provides a VB code example for a reader’s question about inserting an image into a column.]]>Richard WaymireTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/quering/inserting-an-image-into-a-columnhttp://www.sqlmag.com/article/enterprise-manager/avoiding-the-autoclose-and-autoshrink-options
By Richard Waymire
Richard Waymire explains why you should avoid Autoclose and Autoshrink when you choose your database options. ]]>Richard WaymireTue, 20 Nov 2001 00:00:00 GMThttp://www.sqlmag.com/article/enterprise-manager/avoiding-the-autoclose-and-autoshrink-optionshttp://www.sqlmag.com/article/passwords/resetting-the-sql-server-service-account-password
By Richard Waymire
Richard Waymire answers a reader’s question about resetting the password for the SQL Server and SQL Server Agent services.]]>Richard WaymireWed, 24 Oct 2001 00:00:00 GMThttp://www.sqlmag.com/article/passwords/resetting-the-sql-server-service-account-passwordhttp://www.sqlmag.com/article/visual-basic-vb/testing-a-sql-server-vb-connection
By Richard Waymire
Richard Waymire helps a reader use SQL-DMO to test a connection between VB and SQL Server.]]>Richard WaymireWed, 24 Oct 2001 00:00:00 GMThttp://www.sqlmag.com/article/visual-basic-vb/testing-a-sql-server-vb-connectionhttp://www.sqlmag.com/article/sql-server-2000/capturing-the-ddl-from-sql-server-2000-tables
By Richard Waymire
Richard Waymire helps a reader retrieve existing DDL information for rows in a new SQL Server 2000 table.]]>Richard WaymireWed, 24 Oct 2001 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2000/capturing-the-ddl-from-sql-server-2000-tables