Michael Otey

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.

Articles
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
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

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
Feb 5, 2016
blog

The Solution to Large Quantities of Data

High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More
SQL Server 2016 Reporting Services
Jan 25, 2016
Article

Top Takeaways from Microsoft's Reporting Roadmap

The future for on-premises Microsoft business intelligence looks a whole lot brighter these days. Here are the top five takeaways from Microsoft's recent business intelligence announcements....More
Microsoft Power BI
Dec 8, 2015
Article

It is Time to Migrate Power BI for Office 365 1

Don't forget to migrate Power BI for Office 365 content before you leave for the holidays. Deprecation of Power BI for Office 365 starts at the end of December 2015. Here is what you need to know to successfully move your business intelligence content to the latest and greatest version of Microsoft Power BI....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) ×