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
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
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
The Essential Guide to SQL Server 2014 Series: Buffer Pool Extensions 1
Learn where to use SQL Server 2014's Buffer Pool Extensions
SQL Select: 8 Great New Features in SQL Server 2016 1
Learn about the top eight new features coming in SQL Server 2016

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
Sep 1, 2015
blog

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015
blog

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Aug 19, 2015
blog

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....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) ×