SQLAuthority Wishes Happy Diwali to All of You. Diwali is one of the important Hindu festivals, which comprises of four consecutive days of celebrations.
SQLAuthority News – Download Microsoft SQL Server 2008 Feature Pack, October 2008
Note: Download Microsoft SQL Server 2008 Feature Pack, October 2008 by Microsoft
SQLAuthority News – Definition – Outsourcing, Offshoring, Nearshoring, Offshore Outsourcing
Outsourcing – Outsourcing is subcontracting a process, such as product design or manufacturing, to a third-party company. Outsourcing involves the transfer of the management and/or day-to-day execution of an entire business function to an external service provider.
SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis
Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any…
Read More
SQLAuthority News – TOP Downloads – Bookmark
Recently I have gotten many, many requests for SQL Server Interview Questions and Answers as well as related articles. It seems many people are looking for Job or appearing for an interview at this time of the year. I have included lists of the my top downloads in the sidebar of the blog, still I receive many curious questions as side bar does not show up in the RSS feed.
Author Visit – MVP Open Day 2008 – Goa – November 15-17
I will be attending MVP Open Day 2008 in Goa from November 15 to November 17. I am eagerly waiting to attend the Open Day. If you are in Goa during that time we can meet sometime in evening after sessions are over. Following is the comics related to MVP Open Day 2008.
SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations…
Read More