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
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.
Solving Performance Problems with the Query Store
Many times, something changes on the server or something in the database is changed or sometimes the application code itself gets changed and performance begins to degrade. Troubleshooting typically happens well after the fact and often only when the application’s performance becomes a problem.
HPE Superdome X FAQs
The HPE Superdome offers several unique features, and here are some FAQs to help you get the most out of them.
SQL Server 2016 Hybrid Cloud Integration
SQL Server 2016 has deeper cloud integration than any previous release of SQL Server. Here is a closer look at some of SQL Server 2016’s hybrid cloud options.
Increasing your Storage Efficiency with SQL Server Stretch Databases
One of the most important new features in the SQL Server 2016 release is the support for Stretch Databases. If you haven’t had a chance to keep up with the latest enhancements in SQL Server 2016, the term Stretch Databases refers to a feature that enables you to seamlessly extend a database from your on-premise SQL Server instance to Azure.
Top Four Enterprise Infrastructure Mistakes
Every business runs different workloads and has different resource requirements. For many businesses, building out the optimal set of enterprise IT infrastructure components can be a trial-and-error process where things don’t always work out the first time.
SQL Server 2016 In-Memory OLTP Enhancements
The In-Memory OTLP feature that Microsoft first introduced to SQL Server 2014 was the most significant enhancement that Microsoft made to the relational database side in several releases
Choosing a SQL Server Availability Technology
Here’s a quick overview of SQL Server 2016’s high availability and disaster recovery technologies.
Superdome X Builds in Enterprise Level Availability
Today’s enterprise-level virtualization and database servers need to support massive level of scalability to run todays resource intensive OTLP, data warehousing and big data applications. However, while scalability is undoubtedly important, it’s not as important as reliability and availability.
The SQL Server 2016 Essential Guide: The Modern Data Platform
Learn about the new features in SQL Server 2016
Increasing Enterprise Workload Availability and Flexibility with HPE Superdome X nPars
The HPE Superdome X’s unique nPAR capability enables you to provide the required levels of availability as well as the flexibility to handle diverse workloads without the costs incurred by having to buy many smaller commodity servers.
Integrating Big Data and SQL Server 2016
Big Data is quickly becoming an important asset for many businesses as new technologies like IoT (Internet-Of-Things) are being adopted that drive the collection and analysis of vast amounts of data. Michael Otey explains how SQL Server 2016’s PolyBase can help.
Securing Your Critical Business Data with Always Encrypted
There’s an increasing awareness about how critical data protection is to an enterprise. With security being a key concern for businesses, it's important to know how to best safeguard your business.
Q & A: Where do I find SQL Server Management Studio for SQL Server 2016?
Learn about the installation changes for the SQL Server 2016 Management Tools
Q & A: How Can I tell if Full-Text Search is Installed?
Find out how to see if Full-Text Search is installed on your SQL Server instance

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
Sponsored

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
Sponsored

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
blog

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) ×