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
Curbing Server Sprawl with HPE Superdome X Scale-up
Server sprawl and virtual server sprawl are two of the main problems enterprises face today. Virtualization makes it easy--sometimes too easy--to deploy new servers. Plus, with Hyper-V built in to both Windows Server and Windows 10, it’s a simple task for end users and shadow IT to create more virtualization hosts than you may think you have.
New Features in SQL Server 2016 Reporting Services
First introduced in SQL Server 2005, Reporting Services has become one of the most important SQL Server subsystems.
Mag Instrument Upgrades Its ERP System with the HPE Superdome X and Microsoft SQL Server
There’s nothing like real-world examples to illustrate a platform’s true capability to support enterprise-level production workloads. Flashlight maker Mag Instrument, for example, used HPE’s Superdome X and Microsoft SQL Server to modernize its aging infrastructure, demonstrating the scalability and availability that the combo can provide.
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.

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