Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL Authority News – Training SQL Server Query Optimization And Performance Tuning

Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Training

Earlier this year we had offered Query Optimization course and it was sold out in minutes. Due to popular demand we are offering the same course in the very first week of next year. The title of the course is ‘MS SQL Server Query Optimization And Performance Tuning‘.

This three day course is an intensive course designed to give attendees an in-depth look at the query optimization and performance tuning concepts and methods found in SQL Server. This course is designed to prepare the SQL Server developers and administrators for a transition to SQL Server while discussing best practices for a variety of topics.

Read More

SQLAuthority News – New PASS President Rushabh Mehta

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQL PASS, SQL Server, SQL User Group
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (Virtual Chapters) to webcasts and the annual PASS Community Summit – the largest gathering of SQL Server professionals in…
Read More

SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions

Pinal Dave
SQL
Business Intelligence, Data Warehousing, SQL Server

What is Business Intelligence

Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for improved decision making. To put it simply, BI is an umbrella term that refers to an assortment of software applications for analyzing an organization’s raw data for intelligent decision making for business success. BI as a discipline includes a number of related activities, including decision support, data mining, online analytical processing (OLAP), querying and reporting, statistical analysis and forecasting.

Read More

SQL SERVER – Enable Automatic Statistic Update on Database

Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Statistics

In one of the recent projects, I found out that despite putting good indexes and optimizing the query, I could not achieve an optimized performance and I still received an unoptimized response from the SQL Server. On examination, I figured out that the culprit was statistics. The database that I was trying to optimize had auto update of the statistics was disabled. Let us learn about how to Enable Automatic Statistic Update on Database.

Read More