SQL Server Pamela Mooney in SQL Server SQL Server Backup Strategy: RPO, RTO, Recovery Models, and Restore Types Build a SQL Server backup strategy from SLA to implementation: understand RPO and RTO, choose the right recovery model (FULL,... 09 November 2020 21 min read
SQL Server Pamela Mooney in SQL Server SQL Server Security for DBAs: Authentication, Permissions, Monitoring, and Audit Comprehensive SQL Server security guide for DBAs - covering physical and data-file security, patching, authentication (Windows vs SQL), server and... 08 October 2020 28 min read
Database Administration Alex Grinberg in Database Administration SQL Server Temporal Tables: Practical Recipes & Examples Practical recipes for SQL Server temporal tables: create system-versioned tables, query historical data with FOR SYSTEM_TIME, manage retention, and implement... 10 February 2017 16 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
CI/CD Jonathan Hickford in CI/CD Database Continuous Integration with AppVeyor and Redgate: SQL Source Control, SQL CI, and tSQLt Unit Tests in a CI Pipeline Setting up database CI with AppVeyor and Redgate tools - linking SQL Server databases to source control with SQL Source... 08 July 2014 21 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
Robert Sheldon TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get... 19 May 2014 31 min read
Robert Sheldon SQL Server XML Questions You Were Too Shy To Ask Sometimes, XML seems a bewildering convention that offers solutions to problems that the average database user doesn't have. To make... 22 April 2014 26 min read
Dwain Camps High Performance Relational Division in SQL Server Relational division is used in SQL to select rows that conform to a number of different criteria. It is a... 24 March 2014 28 min read
Learn SQL Server Jes Borland in Learn SQL Server SQL Server Indexed Views: What They Are and How to Create Them SQL Server indexed views persist query results as a physical clustered index, making complex aggregations and joins fast for repeated... 12 February 2014 24 min read
Joe Celko SQL Server SEQUENCE Basics The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is... 06 February 2014 13 min read
Learn SQL Server Phil Factor in Learn SQL Server Primary Key Primer for SQL Server Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules,... 02 December 2013 22 min read
Dwain Camps A SQL-Based Universal Currency Formatter SQL Server isn't usually the best place to format dates or currency as strings. It can be a complex task... 07 February 2013 12 min read
