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
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!
Sizing In-Memory OLTP Hash Indexes
Learn how to size the bucket_count value for SQL Server 2014's In-Memory OLTP hash indexes.
Q & A
SQL Server 2014's In-Memory Technology May Require Database Changes 4
There are a good number of SQL Server data types and features that aren't support by this initial release of In-Memory OLTP.
Brad Anderson speaking at Microsoft TechEd 2014
The New Microsoft
Expect a more rapid rate of change from Microsoft—especially for Azure-based services—as well as a better hybrid experience that incorporates more mobile devices and other technologies.
HammerDB Transaction Counter
Generating a TPC-C OLTP Workload
Learn about a free tool that you can use to generate a TPC-like workload on your SQL Server system.
space rocket launch
SQL Server 2014 Launch About What You Don’t Get
Microsoft's data platform vision is all about the future, but there are many SQL Server 2014 users that won’t get any of this cool stuff that makes up this new data platform.
network ports
SQL Server TCP and UDP Ports
Tired of trying to figure out which TCP and UDP ports SQL Server uses? This quick reference points you in the right direction.
Q & A
SQL Server 2014 Developer Edition Licensing 1
Learn whether or not the SQL Server 2014 Developer Edition is licensed per user and, if so, if it limited to a single user at a time.
Express subway train sign
SQL Server 2014 Express Editions
Learn about the new SQL Server 2014 Express editions.
SQL Server 2014 Hits General Availability—No April Fools
Microsoft releases SQL Server 2014 for General Availability.
Top 10 written in gold
Top 10 New Features in SQL Server 2014

SQL Server 2014 has plenty of significant enhancements, but there are no major changes to SSIS, SSRS, or SSRS. Here is Michael Otey's list of the top 10 new features you'll find in SQL Server 2014.

Visual Studio Online FAQs
Microsoft has recently released Visual Studio Online, a newer version of Team Foundation Service. Here are some FAQs about the cloud-based development software.

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
Jul 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....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) ×