Learn SQL Server Robert Sheldon in Learn SQL Server How to enable SQL Server trace flags DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to... 07 July 2021 14 min read
Learn SQL Server Greg Larsen in Learn SQL Server Managing SQL Server transaction log size The SQL Server transaction log must be managed to keep a database running and performing well. In this article, Greg... 29 June 2021 14 min read
Learn SQL Server Greg Larsen in Learn SQL Server SQL Server transaction log architecture The transaction log file for a SQL Server database critical for for maintaining database integrity. In this article, Greg Larsen... 08 June 2021 12 min read
Learn SQL Server Pamela Mooney in Learn SQL Server DBA in training: SQL Server high availability options DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses... 19 May 2021 23 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
Learn SQL Server Pamela Mooney in Learn SQL Server DBA in training: SQL Server under the hood 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
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
Database Administration Pamela Mooney in Database Administration DBA in training: Backups, SLAs, and restore strategies There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come... 09 November 2020 21 min read
Database Administration Pamela Mooney in Database Administration DBA in training: Security Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting... 08 October 2020 27 min read
Alex Grinberg SQL Server Temporal Tables: How-To Recipes Tables that return the value of the data in the table at a particular point of time have been with... 10 February 2017 15 min read
Artemakis Artemiou Implementing SQL Server In-Memory OLTP How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables?... 11 April 2016 12 min read
Robert Sheldon SQL Server System Views: The Basics When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the... 27 January 2016 19 min read
Robert Sheldon JSON support in SQL Server 2016 At last, SQL Server has caught up with other RDBMSs by providing a useful measure of JSON-support. It is a... 15 December 2015 21 min read
Artemakis Artemiou Introducing SQL Server In-Memory OLTP In-Memory OLTP, aka Hekaton, originally shipped with 2014, and although it certainly helped the performance of certain types of workload,... 30 September 2015 10 min read
Phil Factor Schema-Based Access Control for SQL Server Databases Access-control within the database is important for the security of data, but it should be simple to implement. It is... 09 April 2015 25 min read
William Sisson Where in the Application Should Data Validation be Done? Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to... 04 November 2014 12 min read
Edward Elliott Improving the Quality of SQL Server Database Connections in the Cloud To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but... 22 September 2014 20 min read
Melanie Townsend Avoiding Database Deployment Disasters – 7 Tips Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a... 02 July 2014 7 min read
Joe Celko The SQL of The Game of Life Joe finds a reference to Conway's Game of Life whilst clearing out his desk, and is suddenly gripped with nostalgia.... 05 June 2014 7 min read
