This Week In Data – Episode 5 (Data Visualization Best Practices)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

xSQL Schema/Data Compare database list is empty

Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0

Summary: When adding...

xSQL Schema/Data Compare database list is empty

Applies to: xSQL Schema Compare v 7.0.0 to v 9.0.0; xSQL Data Compare v 7.0.0 to v 9.0.0

Summary: When adding databases to the workspace both in xSQL Schema Compare...

“Witch” Statistics?

Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three...

Azure Cognitive Services API’s with SQL Server 2016 CLR

[read this post on Mr. Fox SQL blog]
Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that...

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we would...

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we would...

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we would be told to work on something, write the code...

Operational Analytics -SQL Server 2016

What is Operational Analytics:- Operational Analytics is a combination of two words “Operational” and “Analytics”. so your OLTP system is...

SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects

Abstract
This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with...