Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – ORDER BY Clause and TOP WITH TIES

December 23, 2009

Recently, on this blog, I published an article on SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY; this article was very well received because of the observation made in it. One of the comments suggested the workaround was to use clause WITH TIES along with TOP…

SQLAuthority News – Meeting SQL Expert Imran at Hyderabad

December 22, 2009

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA

I was very fortunate to meet the SQL Server Expert and one of the top participants of this blog Imran Mohammed. Imran has been very active on this blog and have previously contributed with few articles as well. I have been communicating with Imran for a long time; he is…

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2

December 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL String, SQL XML

In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that…

SQLAuthority News – Migrating DTS Packages to Integration Services

December 20, 2009

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…

SQLAuthority News – Migrating to SQL Server from Other Database Products

December 19, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

MySQL, Oracle, SQL White Papers

Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL Server 2008 This white…

SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

December 18, 2009

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.…

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

December 17, 2009

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,”…