Select Page
Animated GIF displaying Query Optimizer enhancements

Smarter, faster, safer: Azure SQL Data Warehouse is simply unmatched

Today, we want to call attention to the exciting news that Azure SQL Data Warehouse has again outperformed other cloud providers in the most recent GigaOm benchmark report. This is the result of relentless innovation and laser-focused execution on providing ... continue reading
image

Schema validation with Event Hubs

Event Hubs is fully managed, real-time ingestion Azure service. It integrates seamlessly with other Azure services. It also allows Apache Kafka clients and applications to talk to Event Hubs without any code changes. Apache Avro is a binary serialization format ... continue reading
Agent Version and Health report

Agent Version and Health report

First published on TECHNET on Apr 09, 2015A customer asked me to put together a SCOM data warehouse report that would list Agents from all Management Groups, and some general Agent version and health information. The report I put together ... continue reading
Logical Disk Fragmentation Report

Logical Disk Fragmentation Report

First published on TECHNET on Aug 25, 2011Here’s a simple custom report that shows the fragmentation of each logical disk based on the Logical Disk Fragmentation Monitor in the Windows Server Operating System Management Pack. The report has a “Fragmentation ... continue reading
Workflow Failure Queries

Workflow Failure Queries

First published on TECHNET on Jul 29, 2011I regularly see customers getting a lot of alerts indicating that workflows have failed to run a script of WMI query…the alert name is usually one of the following:Workflow Runtime: Failed to run ... continue reading
Unhealthy Monitors Report

Unhealthy Monitors Report

First published on TECHNET on May 06, 2011I recently put together an “Unhealthy Monitors” report for an OpsMgr Administrator to see which Monitors are causing the most state degradation in the environment. This report lists all monitors that have objects ... continue reading
Active Alerts Report

Active Alerts Report

First published on TECHNET on Nov 08, 2010NOTE: This report uses the Operations Database instead of the Data Warehouse….in order for it to work, you must create an SRS Data Source for the OpsDB…Kevin Holman has instructions for this here ... continue reading

Free cloud data services training roundup

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free data and artificial intelligence (AI) trainings in one convenient post. SQL Server and Windows Server 2008 end of support End ... continue reading
image

Microsoft continues to build the case for data estate modernization on Azure

Special thanks to Rik Tamm-Daniels and the Informatica team for their contribution to this blog post. ​ With the latest release of Azure SQL Data Warehouse, Microsoft doubles-down on Azure SQL DW as one of the core data services for ... continue reading

Join us at SQL Bits 2019 February 27-March 2 in Manchester, UK!

Data never rests, nor does the data platform. It keeps evolving as more organizations turn to data driven insights to stay ahead and prepare for the future. Be a part of the largest SQL Server professional gathering in Europe at ... continue reading