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
What’s New in SQL Server 2016 Analysis Services
When Microsoft first included OLAP Services (the precursor of today’s SQL Server Analysis Services) in SQL Server 7, the company totally changed the enterprise database landscape. The introduction of OLAP Services marked the first time that OLAP (online analytical processing)/business intelligence analysis capabilities were bundled with an enterprise relational database, and it was one of the driving forces that transformed BI from a niche IT role to mainstream database technology.
What’s New in SQL Server 2016 Integration Services
With all of the other new features in SQL Server 2016, it’s easy to overlook the enhancements that Microsoft has made to SQL Server Integration Services (SSIS). First introduced with SQL Server 2005, SSIS replaced the earlier Data Transformation Services (DTS) and is SQL Server’s primary Extraction Transfer Load (ETL) tool.
An Overview of the HPE Superdome X Architecture
Designed for maximum enterprise-level performance and availability, the HPE Superdome X uses a unique architecture that enables extreme scalability, core system reliability and workload partitioning. All of this makes it an excellent platform for virtualization and mission-critical database implementations.
W.B. Mason Solves Its Scalability ‘Problems’ with the HPE Superdome X
In the good-problem-to-have category, W.B Mason was experiencing 10% to 12% growth each year, and its existing blade infrastructure was struggling to keep up. The company was purchasing new servers nearly every year, and each new server required a labor-intensive migration process. Even with these on-going upgrades, W.B. Mason’s servers were consistently running at a 95% CPU utilization rate.
SQL Select: Top Ten Great (and Free) SQL Server eBooks
Check out these great (and totally free) SQL Server eBooks
Scalable No-Guesswork Deployments with the HPE Superdome X and SQL Server 2016 Reference Architecture
There are several ways you can go about adding new servers into your organization’s IT infrastructure. You can do the research yourself and attempt to put together your own custom configurations, or you can use a reference architecture.
SQL Server 2016’s JSON Integration
While the big theme for the release of SQL Server 2016 is embracing the cloud and cloud services, one of the most easily overlooked new features in SQL Server 2016 is its integrated support for JSON (JavaScript Object Notation).
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.

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

Sponsored Introduction Continue on to (or wait seconds) ×