Does a Primary Key always have stats_id 1?

Back to the SQL Server Basics with Wayne

The Myth
I recently was attending a presentation where the presenter stated that the...

Finding Missing indexes

Situation SQL Server registers every missing index. Here is how you retrieve that information from the missing index DMV’s [crayon-5c335dbc1c266788449988/]...

Finding Unused Indexes

Situation Good index management is key to success. Having too many unused indexes around slows down your system. It is not...

Cloud Backup Comparison

I used to use Crashplan. This was about $150 a year, but I could to 5 machines. I used to...

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC

Configure SQL Server Failover Cluster Instance If you are running a SQL Server Failover Cluster Instance on premises and looking to migrate to Azure, you […]
The post Configure SQL...

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC

Configure SQL Server Failover Cluster Instance If you are running a SQL Server Failover Cluster Instance on premises and looking to migrate to Azure, you might be a little...

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC

Configure SQL Server Failover Cluster Instance If you are running a SQL Server Failover Cluster Instance on premises and looking to migrate to Azure, you might be a little...

I will be speaking @ Tuga IT 2018

Starting on 19th of July and during 3 days the Tuga IT 2018 Summer Edition will be happening in Lisbon!
This...

I will be speaking @ Tuga IT 2018

Starting on 19th of July and during 3 days the Tuga IT 2018 Summer Edition will be happening in Lisbon!
This edition will have:
4 full-day workshops 38 breakout sessions (1...

Kubernetes

Have you heard the name Kubernetes, it is another open source in the market by Google and works one Containers,...