Security

Robert Sheldon in Security

Introduction to SQL Server Security — Part 5

SQL Server contains many built-in views and functions that can be used to understand what is going on “under the...

23 April 2019 21 min read

BI

Andy Brown in BI

Using the FILTER Function in DAX

In the previous article of this series, Andy Brown of Wise Owl Training explained how to use the oh-so-important CALCULATE...

17 April 2019 13 min read

BI

Dennes Torres in BI

Power BI and The Matrix: A Challenge

The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate,...

15 April 2019 14 min read

BI

Gogula Aryalingam in BI

The BI Journey: The Expert’s Advice – Part 2

A BI project should return value to the company quickly, not only after months or even years of work. In...

15 April 2019 13 min read

Performance

Samir Behara in Performance

Designing Highly Scalable Database Architectures

While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and...

09 April 2019 13 min read

BI

Kathi Kellenberger in BI

SSRS Setup Guide: Install & Configure Reporting

Install and configure SQL Server Reporting Services (SSRS) step by step. Covers architecture, security, report development tools, and deployment for...

08 April 2019 16 min read

CosmosDB

Adam Aspin in CosmosDB

Cosmos DB SQL Workarounds: LEFT, RIGHT, YEAR, MONTH, DAY, and Wildcard Search via SUBSTRING and String Functions

Practical workarounds for common T-SQL idioms in Azure Cosmos DB SQL API - wildcard searches using CONTAINS and STARTSWITH, null...

03 April 2019 10 min read

Oracle

Cynthia Dzikiti in Oracle

Security Considerations for ERP Applications

Security is, or at least should be, the priority for any IT system. In this article, Cynthia Dzikiti discusses the...

01 April 2019 16 min read

T-SQL Programming

Mala Mahadevan in T-SQL Programming

Converting a History Table into a System-Versioned Temporal Table

Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a...

13 March 2019 15 min read

Editorials

Kendra Little in Editorials

Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

“There are only two hard things in Computer Science: cache invalidation and naming things” Phil Karlton I’m terrible at naming...

12 March 2019 4 min read

CosmosDB

Adam Aspin in CosmosDB

Introduction to SQL for Cosmos DB

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer....

06 March 2019 22 min read

Database Administration

Greg Larsen in Database Administration

SQL Server Resumable Online Index Rebuild: Pause and Resume Index Operations

SQL Server 2017 introduced resumable online index rebuilds - pause and resume large index operations without losing progress. SQL Server...

05 March 2019 15 min read

T-SQL Programming

Phil Factor in T-SQL Programming

SQL Server Inline Indexes: Add Indexes to Table Variables and UDTTs

SQL Server inline indexes let you define clustered, nonclustered, and filtered indexes directly in CREATE TABLE syntax for table variables,...

26 February 2019 13 min read

Data Privacy and Protection

Robert Sheldon in Data Privacy and Protection

Introduction to SQL Server Security — Part 3

SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the...

25 February 2019 14 min read

BI

Gogula Aryalingam in BI

The BI Journey: The Expert’s Advice – Part 1

Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is...

20 February 2019 14 min read

T-SQL Programming

Kathi Kellenberger in T-SQL Programming

SQL Server 2019 Window Aggregate Performance: Batch Mode on Rowstore

SQL Server 2019 Batch Mode on Rowstore dramatically improves window aggregate performance - running totals, moving averages, and accumulating SUM...

11 February 2019 12 min read

NoSQL

Image of author: Pushpa Sekhara Reddy Matli

Pushpa Sekhara Reddy Matli in NoSQL

Apache Cassandra Data Modeling and Query Best Practices

Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based...

07 February 2019 11 min read

PowerShell

Greg Moore in PowerShell

Using a Server List to Control PowerShell Scripts

PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how...

29 January 2019 13 min read

BI

Gogula Aryalingam in BI

The BI Journey: The Analyst

Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are...

21 January 2019 15 min read

BI

Andy Brown in BI

DAX CALCULATE & VALUES Functions Explained

Understand the DAX CALCULATE and VALUES functions with practical examples. Learn filter context, ALL function, and how to build percentage...

14 January 2019 21 min read

Register for Simple Talk

Databases

Introduction to SQL Server Security — Part 5

Using the FILTER Function in DAX

Power BI and The Matrix: A Challenge

The BI Journey: The Expert’s Advice – Part 2

Designing Highly Scalable Database Architectures

SSRS Setup Guide: Install & Configure Reporting

Cosmos DB SQL Workarounds: LEFT, RIGHT, YEAR, MONTH, DAY, and Wildcard Search via SUBSTRING and String Functions

Security Considerations for ERP Applications

Converting a History Table into a System-Versioned Temporal Table

Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

Introduction to SQL for Cosmos DB

SQL Server Resumable Online Index Rebuild: Pause and Resume Index Operations

SQL Server Inline Indexes: Add Indexes to Table Variables and UDTTs

Introduction to SQL Server Security — Part 3

The BI Journey: The Expert’s Advice – Part 1

SQL Server 2019 Window Aggregate Performance: Batch Mode on Rowstore

Apache Cassandra Data Modeling and Query Best Practices

Using a Server List to Control PowerShell Scripts

The BI Journey: The Analyst

DAX CALCULATE & VALUES Functions Explained