How does SQL 2017 work on Linux?

One of SQL 2017’s major new features is the ability to run on Linux in addition to the traditional Windows installation. This raises a number of questions: How did Microsoft get SQL to work on a non-Windows platform? What are the limitations - if any - of running Microsoft SQL on a non-Windows platform? Are Microsoft SQL Editions and Licensing the same for Linux? How do I install Microsoft SQL on Linux?

Posted on: 21 February 2018 | 10:18 am

Proper Cloud Server Monitoring

Cloud Server Monitoring is quite different from on-premises server monitoring and requires a fundamental change in mindset.  The situation is further complicated when working with hybrid cloud infrastructures or pursuing a multi-provider cloud strategy. Two key questions that need to be answered are...

Posted on: 8 February 2018 | 9:43 am

Advantages and Disadvantages of Cloud

When C-level management and IT professionals clearly understand the potential advantages and disadvantages of cloud computing they can better develop a cohesive cloud strategy that both addresses the organization's technical requirements and is also economically sound.  

Posted on: 30 January 2018 | 10:15 am

Finding SQL Server CPU problems with DMV queries

There are numerous native windows utilitites that IT can avail itself to diagnose SQL Server CPU performance problems.  The utility IT chooses to use will largely depend on the level of SQL Server expertise, the nature of the problem, and the time available to build out a solution. One of the more comprehensive utilities is Dynamic Management Views “DMVs”.

Posted on: 16 January 2018 | 11:25 am

Why Extended Events for SQL Monitoring?

The use of SQL Server Extended Events (XEs) are a critical component to any successful SQL diagnostics effort, especially when deep dive SQL analytics and tracing are needed and the use of a native SQL Server tool is preferred.  

Posted on: 9 January 2018 | 10:18 am

Introducing the Longitude Command Line Interface

Longitude 10.1 introduces the new Longitude Command Line Interface (CLI). The Longitude CLI complements the Longitude Web Interface (Longitude Console) with new scripting capabilities that can be used to automate Longitude’s monitoring behavior.  

Posted on: 2 January 2018 | 10:15 am

Windows Server Performance Monitoring Made Easy

Windows Server  is generally considerd to be a mature and stable operating system platform. With that said, it is no secret that the applications that are part and parcel to Windows Server deployments can compromise server performance if there is a mismatch between resources required and the resources available from the server operating system.

Posted on: 19 December 2017 | 10:23 am

SQL Server Virtualization Best Practices

Understanding the fundamentals of how CPU, memory, disk, and network interact in a virtual infrastructure will go a long way towards helping IT properly allocate virtual resources and make the most effective use of SQL licensing.

Posted on: 12 December 2017 | 10:21 am

Cloud Capacity Planning

Cloud Capacity Planning and performance reporting are absolute musts if an organization is to ensure that it is making the most efficient use of its cloud service providers and their corresponding costs.

Posted on: 29 November 2017 | 11:33 am

Windows Network Metric Guide

Today’s post will look at network monitoring from the perspective of a Windows endpoint in a local area network (LAN), and outline performance metrics specific to optimizing processing incoming and outgoing traffic.

Posted on: 15 November 2017 | 10:15 am