Databases Archives

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

Databases

Robert Sheldon in Databases

SQL Server Contained Databases: Users & Portability

How SQL Server's partially contained databases work — creating contained users, duplicating them across databases, and unlinking users from logins.…

25 February 2019 15 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

SQL Server

Robert Sheldon in SQL Server

SQL Server Access Control: Logins, Roles & Permissions

How to create SQL Server logins, roles, and database users, then grant, deny, and revoke permissions on them with T-SQL...

28 January 2019 24 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

T-SQL Programming

Joe Celko in T-SQL Programming

Empty Thoughts: Working with NULL

Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is...

10 January 2019 12 min read

Database Administration

Greg Larsen in Database Administration

Protecting SQL Server Data Using Static Data Masking

In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and...

07 January 2019 19 min read

SQL Server

Robert Sheldon in SQL Server

SQL Server Security Overview: Authentication to Encryption

An overview of SQL Server's security toolkit — authentication modes, principals/permissions, encryption, auditing, and vulnerability tools.…

31 December 2018 15 min read

BI

Andy Brown in BI

Creating DAX Measures in Power BI: Calculated Fields, Time Intelligence, and CALCULATE

Learn to create DAX measures in Power BI: SUM, AVERAGE, COUNT for single columns, SUMX and COUNTX iterator functions for...

28 December 2018 23 min read

T-SQL Programming

Phil Factor in T-SQL Programming

SQL Server Export Formats Compared: BCP, XML, CSV, Tab-Delimited Performance and Gotchas

Benchmarked comparison of SQL Server export formats - native BCP, XML via BCP, CSV, tab-delimited - for performance and handling...

24 December 2018 13 min read

BI

Eugene Meidinger in BI

SSRS Reporting Basics: When is SSRS the Right Tool?

SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in...

18 December 2018 11 min read

Database Administration

Kellyn Pot'Vin-Gorman in Database Administration

How to Linux for SQL Server DBAs — Part 3

DBAs running SQL Server on Linux will not only need to understand SQL Server security well, they will also need...

07 December 2018 14 min read

T-SQL Programming

Joe Celko in T-SQL Programming

Data Quality

Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks...

05 December 2018 11 min read

BI

Robert Sheldon in BI

Visualize SQL Server Audit Data in Power BI: Tables, Charts, and Gauges

Connect Power BI Desktop to SQL Server Audit data to create interactive reports. Covers test database setup, DML/DDL audit generation,...

29 November 2018 21 min read

T-SQL Programming

Greg Larsen in T-SQL Programming

There is a New COUNT in Town

Now that SQL Server 2019 is on the way, it’s time to start learning about the new capabilities. In this...

29 November 2018 14 min read

T-SQL Programming

Phil Factor in T-SQL Programming

SQL Server JSON: Transferring Data with FOR JSON, OPENJSON, and JSON Schema Validation

Transfer data between SQL Server databases using JSON - exporting tables with FOR JSON, importing with OPENJSON, validating file contents...

25 November 2018 31 min read