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
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
Q & A: How Many Processors Can SQL Server 2014 Express Really Use? 5
Can SQL Server 2014 Express take advantage of multicore systems?

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
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
Apr 21, 2016
blog

Turning Global Addresses into your Biggest Asset

Sponsored Blog Are you dealing with national and international records? The more expansive your records are in territory, the more problems you will face when it comes to verifying addresses. Not only are you dealing with language differences, but you are also dealing with different address formatting for different countries....More
Mar 14, 2016
blog

Building Your Business with Quality Data

Your contact data is valuable, but is it up to its full potential? Without the proper maintenance, the quality of your data quickly decreases--so quickly that 50% of databases deteriorate after only two years. It is an absolute necessity to maintain your data in order to decrease costs and increase profits....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) ×