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

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
Sep 15, 2016
Sponsored

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
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

Sponsored Introduction Continue on to (or wait seconds) ×