Feb 222017
 

I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic and I are holding precons the Friday before the event. The SQL Saturday in Chicago this year has hit peak capacity two months before the event. However, if you enroll in one of the precons, and hopefully my “The Complete Primer to SQL Server Infrastructure and Cloud” session, email the SQL Saturday coordinators with your EventBrite receipt and your admittance will be guaranteed!

This event is to be held on Friday, March 10th, at the DeVry University Campus in Addison, IL. This course has been updated to include key concepts about SQL Server in the cloud, including the similarities, differences, and performance characteristics.

Session Details: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Registration is now open here, and seats are limited! Register today!

Jan 202017
 

I’m proud and humbled to announce that my company, Heraflux Technologies, is hiring for a Data Platform Solutions Architect!

We are looking for a highly qualified technologist who is comfortable with database technologies, such as Microsoft SQL Server and other DBMS platforms, and infrastructure technologies, such as virtualization, converged platforms, public cloud, and system administration.

The Solutions Architect is accountable for working with a number of organizations in a variety of industries to improve the availability, performance, and efficiency of the infrastructure stack underneath the application.

This position is more of a SQL Server focused role, and only senior-level SQL Server administrators should apply. More details are available here, and we look forward to hearing from you!

Jan 162017
 

UPDATE: The SQL Saturday in Chicago this year has hit peak capacity two months before the event! However, if you enroll in one of the precons, and hopefully my “The Complete Primer to SQL Server Infrastructure and Cloud” session, email the SQL Saturday coordinators with your EventBrite receipt and your admittance will be guaranteed!

This event is to be held on Friday, March 10th, at the DeVry University Campus in Addison, IL. This course has been updated to include key concepts about SQL Server in the cloud, including the similarities, differences, and performance characteristics.

Session Details: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Registration is now open here, and seats are limited! Register today!

Jan 042017
 

Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago. The training class is entitled “The Complete Primer to SQL Server Infrastructure and Cloud” and is to be held on Friday, March 10th, at the DeVry University Campus in Addison, IL. This course has been updated to include key concepts about SQL Server in the cloud, including the similarities, differences, and performance characteristics.

Session Details: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment, whether on-premises or in the cloud. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure, virtualization, and cloud underneath SQL Server, from storage all the way through to the SQL Server instance and database, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Registration is now open here, and seats are limited! Register today!

Dec 192016
 

I’m pleased to announce a new collaborative whitepaper with ScaleArc entitled “Improving uptime and performance of legacy apps on Microsoft SQL Server“.

Performance tuning inefficient legacy applications can be a tremendous drain on development resources in an organization. Handling availability of the database layer of these applications can be an even larger challenge. ScaleArc can help improve both challenges by improving the availability of the database layer and accelerating common repetitive database queries from the application.

The past five years or so has seen a shift in people’s expectations for application performance. As they’ve seen their personal apps deliver continuous uptime and high performance, they’ve grown more frustrated with the slower performers in business.

Despite these business apps being critical to corporate performance, users have “just dealt with it” for years whenever they’re slow and unreliable. One challenge, of course, has been that these enterprise apps are much more complex than the personal apps, making it harder to update them. Plus, making the necessary changes to “update” the application might be out of the hands of an organization when they don’t control the source code, or are costly and time prohibitive to update when they do. A compelling alternative has emerged. Rather than recoding apps for improved uptime and performance in a database environment, consider the benefits of database load balancing software. A pioneer in this technology, ScaleArc has set out to make business application platforms more highly available and perform better by managing the traffic into the database servers. The ScaleArc software acts as an intermediary between the application and database layers. Sitting in between, it buffers database outages from impacting application availability and transparently accelerates the application’s performance, all without code or usability changes. This whitepaper explains the benefits of the ScaleArc software and shows benchmarking results of one feature set – app-transparent caching. In our tests, the ScaleArc software enabled a 5x improvement in the operations processed per minute and a drop in CPU consumption from a peak of 100% to a peak of 60%.

Download this new whitepaper today!

Nov 292016
 

vmwareVMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to unexpected changes in behavior. It might even slow down your SQL Servers.

Here’s what you need to do to fix it.

Continue reading »