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
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.
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

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