June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL White Papers
One of the many features of Microsoft SQL Server PowerPivot is the range of data sources that can be used to import data. Anything, from Microsoft SQL Server relational databases, Oracle databases, and Microsoft Access databases, to text documents, can be used as data sources in PowerPivot. In this paper,…
Read More

SQL SERVER – Solution – Puzzle – Statistics are not Updated but are Created Once

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Statistics
Earlier I asked puzzle why statistics are not updated. Read the complete details over here: Statistics are not Updated but are Created Once In the question I have demonstrated even though statistics should have been updated after lots of insert in the table are not updated.(Read the details SQL SERVER –…
Read More

SQL SERVER – Watch Online and Download – Inside of Next Generation SQL Server – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download
I presented on subject Inside of Next Generation SQL Server – Denali online at Zeollar.com. This sessions are really fun as they are online, downloadable, and 100% demo oriented. I used SQL Server ‘Denali’ CTP 1 to present on the subject of What is New in Denali. My earlier session…
Read More