Category Archives: SQL Server

SQL Best Practices for SharePoint Farm – Configure SQL Alias on all SharePoint Web and Application Servers

To improve ease of maintenance and allow flexibility to move SharePoint databases to the different SQL server instance, one of the best practices for SharePoint Farm administrators is to configure SQL Server Connection Aliases for each SharePoint server in your … Continue reading

Posted in SP2010 Admin, SP2013 Admin, SQL Server | 7 Comments

Step by Step: Consuming SharePoint 2010 Lists Data in the SSRS 2008 R2 Reports

In the SSRS 2005 and SSRS 2008, one of the biggest limitations of the SSRS integration with the SharePoint technologies in the native mode or integrated mode was that there were are no intuitive ways to report against the SharePoint lists … Continue reading

Posted in SP2010 & SSRS, SSRS 2008 R2 | 3 Comments

Differences between SSRS 2008 and SSRS 2008 R2 Report Data Sources

If you are running SSRS 2008 SP1 for your reporting needs, here is the quick comparison of SSRS 2008 SP1 and SSRS 2008 R2 report data sources. If you need to access SharePoint Lists and Azure databases from the SSRS … Continue reading

Posted in SP2010 & SSRS, SSRS 2008, SSRS 2008 R2 | Leave a comment

Repeating Table Header on Each Page of the Report in the SSRS 2008

In the SSRS 2008, if a report with a tablix is created without using the wizard feature (Reports -> Add -> New Item -> Report), table headers won’t repeat on every page by default when you print or export or print preview the report. … Continue reading

Posted in SSRS 2008 | Leave a comment

Configure all domain users to browse the SSRS Reports

Every time I had configured the SSRS folder structure and security, one common task I been configuring is adding all the domain users to the SSRS folder, data source, model, or report item. Assign the “Browser” role to the “NT AUTHORITY\Authenticated … Continue reading

Posted in SSRS 2005, SSRS 2008, SSRS 2008 R2 | Leave a comment