Learn how to resolve a duplicate value error when processing dimensions in SSAS.

Using Aliases in SQL Prompt

by Additional Articles

Redgate

SQL PROMPT

Phil Factor explores the role of table aliases, explaining when they are required, and their general purpose otherwise, the need for sensible naming of aliases, and how SQL Prompt handles them.

Using Calendars and Dates in Power BI

by Additional Articles

SimpleTalk

You can use a host of time-intelligence functions in DAX to calculate everything from simple year-to-date totals to moving averages and average opening and closing balances. In this article, Andy Brown shows how to model various scenarios with calendars and dates, and how to get around some of the issues you may encounter.

How Do We Prove Expertise?

by Grant Fritchey

SQLServerCentral

Career Growth

Today, Grant Fritchey talks about the two paths to expertise for database professionals and why it’s hard to really know if someone is an expert.

SSRS Audit: All reports executed/not-executed during previous 30 days

by Stan Kulp

SQLServerCentral.com

Reporting Services (SSRS)

This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.

A simple use case for Columnstore Indexes in SQL Server

by Additional Articles

MSSQLTips.com

Performance Tuning

In this article we look at different use cases for columnstore indexes like when performing SQL Server count * queries.

Data Categorization for AdventureWorks using SQL Data Catalog

by Additional Articles

Redgate

data catalogs

Josh Smith shows how to use SQL Data Catalog to perform a 'first cut' data classification for one your SQL Server databases, identifying all columns that are likely to hold personal or otherwise sensitive data.

How to remove quote marks using SSIS and a little C#

by G_M_J

SQLServerCentral

Introduction If you import flat files and use double quotes as your Flat File Text Qualifiers, then it’s likely that you’ve encountered problems when importing data where speech marks have been entered manually. This is a common occurrence in free text fields, such as Name. e.g. Smith, James “Jim” Attempting to import a file with a […]