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: 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.
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.
Session 2: Creating Synchronous, Asynchronous and Read-Only Replicas 

Running Time: 56 minutes |

In this session, you'll see how you can create AlwaysOn Availability Groups that contain both synchronous and asynchronous replicas. You'll also see how you can offload reporting and backups to read-only replicas.

Session 3: Creating AlwaysOn Availability Groups in Azure 

Running Time: 50 minutes |

In the final session, you'll see how you can create SQL Server AlwaysOn Availability group replicas in Azure and use them for cloud-based disaster recovery.

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.
Configuring AlwaysOn Read-Only Replicas 1
Learn how to configure your SQL Server AlwaysOn replica to allow read-only access.
Setup SQL Server AlwaysOn Replicas in Microsoft Azure
Azure can be a cost-effective alternative to setting up your own private disaster recovery site. Learn a couple of different ways that you can use Azure as a disaster recovery location for SQL Server.
The Azure Experience
Michael Otey shares with readers his hands-on experience using the new Microsoft Azure. Learn why you might want to give the new Azure a try.
Yellow triangle road sign marked Error
Increasing the SSMS Table Designer Timeout Value
Are you getting an error changing the schema for a table using the Table Designer in SQL Server Management Studio? Learn how to fix the problem!

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 5, 2016
blog

The Solution to Large Quantities of Data

High-quality data is key to uncovering meaningful insights and new opportunities. Melissa Data has recently released a new tool, Data Profiler, to help companies that are dealing with large quantities of data and need a full spectrum of solutions that work....More
SQL Server 2016 Reporting Services
Jan 25, 2016
Article

Top Takeaways from Microsoft's Reporting Roadmap

The future for on-premises Microsoft business intelligence looks a whole lot brighter these days. Here are the top five takeaways from Microsoft's recent business intelligence announcements....More
Microsoft Power BI
Dec 8, 2015
Article

It is Time to Migrate Power BI for Office 365 1

Don't forget to migrate Power BI for Office 365 content before you leave for the holidays. Deprecation of Power BI for Office 365 starts at the end of December 2015. Here is what you need to know to successfully move your business intelligence content to the latest and greatest version of Microsoft Power BI....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) ×