SQL

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

Recruiting DBAs for DevOps

• by Additional Articles

• SimpleTalk

• DevOps and Continuous Delivery (CI/CD)

• Article

DBAs are in great demand, but what if you are recruiting a DBA for DevOps? Mike Cuppett explains how to hire and train the right DBA for the job.

2021-03-12

Storage 101: RAID

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

RAID has been around since the 90s to ensure performance and reliability of storage. Robert Sheldon explains the history and theory behind RAID.

2021-03-11

How to become a data scientist: A data-driven approach to careers in data science

• by Additional Articles

• SimpleTalk

• Data Science

• Article

Many devs and IT professionals looking for the next career wonder how to become a data scientist. Ashwin Thota matches up skills to job titles.

2021-03-09

SQL Server 101 Tutorial

• by Additional Articles

• MSSQLTips.com

• SQL Server

• Article

Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform. While the core of SQL Server is still it's database engine, it is now so much more than just a relational database plat

2021-03-04

Unlocking the “PASS Pro” Educational series

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Thanks to the consent of the speakers, the expert-led educational training courses covering the following four topics: Data Modernization, Azure Migration, Azure Synapse, Azure SQL, are now available to all. You can watch the sessions and learn from a range of experts online, for free.

2021-03-17 (first published: 2021-03-01)

DBA in training: SQL Server under the hood

• by Additional Articles

• SimpleTalk

• SQL
• Training

• Article

In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.

2021-02-23

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

Execute Dynamic SQL commands in SQL Server

• by Additional Articles

• MSSQLTips.com

• Dynamic SQL

• Article

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.

2021-02-15

Search SQL Server error log files

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

The SQL Server error log is helpful for troubleshooting issues. Greg Larsen demonstrates several ways to search SQL Server error log files.

2021-02-11