Database Administration Greg Larsen in Database Administration Developing a backup plan Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to... 23 November 2020 12 min read
T-SQL Programming Joe Celko in T-SQL Programming Database Normal Forms Explained: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, and DKNF Complete reference to database Normal Forms - First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Elementary... 20 November 2020 23 min read
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
Database Administration Greg Larsen in Database Administration SQL Server Backup Types One of the most important responsibilities for a DBA is to ensure that a database can be restored in case... 26 October 2020 14 min read
Security, Privacy & Compliance Fabiano Amorim in Security, Privacy & Compliance SQL Server View-Based Security Flaw: How Error Messages Expose Hidden Data View-based row-level security in SQL Server leaks information through error messages - a user who can't see a row can... 19 October 2020 11 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 Robert Sheldon in Database Administration Storage 101: Monitoring storage metrics Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important... 06 October 2020 15 min read
Performance Edward Pollack in Performance SQL Server Remote Data: Linked Servers, OPENQUERY & ETL Best practices for accessing remote data in SQL Server. Covers linked servers, OPENQUERY vs four-part naming, SSIS packages, OPENROWSET, and... 30 September 2020 23 min read
Database Administration Greg Larsen in Database Administration SQL Server Synonyms SQL Server synonyms can be used to permanently alias database objects in the same or another database. In this article,... 22 September 2020 13 min read
BI Bill Pearson in BI DAX financial functions: Loan calculations Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions.... 19 September 2020 27 min read
BI Rodney Landrum in BI Azure Data Factory pipelines: Filling in the gaps Azure Data Factory is a cloud based data orchestration tool that many ETL developers began using instead of SSIS. In... 18 September 2020 17 min read
T-SQL Programming Joe Obbish in T-SQL Programming Dynamic Data Unmasking The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems... 15 September 2020 12 min read
Career Pamela Mooney in Career How to know your server environment(s) (DBA in Training, part three) It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may... 14 September 2020 11 min read
Performance Robert Sheldon in Performance SQL Server Computed Columns: Persisted vs Indexed Performance Compare SQL Server computed column performance across four configurations: non-persisted, persisted, indexed, and indexed-persisted. Includes execution plans and benchmarks using... 10 September 2020 14 min read
T-SQL Programming Edward Pollack in T-SQL Programming Query Patterns for Columnstore Indexes: Joins & Performance (Part 4) Optimize query patterns against columnstore indexes in SQL Server. Learn segment and rowgroup elimination, dimension table joins, performance pitfalls, and... 01 September 2020 21 min read
Database Administration Greg Larsen in Database Administration Understanding SQL Server Recovery Models The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg... 27 August 2020 12 min read
Career Pamela Mooney in Career How to prepare for a DBA job interview (DBA in training, part two) Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains... 26 August 2020 18 min read
Database Administration Robert Sheldon in Database Administration Storage 101: The Future of Storage Robert Sheldon continues his series on storage by discussing the latest storage innovation and ideas. … 21 August 2020 13 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 3 Nonclustered Indexes Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap... 18 August 2020 8 min read
Career Pamela Mooney in Career How to become a DBA – the first steps (DBA in Training, part one) Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives... 11 August 2020 15 min read
