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.

Increasing Enterprise Workload Availability and Flexibility with HPE Superdome X nPars
The HPE Superdome X’s unique nPAR capability enables you to provide the required levels of availability as well as the flexibility to handle diverse workloads without the costs incurred by having to buy many smaller commodity servers.
Integrating Big Data and SQL Server 2016
Big Data is quickly becoming an important asset for many businesses as new technologies like IoT (Internet-Of-Things) are being adopted that drive the collection and analysis of vast amounts of data. Michael Otey explains how SQL Server 2016’s PolyBase can help.
Securing Your Critical Business Data with Always Encrypted
There’s an increasing awareness about how critical data protection is to an enterprise. With security being a key concern for businesses, it's important to know how to best safeguard your business.
Q & A: Where do I find SQL Server Management Studio for SQL Server 2016?
Learn about the installation changes for the SQL Server 2016 Management Tools
Q & A: How Can I tell if Full-Text Search is Installed?
Find out how to see if Full-Text Search is installed on your SQL Server instance
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.

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
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
Apr 21, 2016

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....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) ×