Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Adam Aspin

SQLServerCentral.com profile

   Items 1 to 20 of 22    Older >>
 

Sharing on-premises SQL Server Data Analyses in the Cloud with Power BI

In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data  Read more...
By Adam Aspin 2016/05/23 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 987 reads

Adding Time Intelligence to a Power BI Data Model

In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data  Read more...
By Adam Aspin 2016/06/06 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 1,676 reads

Third Party Visuals in Power BI Desktop

Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals  Read more...
By Adam Aspin 2016/05/31 | Source: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 1,469 reads

Do It Yourself Load Balancing with SSIS

This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database  Read more...
By Adam Aspin 2015/08/03 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,313 reads

Data Load Optimisation using the SSIS Balanced Data Distributor

Optimize SSIS data loads using parallel processing and the Balanced Data Distributor  Read more...
By Adam Aspin 2015/07/02 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,349 reads

Interactive Parameter Selection with Reporting Services

Revamp the classic Reporting Services interface with a more modern look and feel adapted to mobile BI  Read more...
By Adam Aspin 2015/05/21 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 7,008 reads

Adding Slicers to a Reporting Services Report

This article shows you how to create dynamic slicers from a data set in an SSRS report  Read more...
By Adam Aspin 2016/08/05 (first published: 2015/04/23) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 11,195 reads

Maps in SQL Server Reporting Services

Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.  Read more...
By Adam Aspin 2015/04/13 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 7,381 reads

Data Profiling with T-SQL

Need to understand new data? This article explains why - and how you can profile it efficiently  Read more...
By Adam Aspin 2013/02/25 | Source: SQLServerCentral.com | Category: data profiling
Rating: |  Discuss |   Briefcase | 2,701 reads

Slowly changing dimensions using T-SQL MERGE

Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.   Read more...
By Adam Aspin 2011/06/20 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 16,179 reads

Industrial-strength database documentation using Extended Properties

To finish this short series on extended properties a look at documenting sets of database objects  Read more...
By Adam Aspin 2011/04/05 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 7,815 reads

Modifying and deleting extended properties

Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties  Read more...
By Adam Aspin 2011/03/29 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 4,600 reads

Extracting Extended Properties

In this second article of a short series we look at using the Extended Properties which you have added to a database  Read more...
By Adam Aspin 2011/03/22 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 7,087 reads

Extended Properties Introduction

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties  Read more...
By Adam Aspin 2013/09/27 (first published: 2011/03/17) | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 15,457 reads

A faster way to prepare dimensional databases

When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?  Read more...
By Adam Aspin 2010/12/17 (first published: 2010/02/24) | Source: SQLServerCentral.com | Category: analysis services (ssas)
Rating: |  Discuss |   Briefcase | 15,744 reads

Fast normalization of a denormalized data source, using surrogate IDs

A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.  Read more...
By Adam Aspin 2010/01/25 | Source: SQLServerCentral.com | Category: normalization
Rating: |  Discuss |   Briefcase | 5,113 reads

SQL Server Agent Jobs – Displaying Status in an Application

This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page  Read more...
By Adam Aspin 2009/09/16 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 7,978 reads

Returning full error details from SQL Server Agent jobs

Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!  Read more...
By Adam Aspin 2009/09/09 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 18,469 reads

Conditional formatting with Reporting Services

In another article on the presentation layer aspects of reporting Services, Adam Aspin explains how to add conditional formatting to your reports  Read more...
By Adam Aspin 2009/05/05 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 11,978 reads

Report Templates Using Stylesheets

In the third article in his series on styling reports, Aaron Akin takes a look at using templates to ease and speed development.  Read more...
By Adam Aspin 2009/03/12 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 11,880 reads
   Items 1 to 20 of 22    Older >>