SQL Tips and Tricks Archives - Page 399 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Baby SQLAuthority is here!

September 1, 2009

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

September 1st, 2009 07:03:40 AM was one of the most beautiful moment of my life! God has graced us with baby girl. Nupur (my wife) and I am very happy today. We have no words to express our happiness. Baby girl and mother both are very healthy. We have yet…

SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis

August 31, 2009

Pinal Dave

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

Database, MySQL, Software Development

On 20 April 2009, Oracle Corporation announced its acquisition of Sun Microsystems in a deal worth about US$ 6 billion. This would have been just another one of corporate mega-deals that sound interesting in the news but really have no effect on your life. Except for the fact that with…

SQLAuthority News – Application and Multi-Server Management

August 30, 2009

Pinal Dave

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

Business Intelligence, Data Warehousing, SQL Documentation, SQL Download, SQL White Papers

SQL Server 2008 R2 – Application and Multi-Server Management SQL Server Technical Article Title: SQL Server 2008 R2Application and Multi-Server Management Introduction Writers: Geoff Allix Technical Reviewers: Joanne Hodgins, Omri Bahat, Morgan Oslake Published: February 2010 SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and…

SQL SERVER – Best Practices – Implementation of Database Object Schemas

August 28, 2009

Pinal Dave

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

Best Practices, SQL Download, SQL Server, SQL White Papers

SQL Server Best Practices – Implementation of Database Object Schemas
SQL Server Technical Article
Writer: Michael Redman
Technical Reviewers: Sanjay Mishra, Juergen Thomas, Jimmy May, Burzin Patel, Glenn Berry (SQL Server MVP), Prem Mehra, Lindsey Allen, Thomas Kejser, Joseph Sack, Wanda He, Sharon Bjeletich
Published: November 2008

SQL SERVER – Introduction to SQL Azure

August 27, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Cloud Computing, SQL Azure, SQL Data Storage, SQL Documentation

What is SQL Azure? In short, SQL Azure is simply a Microsoft branding change. SQL Services and SQL Data Services are now known as Microsoft SQL Azure and SQL Azure Database. There are a few changes, but fundamentally Microsoft’s plans to extend SQL server capabilities in cloud as web-based services…

SQLAuthority News – Business Intelligence Training Roadshow August September 2009

August 25, 2009

Pinal Dave

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

Business Intelligence, SQL Training, SQL User Group, SQLAuthority Author Visit

UPDATE : This is FREE training. I quite often receive request from readers and expert from all over the world if I do any training for SQL Server. Currently I am on Tour of 8 different stats of India and will be training on Business Intelligence Boot Camp. Here is…

SQL SERVER – Index Seek vs. Index Scan – Diffefence and Usage – A Simple Note

August 24, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Server

In this article we shall examine the two modes of data search and retrieval using indexes- index seek and index scan, and the differences between the two.