Michael Otey

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…

With World Backup Day just behind us (and yes there really is such a thing – it was March 31st), now would be a good time to review your backup checklist to ensure your critical data has the protection that your organization requires. The following backup checklist can help guide you through the process of…

A lot of businesses have begun to incorporate the cloud into their backup processes and most businesses that haven’t done so yet are looking into the process. Using the cloud as a backup target has a lot of advantages; Cloud services have matured and provide extremely high levels of availability.

SQL Server’s T-SQL query language has a plethora of data retrieval options. That includes the ability to query a SQL database, as well as providing a sum function, a count aggregate function, and grouping columns. The SQL GROUP BY clause can make use of all of these capabilities. In this article, I’ll show you how…

In this article, I’ll cover the basics of using the SQL SELECT statement to retrieve data from one or more SQL Server tables. I’ll also detail how to retrieve selected columns, as well as how to use the SQL WHERE and HAVING clauses to filter rows. The samples in this article all use the AdventureWorksLT2019…