Archive for the ‘Business Intelligence’ Category

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 to add a map to a report and show the states in the US or the counties within a state.  You can use the map to render one or more data points, providing a slick visualization of your data by state or county within a state. Read More.


Read Full Post »

Microsoft just announced the release of the next version of SQL Server, code named Denali, at the PASS Summit in Seattle.  The Community Technology Preview (CTP) version, somewhat like an early alpha or beta release, is available for download now to MSDN members.

Microsoft SQL Server 2011, code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights. Read More. Download the CTP. Release Notes.

Read Full Post »

Discover the true power of Business Intelligence at the Microsoft Business Intelligence Conference at Tech·Ed North America.

BI Conference 2010

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, implementation best practices, customer insights and expert guidance relating to Microsoft Business Intelligence products.


Read Full Post »

Oracle Database 11g Release 2

Oracle Database 11g Release 2 delivers industry leading performance, scalability, security and reliability. It provides comprehensive features to easily manage the most demanding transaction processing, business intelligence, and content management applications.

Register here for one of the upcoming Webcasts to learn how you can transform your business, budgets, and service levels with Oracle Database 11g Release 2.


Read Full Post »

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 and projects for reports, ETL dataflows, OLAP cubes and data mining structures.


Read Full Post »

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 developing reports using SQL Server Reporting Services is required.
  • Some experience in web based development, ASP.NET, C#, and .Net Framework is preferred.
  • Seasoned in the full development life cycle including requirements gathering.
  • Degree in IT/Computer Science or commensurate education and experience.
  • Experience using Agile Software Development methodology is preferred.
  • Understanding of object-oriented analysis and design of complex systems.
  • Experience developing and supporting mission critical applications that function 24 hours a day, 7 days a week.


  • Heavy customized report development.
  • Gathers requirements from product owners and works with team members to create a design supported by the architecture of the existing systems.
  • Performs ongoing Quality Assurance studies to evaluate system efficiency and compliance.
  • Participates in the implementation and maintenance of source control and release procedures.
  • Participates in new system applications demonstrations, training classes, and application system queries sessions for all internal associates when necessary.

Read Full Post »

The following code snippet can be used to get the access history of a MS Dynamics CRM 4.0 Report.


 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'
ReportServer.dbo.Catalog C with(nolock) 
LEFT OUTER JOIN ReportServer.dbo.ExecutionLog  E with(nolock) ON C.ItemID = E.ReportID 


For those who want to deep dive on this Execution Log Reporting domain, please refer:

Using the Reporting Services Execution Log with CRM 4.0

Reporting Services Log Files

Auditing Report Execution using the ReportServer Database

Reading the Report Execution Log for CRM 4.0


Read Full Post »

Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make.

SQL Server 2008 Components in a BI Solution

SQL Server 2008 Components in a BI Solution

Read the full article by Stacia Misner.

Read Full Post »