Databases Archives

Editorials

Kathi Kellenberger in Editorials

What is an ad hoc query?

Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query...

04 May 2021 4 min read

Security

Greg Larsen in Security

SQL Server security – Providing a security model using user-defined roles

Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.…

26 April 2021 13 min read

Performance

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

What is SQL Server, and how does it work? The basics explained

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

28 January 2021 26 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