Edward Pollack in Performance

SQL Server Plan Cache Mining: Plan Attributes, SET Options, and Compatibility

Mine the SQL Server execution plan cache with sys.dm_exec_plan_attributes: analyse compatibility level, SET options, DATEFORMAT, and DATEFIRST settings that affect...

26 April 2021 20 min read

.NET

Lance Talbert in .NET

Using MySQL with Unity

Even games must store data like top scores. In this article, Lance Talbert explains how to save data using MySQL...

15 April 2021 16 min read

NoSQL

Robert Sheldon in NoSQL

How to choose between SQL and NoSQL databases

Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL...

13 April 2021 10 min read

Database Administration

Greg Larsen in Database Administration

SQL Server Security – Fixed server and database roles

Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.…

01 April 2021 13 min read

Database Administration

Edward Pollack in Database Administration

SQL Server Data Dictionary: Build Your Own

Build a custom SQL Server data dictionary using T-SQL. Automate metadata collection, track schema changes, and document tables, columns, and...

01 April 2021 33 min read

Oracle

Jonathan Lewis in Oracle

Oracle sequences: The basics

Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they...

26 March 2021 14 min read

T-SQL Programming

Shel Burkow in T-SQL Programming

A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II

In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.…

26 March 2021 15 min read

Security

Robert Sheldon in Security

What to monitor for SQL Server security

Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.…

24 March 2021 11 min read

Database Administration

Monica Rathbun in Database Administration

TempDB Growth: Diagnose & Fix SQL Server Issues

Fix uncontrolled TempDB growth in SQL Server. Learn to diagnose causes - query spills, version store, temp tables - shrink...

22 March 2021 11 min read

T-SQL Programming

Joe Celko in T-SQL Programming

What is interpolation?

In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before...

11 March 2021 10 min read

Editorials

Monica Rathbun in Editorials

How SQL Server synonyms help database DevOps

Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that...

05 March 2021 3 min read

T-SQL Programming

Shel Burkow in T-SQL Programming

A data transformation problem in SQL and Scala: Dovetailing declarative solutions

This article is an interesting approach to solving a data transformation problem in SQL and Scala. Shel Burkow uses a...

22 February 2021 11 min read

Learn SQL Server

Greg Larsen in Learn SQL Server

SQL Server authentication methods, logins, and database users

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

22 February 2021 14 min read

Database Administration

Robert Sheldon in Database Administration

Storage 101: RAID

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

16 February 2021 11 min read

SQL Server

Pamela Mooney in SQL Server

The basics of SQL Server internals (DBA in training, part seven)

In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query...

28 January 2021 27 min read

Learn SQL Server

Monica Rathbun in Learn SQL Server

Mastering TempDB: The basics

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

26 January 2021 11 min read

Database Administration

Edward Pollack in Database Administration

SQL Server Triggers: When to Use (and Avoid)

SQL Server DML triggers explained - AFTER, INSTEAD OF, logging, validation. When triggers help, when they hurt performance, and best...

25 January 2021 37 min read

Database Administration

Greg Larsen in Database Administration

Search SQL Server error log files

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

19 January 2021 11 min read

Oracle

Jonathan Lewis in Oracle

Oracle archived redo size – the research

Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes...

11 January 2021 15 min read

Career

Sergey Gigoyan in Career

SQL Server interview questions for experienced developers

SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this...

05 January 2021 16 min read

Register for Simple Talk

Databases

SQL Server Plan Cache Mining: Plan Attributes, SET Options, and Compatibility

Using MySQL with Unity

How to choose between SQL and NoSQL databases

SQL Server Security – Fixed server and database roles

SQL Server Data Dictionary: Build Your Own

Oracle sequences: The basics

A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II

What to monitor for SQL Server security

TempDB Growth: Diagnose & Fix SQL Server Issues

What is interpolation?

How SQL Server synonyms help database DevOps

A data transformation problem in SQL and Scala: Dovetailing declarative solutions

SQL Server authentication methods, logins, and database users

Storage 101: RAID

The basics of SQL Server internals (DBA in training, part seven)

Mastering TempDB: The basics

SQL Server Triggers: When to Use (and Avoid)

Search SQL Server error log files

Oracle archived redo size – the research

SQL Server interview questions for experienced developers