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: 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
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 6
Follow this step-by-step guide for performing an in-place upgrade to SQL Server 2014.
SQL Server Hybrid Cloud Options 1
Microsoft has recognized that most businesses are going to be sticking with their on-premises infrastructure for some time, and it has quite pragmatically come out with several hybrid cloud options that can be a real value to SQL Server customers.
Q & A
SQL Server Data Tools for SQL Server 2014 6
Learn how to get SQL Server Data Tools for SQL Server 2014.
Using the SQL Server Dedicated Administrator Connection
Learn how to use the SQL Server's Dedicated Administrator Connection (DAC).
compititors with raised fists into clouds
Microsoft’s Hybrid Cloud is Positioned to Win the Cloud Wars
Microsoft may not be the market leader in the cloud, but its new hybrid approach puts it in the best positioned best to provide useful and effective cloud services to businesses today.

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 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries 1

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 16, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups 1

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....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) ×