Learn SQL

DBA in training: SQL Server high availability options

• by Additional Articles

• SimpleTalk

• Learn SQL
• SQL Server

• Article

DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.

2021-06-07

SQL Server authentication methods, logins, and database users

• by Additional Articles

• SimpleTalk

• Learn SQL

• Article

Understanding SQL Server security is a critical skill. Greg Larsen explains SQL Server authentication methods, logins, and database users in this article.

2021-03-15

Mastering TempDB: The basics

• by Additional Articles

• SimpleTalk

• Learn SQL

• Article

Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB including configuration.

2021-02-19

Sort Alphanumeric Values in SQL Server

• by Additional Articles

• MSSQLTips.com

• Learn SQL

• Article

In this tip we look at ways to sort alphanumeric strings in SQL Server by decomposing all numeric values and sorting the string based on numeric sorting rules.

2019-09-25

• Discuss