Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
PowerPivot, SQL Download, SQL White Papers
I was recently working at customer location on PowerPivot project. It was quite complected as this is relatively new technology and we all are exploring what this technology can do and what it can bring to us on table in real life experience. During this implementation the project design document…
Read More

SQLAuthority News – SQL Server 2008 Add-ins and Feature Pack Downloads

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Utility
Here are few of the latest Microsoft Add-ins and downloads recently announced. SQL Server Reporting Services Add-in for SharePoint Technologies The Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of…
Read More

SQL SERVER – Microsoft SQL Server 2008 Service Pack 2 Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download
Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. You can download your preferred version from link here. The major enhancements are as following: 15K partitioning Improvement. Reporting Services in SharePoint Integrated Mode. SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.…
Read More

SQL SERVER – SSRS 2008 R2 – MapGallery – World Map

Pinal Dave
SQLAuthority News
SQL Documentation, SQL Download, SQL Spatial

SQL Server 2008 R2 has negatively integrated ability to work with maps. There are few ways how one can select map and use them in their projects. The one I recently came across was MapGallery. By default SQL Server 2008 R2 is enabled for USA maps. This is quite a common request from developers around the globe that they want the same feature available in their own country.

Read More

SQL SERVER – 2008 R2 – PowerPivot for Microsoft Excel 2010 – RTM

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
PowerPivot, SQL Documentation, SQL Download
PowerPivot Microsoft PowerPivot for Microsoft Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft SharePoint 2010. I have recently started to work with SQL Server 2008 R2 and…
Read More

SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, SQL Documentation, SQL Download
I had previously written article on SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial. Microsoft has come up with white paper regarding same Best Practice Analyzer. In the new R2 version the SQL BPA introduces advanced capabilities in conjunction with the PowerShell architecture and also raises the…
Read More

SQLAuthority News – Download – SQL Server Monitoring Management Pack

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…
Read More