SQL Server 2008 introduced new spatial data types including a geography type that can be used to store latitude and longitude coordinates. The new map feature in SQL Server Reporting Services 2008 R2 works with the geography type as well as with state abbreviations, state names, or state numbers. The built-in map feature allows you [...]
Archive for the ‘SSRS’ Category
SSRS Maps!
Posted in BIDS, Business Intelligence, SQL Server 2008 R2, SSRS 2008 R2, tagged BI, BIDS, Maps, Spatial Data, SSRS on December 8, 2010 | Leave a Comment »
BI Conference 2010
Posted in BIDS, Business Intelligence, Microsoft, SSAS, SSIS, SSRS, tagged BI Conference 2010, Microsoft BI on March 20, 2010 | Leave a Comment »
Discover the true power of Business Intelligence at the Microsoft Business Intelligence Conference at Tech·Ed North America. Come and see how Microsoft can help you design, build and deploy robust Business Intelligence applications for everyone in your organization while controlling costs. It is the single best place to get the latest business strategy, product information, [...]
Business Intelligence Development Studio
Posted in BIDS, Microsoft, SSAS, SSIS, SSRS, tagged BIDS, Business Intelligence Development Studio on February 9, 2010 | Leave a Comment »
Business Intelligence Development Studio (BIDS) is the IDE from Microsoft used for developing data analysis and Business Intelligence solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration Services. It is based on the Microsoft Visual Studio development environment but customizes with the SQL Server services-specific extensions and project types, including tools, controls [...]
SQL Server Reporting Services Consultant
Posted in Business Intelligence, SSRS, tagged SQL Server Reporting Services Consultant on September 10, 2009 | 1 Comment »
Recently we came across a job offering for a “SQL Server Reporting Services Consultant”. Thought of sharing the roles & responsibilities of that position with you all. Here goes the list Qualifications & Experience: Three or more years experience in relational database design and development using SQL Server is required. One or more years experience [...]
Access History of a CRM 4.0 Report
Posted in Business Intelligence, CRM 4.0, SSRS, SSRS 2005, SSRS 2008, tagged Access History, Auditing Report Execution, Execution Log Reporting on August 25, 2009 | Leave a Comment »
The following code snippet can be used to get the access history of a MS Dynamics CRM 4.0 Report. SELECT C.Name ‘Report_GUID’ ,CASE WHEN ((PATINDEX(‘%CRM_FormatDate=%’, E.Parameters)- (PATINDEX(‘%CRM_FullName=%’, E.Parameters) + 14 )) > 0) THEN SUBSTRING(E.Parameters,(PATINDEX(‘%CRM_FullName=%’, E.Parameters)+13), (PATINDEX(‘%CRM_FormatDate=%’, E.Parameters)- (PATINDEX(‘%CRM_FullName=%’, E.Parameters) + 14 ))) END ‘UserName’ ,E.TimeStart ,E.TimeEnd ,E.Status FROM [...]
Planning Your First Microsoft BI Solution
Posted in Business Intelligence, SQL Server 2008, SSAS, SSIS, SSRS on July 22, 2009 | Leave a Comment »
Introduction to BI
Avoiding common problems with corporate databases
A walk through the Microsoft BI stack
Building a simple solution
