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.

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.
SQL Server 2016 Virtualization Best Practices
The HPE Superdome X provides the extreme scalability and reliability that you need in your mission critical virtualization hosts. With 288 cores and up to 24 TB of RAM, the HPE Superdome X is capable of running many demanding and high performance workloads simultaneously. While the virtualization hardware platform is definitely the foundation for successfully virtualizing SQL Server enterprise databases, there are also a number of other configuration factors that you need to pay attention to. Here are the top SQL Server virtualization best practices.
Temporal Tables: SQL Server 2016’s Time Machine
One of the most interesting new features that Microsoft added to SQL Server 2016 is temporal tables. Temporal tables originated as a part of the ISO/ANSI SQL:2011 standard. You can think of temporal tables as SQL Server’s time machine.
Get up to Speed on SQL Server 2016 with these Free Training Tools
Accelerate your SQL Server 2016 proficiency with these free resources.
Using SQL Server 2016’s New Dynamic Data Masking
Understand when to use and when not to use Dynamic Data Masking.
The Importance of Benchmarking
Don’t make the mistake of dismissing benchmarks because they don’t reflect real-world applications. Benchmarks are critical measurement tools.

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 6, 2016

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More
May 12, 2016

The 7 C's of Data Quality

Data quality is really important. Why? Because it helps you save money while increasing profits because of accurate contact data. It’s important to understand what data quality is and why it is important....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) ×