SQLAuthority News Archives - Page 69 of 118 - SQL Authority with Pinal Dave

SQLAuthority News – Migrating to SQL Server from Other Database Products

December 19, 2009

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

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…

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

SQLAuthority News – An Year of Personal Events – A Life Outside SQL

December 14, 2009

Pinal Dave

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

Today I will keep the words very short and will convey story in three simple photographs. This post answers the question – “Do I have life outside SQL?” YES! I do and it is very beautiful. December 12, 2009 September 1, 2009 December 12, 2008 Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

December 13, 2009

Pinal Dave

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

Best Practices, SQL Index, SQL White Papers

Partitioned Table and Index Strategies Using SQL Server 2008 Writer: Ron Talmage, Solid Quality Mentors Technical Reviewer: Denny Lee, Wey Guy, Kevin Cox, Lubor Kollar, Susan Price – Microsoft Greg Low, Herbert Albert – Solid Quality Mentors When a database table grows in size to the hundreds of gigabytes or…

SQLAuthority News – Featured on Channel 9

December 12, 2009

Pinal Dave

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

Database, SQL String

This blog was featured on Channel 9 MSDN over here : TWC9: Scott Hanselman, Jon Galloway, Bing, parallel unit tests, more. I was very proud that this blog was discussed for more than 5 mins (from min 18 to min 23) on my favorite online show. Scott Hanselman, Jon Galloway…

SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman

December 7, 2009

Pinal Dave

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

Business Intelligence, Data Warehousing, SQL White Papers

An Introduction to Fast Track Data Warehouse Architectures SQL Server Technical Article Writer: Erik Veerman, Solid Quality Mentors Technical Reviewer: Mark Theissen, Scotty Moran, Val Fontama Published: February 2009 The performance and stability of any application solution—whether line of business, transactional, or business intelligence (BI)—hinges on the integration between solution…

SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008

December 6, 2009

Pinal Dave

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

Database, SQL White Papers

Consolidation Using SQL Server 2008 Writer: Allan Hirt, Megahirtz LLC (allan@sqlha.com) Technical Reviewers: Lindsey Allen, Madhan Arumugam, Ben DeBow, Sung Hsueh, Rebecca Laszlo, Claude Lorenson, Prem Mehra, Mark Pohto, Sambit Samal, and Buck Woody Published: October 2009 What are the considerations when creating a consolidation plan for my environment? What…