Pamela Mooney in Database Administration

DBA in training: Know your server’s limits

Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to...

10 December 2020 14 min read

Oracle

Jonathan Lewis in Oracle

Are your Oracle archived log files much too small?

Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs....

30 November 2020 12 min read

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

Oracle

Srinivasan Suresh in Oracle

SQL Developer – A great tool and better ways to use it

SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features...

19 November 2020 14 min read

Database Administration

Pamela Mooney in Database Administration

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

Data Security, Privacy, and Compliance

Fabiano Amorim in Data Security, Privacy, and 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

Database Administration

Pamela Mooney in Database Administration

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

Oracle

Cynthia Dzikiti in Oracle

Why choose Oracle?

Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article,...

28 September 2020 11 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

DBA in training: Know your environment(s)

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

Oracle

Kellyn Pot'Vin-Gorman in Oracle

What is Oracle ASM to Azure IaaS?

Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS.…

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

Register for Simple Talk

Databases

DBA in training: Know your server’s limits

Are your Oracle archived log files much too small?

Developing a backup plan

Database Normal Forms Explained: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, and DKNF

SQL Developer – A great tool and better ways to use it

SQL Server Backup Strategy: RPO, RTO, Recovery Models, and Restore Types

SQL Server Backup Types

SQL Server View-Based Security Flaw: How Error Messages Expose Hidden Data

SQL Server Security for DBAs: Authentication, Permissions, Monitoring, and Audit

Storage 101: Monitoring storage metrics

SQL Server Remote Data: Linked Servers, OPENQUERY & ETL

Why choose Oracle?

SQL Server Synonyms

DAX financial functions: Loan calculations

Azure Data Factory pipelines: Filling in the gaps

Dynamic Data Unmasking

DBA in training: Know your environment(s)

What is Oracle ASM to Azure IaaS?

SQL Server Computed Columns: Persisted vs Indexed Performance

Query Patterns for Columnstore Indexes: Joins & Performance (Part 4)