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
The Essential Guide to SQL Server 2014 Series: Buffer Pool Extensions
Learn where to use SQL Server 2014's Buffer Pool Extensions
SQL Select: 8 Great New Features in SQL Server 2016
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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×