June 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 – Migrating DTS Packages to Integration Services

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, Data Warehousing, SQL White Papers
Migrating DTS Packages to Integration Services Writer: Brian Knight Published: July 2008 SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and…
Read More

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, Database, DBA, MySQL, Oracle, SQL Documentation, SQL Download
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…
Read More