Michael Otey

In this SQL Server Management Studio tutorial (SSMS), I will show you the primary database management and development capabilities provided by the tool. Microsoft SQL Server Management Studio (SSMS) is the primary management and development tool for SQL Server and has been since its release back with SQL Server 2000. SSMS provides a graphical interface…

SQL Server sample databases can be very useful for learning new techniques or trying out various samples of code. In this article, I’ll detail what you can do with the main SQL Server sample databases including Northwind, AdventureWorks, and WideWorldImporters. I’ll also show you how to find these SQL Server sample databases and install them….

Microsoft’s SQL Server Management Studio (SSMS) is the primary tool for working with SQL Server databases. In this article, I’ll guide you through the steps you need to follow to download and install SQL Server Management Studio on your PC. What is SQL Server Management Studio? SQL Server Management Studio provides an integrated environment that…

his new partnership underscores that Azure is Microsoft’s priority going forward and their new open attitude is all about enabling Microsoft to extend Azure’s reach. Let’s take a closer look at what Microsoft and VMware’s new partnership means for the hybrid cloud.

Starting with SQL Server 2017, Microsoft has supported SQL Server on Linux, which has the same underlying database engine as the Windows version. In this article, I’ll show you how to install SQL Server on Linux, as well as Azure Data Studio. The most recent release of SQL Server is SQL Server 2022, which offers…

Learn about the differences in SQL Server’s disaster recovery options so that you know what options you have to prevent your next outage.

Running VMs in the cloud has become a big part of the modernization of IT infrastructure for most businesses. However, even though those VMs that are in the cloud, the backup mechanisms that they use to provide disaster recovery (DR) capabilities are essentially the same as they would use for on-premise VMs. They often use legacy technologies that require a lot of resources and are difficult to scale.

There are two primary types of backup technologies and knowing the difference between backup and replication will help you choose the best path forward.

Building in disaster recovery protection from ransomware is a key step to making sure that when, not if, your company is impacted by these viruses that you remain protected.

While 2020 will surely be remembered as the year of the pandemic, it’s quite possible that 2021 will be remembered as the year of ransomware too. Ransomware attacks seem to be running amok through 2021 and almost daily occurrences have been reported. Ransomware is a type of malware that blocks access to a company’s files…