Thursday, September 26, 2013

Load Data from Stored Procedure in TimeXtender 2012

›
TimeXtender 2012 is a new data warehouse development tool that I’ve been using to rapidly increase the ETL Development. There are lots of ...
7 comments:
Thursday, September 5, 2013

Use SSRS Data Alert

›
  SQL 2012 Reporting Services has data alerts capability.  It is a data driven alerting solution. You could use it to inform the users abou...
6 comments:
Tuesday, July 30, 2013

Use DAX Search Function to Retrieve Subset Data in SSRS Report

›
Most of you would be familiar with substring search in T-SQL. If you have a SSRS report using DAX, do you ever winder how to do the search u...
2 comments:
Friday, May 31, 2013

Setup SSRS email Delivery Option Using Gmail Account

›
  In order to use the SSRS email delivery subscription or Data alerts feature, you need to configure the email option. If you don’t have ac...
3 comments:
Wednesday, March 27, 2013

Trigger SQL Agent Job by Files

›
  Wondering how to trigger a SQL agent job when the file is ready to be processed?  The simple and easy way to trigger a SQL Job after a fil...
6 comments:
Friday, November 2, 2012

SQL Saturday #174 Recap

›
  What a great success SQL Saturday was in Charlotte last weekend.  I volunteered to be a proctor in the morning, so I could attend and als...
Friday, October 5, 2012

Use Sybase SQL Anywhere as data source for PowerPivot

›
To use Sybase SQL Anywhere as the Power Pivot data source, you need to use ODBC. It is not intuitive to set it up.  After encountered severa...