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.

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
The Essential Guide to SQL Server 2014 Series: AlwaysOn Availability Group Enhancements
Get up to speed on the new features in SQL Server 2014 Availability Groups
SQL Select: Basic SQL Server Setup Checklist
Here are some basic settings that are best practices for almost all new SQL Server instances
Tip: Finding Unused Indexes
Find your unused indexes
The Essential Guide to SQL Server 2014 Series: In-Memory OLTP 1
What you need to know about In-Memory OLTP
Can I Revert Back from In-Memory OLTP Tables to Standard Disk-based Tables?

Yes you can revert a memory optimized table back to a standard disk-based table. While the preponderance of material you’ll find on the Internet will tell you how to migrate to In-Memory OLTP memory optimized tables there’s very little advice on how to move back if the new memory optimized tables didn’t work out. In-Memory OLTP is a great technology but there could be a number of reasons for moving back. In-Memory OLTP is best when you have a situation where the application is waiting for locks and latches.

The Essential Guide to SQL Server 2014 Series: Scalability
Learn about SQL Server 2014's scalability capabilties
How can I move SQL Server Agent Jobs to different systems? 2
See how to move SQL Agents jobs between SQL Server instances
SQL Select: Steps to Migrate from SQL Server 2000 to SQL Server 2014 3
See how to migrate from SQL Server 2000 to SQL Server 2014
t-shirts on a string clothesline
SQL Server Connection Strings
Learn about the different SQL Server connection strings.
2014 IT/Dev Connections: The Week in Review
The 2014 IT/Dev Connections Conference tracks provided deep hands-on technical information. And the SQL Server panel was chock-full of SQL luminaries providing answers to all sorts of attendee questions.
Espresso Logic Releases Expresso BaaS at IT/Dev Connections
Learn about the latest release of Espresso Logic’s Backend-as-Service (BaaS) offering, Espresso. Espresso's reactive program model provides fast backend database application development.

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) ×