Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Scripts, SQL White Papers
SQL Server 2008 Full-Text Search: Internals and Enhancements SQL Server Technical Article Writer: Fernando Azpeitia Lopez, Microsoft Corp. Published: July 2008 Database systems must go beyond the traditional realm of relational data by covering an increasing amount and variety of unstructured and semistructured information, be it speech, documents, XML, bioinformatics,…
Read More

SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CDC, SQL Error Messages, SQL Scripts, SQLAuthority Author Visit
Few days ago, I got the great opportunity to visit Bangalore Infosys. Please read the complete details for the event here: SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore. I mentioned during the session that CDC is asynchronous and it reads the log file to populate its data.…
Read More
All Articles MSQOPT1-600x400

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

SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation logo-sql08.gif SQL Server Technical Article Writers: Mark Theissen, Eric Kraemer Published: February 2009 To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,”…
Read More