Aug 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
Data Warehousing, SQL Documentation, SQL Download
I was recently working on learning various new stuff. I just would like to share very interesting resources here today. Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from any other data platform to SQL Server 2005, SQL Server…
Read More

SQLAuthority News – Download – Microsoft SQL Server Compact 4.0

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download
Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix,…
Read More

SQLAuthority News – Download Whitepaper – Enabling and Securing Data Entry with Analysis Services Writeback

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation, SQL Download, SQL White Papers
SQL Server Analysis Service have many features which are commonly requested and many already exists in the system. Security Data Entry is very important feature and SSAS supports writeback feature.  Analysis Services is a tool for aggregating information and providing business users with the ability to analyze and support decision…
Read More

SQLAuthority News – Whitepaper Download – Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download
Size of the database is growing every day. Many organizations now a days have more than TB of the Data in their system. Performance is always part of the issue. Microsoft is really paying attention to the same and also focusing on improving performance for Data Warehousing. Microsoft has recently…
Read More

SQLAuthority News – Best Practices for Data Warehousing with SQL Server 2008 R2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Data Warehousing, SQL Documentation, SQL Download
An integral part of any BI system is the data warehouse—a central repository of data that is regularly refreshed from the source systems. The new data is transferred at regular intervals  by extract, transform, and load (ETL) processes. This whitepaper talks about what are best practices for Data Warehousing. This…
Read More

SQLAuthority News – Download SQL Server 2008 R2 Upgrade Technical Reference Guide

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download
I recently come across very interesting white paper written for Microsoft by Solid Quality Mentors. A successful upgrade to SQL Server 2008 R2 should be smooth and trouble-free. To do that smooth transition, you must plan sufficiently for the upgrade and match the complexity of your database application. Otherwise, you…
Read More