Format String Issue of SSAS Measures in Excel Front-End

Posted by on Dec 10, 2013 in SSAS | No Comments

Most of you faced such situation that you’ve set the FormatString property of your measures in the cube from BIDS or SSDT, But when you browser the cube in Excel you will not see that format. Let’s say you applied format string to add thousands separator, two decimal points, and dollar sign to your Amount ...

Read More

Session Materials to Download: Master Data Management with SQL Server 2012

Posted by on Nov 25, 2013 in MDS, Presentations | No Comments

Thanks for all attendees in my session about Master Data Management with SQL Server 2012 as part of NetCom Learning free webinars. In this session below contents covered: Creating Entities for reference data Relationship between entities Business Rules and their usages User Interfaces for working with Master Data Services Hierarchies Integration Views for using in ...

Read More

Lag and Lead Functions in SQL Server 2012

Posted by on Sep 10, 2013 in SQL Server, T-SQL | No Comments

SQL Server 2012 has a set of useful functions to work in T-SQL environment. Lead and Lag are one of the most useful functions introduced in 2012. Lag function helps to access values from previous records, and Lead function helps to access values from next records in the data set. structure of working with these ...

Read More

Error Handling in SSIS; Download presentation materials and recording

Posted by on Aug 22, 2013 in Presentations, SSIS | No Comments

Thanks for all attendees of today’s webinar about Error Handling in SSIS. turnout was good, and good questions asked and responded. Here are topics that covered in this session: Error handling in SSIS Data Taps Logging SSIS Catalog stored procedures for Logging and execution Debugging and Troubleshooting SSIS packages some live demos about error handling, ...

Read More

T-SQL Script to get row count of all tables in the database

Posted by on Aug 18, 2013 in SQL Server, T-SQL | No Comments

Today I’ve wrote a simple script to get number of records for all tables in a database and fetch those tables that contains at least one record. This picture shows an example of result set: Here is the script: declare @tempTable table(tablename varchar(max), rowscount int,processed bit) insert into @tempTable select TABLE_NAME,0,0 from INFORMATION_SCHEMA.TABLES where TABLE_CATALOG=‘DEMO’ ...

Read More