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 Many Processors Can SQL Server 2014 Express Really Use? 5
Can SQL Server 2014 Express take advantage of multicore systems?
Q & A: Oracle JRE 7 Error on SQL Server 2016 Installation
See how to fix the Oracle JRE 7 error while installing SQL Server 2016
SQL Select: Eight Great (and Free) SQL Server eBooks
Check out these eight great free SQL Server eBooks
The Essential Guide to SQL Server 2014: Hybrid Cloud Features
Learn about the hybrid cloud features in SQL Server 2014
Q & A: How Can I Use the Shared Memory Protocol In My Client Connection?
See how to make your client connection use the Shared Memory protocol
Top Five New Features in SQL Server 2016 CTP 3
Learn about the top five new features in SQL Server 2016 CTP 3
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

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
Jul 6, 2016

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More
May 12, 2016

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....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) ×