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
The HPE Superdome X Gen9 Provides Significant Performance Boost over Predecessor
HPE designed the Superdome X line as an enterprise-class server platform from the get-go, and the company has continued to evolve the system ever since. For example, the new Gen 9-based Superdome X provides significant performance increases over the Gen 8 version.
T-SQL Enhancements in SQL Server 2016
The relational database engine and T-SQL are the core of SQL Server 2016. T-SQL is used for both SQL Server management as well as stored procedures, triggers, functions and application development. As you might expect with a new release, Microsoft has made many significant enhancements to T-SQL with SQL Server 2016.
The HPE Superdome X in Today’s Modern Data Center
The data center today is vastly different from the data center of a few years ago. Back then, there tended to be one server per workload, and IT needed to manage a multitude of servers. This model was eventually replaced by virtualization, and many more server systems were consolidated. In today’s data center, workloads are shifted based on response to workloads, and the degree of server consolidation is higher than ever.
New Features in SQL Server 2016 PowerShell
PowerShell has become an important management option for SQL Server professionals. While the initial implementation didn’t support all of the different SQL Server management features, Microsoft has been rapidly evolving SQL Server’s PowerShell support. Now, almost all SQL Server management functions are supported by PowerShell.
Understanding the HPE Superdome X Data Center Footprint
Upgrading your IT infrastructure is always a big deal. When you’re planning to implement a new server in your data center, you need to be aware of the system’s physical size and implementation characteristics, as well as the system’s overall capacities. This is especially true if, like most businesses, you don’t initially buy the system in its maximum configuration.
New Features in SQL Server Master Data Services
MDS plays a very important role for businesses that need to create single master data view of their data, when that data comes from multiple data sources and is described differently in each of those sources.
Managing the HPE Superdome X with the Onboard Administrator
The HPE Superdome X is managed using the Superdome Onboard Administrator (OA). The OA is HPE’s blade enclosure management module. It provides the ability to manage system power, partition the system, and monitor component inventory and health.
Hardware Is as Important as Software when Implementing an Enterprise Database Server Platform
When deploying an enterprise database such as Microsoft SQL Server, one of the most critical tasks is deciding what hardware to deploy the system on. This is true even if you plan to deploy the database in a virtual machine (VM).
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).

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