Michael Otey


Michael Otey, Senior Contributing Editor for Windows IT Pro and SQL Server Pro, is president of TECA, a software-development and consulting company in Portland, Oregon. Michael has covered the topic of virtualization extensively for Windows IT Pro, having written several features articles showing how to take advantage of virtualization in the enterprise as well as reviewing all of the major virtualization products. Follow Michael on Google+ and Twitter.

Q & A: How Can I Test Client Connectivity to SQL Server?
Troubleshoot your client connections to SQL Server
Q & A: Finding Your SQL Server Evaluation Time Limit
See how many days are left in your SQL Server evaluation period
Writing Perfmon data to SQL Server

Q: I’m trying to get Perfmon to write performance counter data to SQL Server. In Perfmon I’ve created a Data Collector and I set the Log format to SQL. I have also created a data source using the SQL Server Native driver but when I try to start Perfmon I get the error Call to SQLAllocConnect failed with %1.

A: I’ve found that you cannot use the SQL Server Native Client to log data to SQL Server from Perfmon. I have only had success when the data source that I created used the ODBC driver like you can see in Figure 1.

SQL Select: FAQs about SQL Server 2014 2
Answers to your most frequently asked questions about SQL Server 2014
Dealing with an Inherited SQL Server
Get a quick must-do checklist for dealing with an inherited SQL Server system
FAQ: Missing SSMS IntelliSense Changes
See what to do when IntelliSense doesn't recognize your new database objects
Moving SQL Server to a Virtual Platform
Learn about some of the main factors that impact SQL Server performance in a VM
Where do I find SQL Server Management Studio?
Find the executable for SSMS
Scaling SQL Server With No Hardware
Learn about SQL Server's core database performance factors
The Essential Guide the SQL Server 2014: Backup Enhancements
Learn about the backup enhancements in SQL Server 2014
Hit Your SQL Server Performance Goals
Benchmarking enables you to stay on top of your SQL Server performance goals
Q & A: Restore Missing SQL Server Performance Counters
See how to restore missing SQL Server performance counters
The Essential Guide to SQL Server 2014: The Resource Governor
Learn about the new IO limiting capabilities of SQL Server 2014's Resource Governor
Q & A: How can I recover my sa Password? 2
See how you can reset a lost sa password

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
Nov 3, 2015

Climb the Steps Toward Data Quality Success

Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....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) ×