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: 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.
Migrating to SQL Server 2014 10
Follow this step-by-step guide for performing an in-place upgrade to 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
Apr 21, 2016
blog

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
blog

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

Your Data’s Rate of Decay

Did you know that data has a half-life? That is the amount of time it takes for the information in your database to go bad. How? Because contact data is always changing....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) ×