Databases Archives

Robert Sheldon in SQL Server

SQL Server Security Tools: Vulnerability Assessment & Config

How to use SQL Server Configuration Manager, sp_configure, Vulnerability Assessment, and Data Discovery & Classification to harden an instance.…

29 May 2019 15 min read

BI

in BI

Streamlining a Power BI Solution

Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time...

17 May 2019 11 min read

CosmosDB

Adam Aspin in CosmosDB

Cosmos DB SQL: Querying Complex JSON – Arrays, Schema on Read, and Subqueries

Query complex JSON in Azure Cosmos DB SQL: access subnodes and arrays, handle schema-on-read inconsistencies, detect missing attributes, check data...

13 May 2019 16 min read

Containers and Virtualization

Carlos Robles in Containers and Virtualization

Creating Your First SQL Server Docker Container in macOS

The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL...

13 May 2019 14 min read

BI

Gogula Aryalingam in BI

The BI Journey: The Journey Begins

Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after...

08 May 2019 12 min read

Other

Phil Factor in Other

Enjoying Joins in MongoDB

MongoDB has a prodigious appetite for unstructured data and has its place in a Database Developer’s toolkit. Even with indexes...

02 May 2019 14 min read

Oracle

David Njoku in Oracle

Oracle for Absolute Beginners: Problem-Solving as a New Developer

Learning programming logic and syntax is just the beginning. In this article, David Njoku talks about how to debug and...

30 April 2019 9 min read

SQL Server

Robert Sheldon in SQL Server

SQL Server Security Catalog Views, DMVs & Functions

The key SQL Server catalog views, DMVs, and system functions for auditing permissions, encryption, and logins — with T-SQL query...

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

SQL Server

Robert Sheldon in SQL Server

SQL Server Built-In Accounts: sa, dbo, guest & sys

What SQL Server's built-in principals (sa, public, dbo, guest, sys, INFORMATION_SCHEMA) do by default, and how to check or change...

26 March 2019 18 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