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.

Scalable No-Guesswork Deployments with the HPE Superdome X and SQL Server 2016 Reference Architecture
There are several ways you can go about adding new servers into your organization’s IT infrastructure. You can do the research yourself and attempt to put together your own custom configurations, or you can use a reference architecture.
SQL Server 2016’s JSON Integration
While the big theme for the release of SQL Server 2016 is embracing the cloud and cloud services, one of the most easily overlooked new features in SQL Server 2016 is its integrated support for JSON (JavaScript Object Notation).
Curbing Server Sprawl with HPE Superdome X Scale-up
Server sprawl and virtual server sprawl are two of the main problems enterprises face today. Virtualization makes it easy--sometimes too easy--to deploy new servers. Plus, with Hyper-V built in to both Windows Server and Windows 10, it’s a simple task for end users and shadow IT to create more virtualization hosts than you may think you have.
New Features in SQL Server 2016 Reporting Services
First introduced in SQL Server 2005, Reporting Services has become one of the most important SQL Server subsystems.
Mag Instrument Upgrades Its ERP System with the HPE Superdome X and Microsoft SQL Server
There’s nothing like real-world examples to illustrate a platform’s true capability to support enterprise-level production workloads. Flashlight maker Mag Instrument, for example, used HPE’s Superdome X and Microsoft SQL Server to modernize its aging infrastructure, demonstrating the scalability and availability that the combo can provide.
Leveraging Windows Server 2016 with SQL Server 2016
Windows Server 2016 is expected to be officially released at the September Ignite 2016 conference in Atlanta with appearance on the price list on October 1st. SQL Server has always had tight integration with Windows Server, and that is definitely the case with Windows Server 2016 and SQL Server 2016.
Understanding SQL Server 2016 Backup Options
Maximum availability is the goal for almost all enterprise database implementations. To achieve that availability, you need to implement a layered approach to your infrastructure. First, you need to build your infrastructure out on an enterprise-level server platform.
Leveraging HPE Support Services for Efficient Database Migration
When you’re getting ready to migrate to a new database platform like SQL Server 2016, you have essentially two different ways to get there: You can perform an in-place upgrade or a side-by-side upgrade. The two upgrade paths have very different characteristics.
HPE Superdome X and SQL Server In-Memory OLTP Powers Online Financial Services
It’s one thing to quote performance numbers and availability measures, and quite another to see how these statistics translate into real-world implementations.
Enterprise Database Monitoring Tools for SQL Server and the HPE Superdome X Platform
Ongoing database monitoring and management is one of the most important jobs that the enterprise database professional has. Ongoing monitoring is essential to keeping your SQL Server system—and the systems working with it--operating efficiently. Regular monitoring can help you to avoid problems and possible downtime.
SQL Server 2016 R Integration
One of the biggest changes in SQL Server 2016 on the analytics front is the inclusion of R into the database engine.
Scaling SQL Server BI and the HPE Superdome X
SQL Server was the first enterprise database to include BI capabilities back in the SQL server 7.0 release when OLAP Services and Data Transformation Services were first introduced. Since that time, the BI subsystems in SQL Server have continued to evolve and mature, bringing what was once a niche technology into the mainstream.
Top 5 SQL Server Virtualization Mistakes to Avoid
It wasn’t all that long ago that SQL Server was considered too resource-intensive to successfully virtualize. A new generation of hardware and scalability advances in the Hyper-V and vSphere platforms has changed all of that. Now, it’s common to virtualize SQL Server instances. However, it easy to make mistakes that can result in poorly performing SQL Server VMs. Here are the top five mistakes to avoid when virtualizing SQL Server.
SQL Server 2016 and HPE Superdome X Security
With the continued growth of the cloud and the ubiquity of end user devices, security has become one of the foremost concerns for database and IT professionals. With the release of SQL Server 2016, Microsoft has made security an even higher priority.
Maximizing Uptime with SQL Server 2016 Enterprise Edition Availability Features
Most people are aware of the primary SQL Server availability features, but there are some lower-profile features you need to know about to ensure you are doing everything you can to optimize availability.

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 17, 2017

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×