SQL Server Interview Questions and Answers : For All Database Developers and Database Administrators

Paper Book Available at

USA: Amazon

India: Flipkart | IndiaPlaza

Sample Chapters

eBook Download from here: chinnilax

Introduction

Today we are using computers for various activities, motor vehicles for traveling to places, and mobile phones for conversation. How many of us can claim the invention of micro-processor, a basic wheel, or the telegraph? Similarly, this book was not written overnight. The journey of this book goes many years back with many individuals to be thanked for.

To begin with, we want to thank all those interviewers who reject interviewees by saying they need to know ‘the key things’ regardless of having high grades in class. The whole concept of interview questions and answers revolves around knowing those ‘key things’.

Oracle VM VirtualBox 4.1.8 Download links for all Operating systems

Oracle VM VirtualBox

VirtualBox is powerful Cross-platform Virtualization Software for x86-based systems.
"Cross-platform" means that it installs on Windows, Linux, Mac OS X and Solaris x86 computers. And "Virtualization Software" means that you can create and run multiple Virtual Machines, running different operating systems, on the same computer at the same time. For example, you can run Windows and Linux on your Mac, run Linux and Solaris on your Windows PC, or run Windows on you Linux systems.

Oracle VM VirtualBox is available as Open Source or pre-built Binaries for Windows, Linux, Mac OS X and Solaris.

Oracle VM VirtualBox

The latest release is version 4.1.8.

On this page you can download:

• Oracle VM VirtualBox
• Oracle VM VirtualBox Extension Pack
• Oracle VM VirtualBox Source Code
• Oracle VM VirtualBox Pre-built Appliances

---

Oracle VM VirtualBox

Freely available for Windows, Mac OS X, Linux and Solaris x-86 platforms:

Platform	File
Windows (32-bit/64-bit)	VirtualBox-4.1.8-75467-Win.exe
Mac OS X	VirtualBox-4.1.8-75467-OSX.dmg
Solaris 10 5/08 and later (32-bit/64-bit)	VirtualBox-4.1.8-75467-SunOS.tar.gz
Linux 32-bit Platforms

Download YouTube video in Chrome without software

In Online you can get many of Software's or Tools to Downlaod YouTube Videos, But beware from Malware & Spyware which are also Pre Installed from your Downloaded softwares.

Here we are helping you to Download the same YouTube Videos to download with out using any software.

Tips Provided Buy :  Dealdimer.com

Follow the following steps :-

1) Go to Savefrom.net

2) Now find out the link Savefrom.net helper

3) Now click on Add to Chrome button

4) You will get a file called helper_last.crx, now bring it to the Desktop

5) Now go to Chrome =>  Tool  =>   Extensions

6) Drag and drop the file helper_last.crx, to the Extensions page and press the pop up Add button.

Thats all, Now you can Downlaod Youtube videos from this new Crome extension.

You must have one of the following Media Players & Internet Browsers installed on your computers

Media Players

You must have one of the following streaming media players and versions installed on your computer: Flash Webcasts Standard Webcasts • Flash Player 10.x • Silverlight 2 or 3 (Internet Explorer or Firefox) • Microsoft Windows Player 10, 11, or 12 (Internet Explorer) • Real Player 10 or SP (Windows) • Real Player 10 or 11 (Mac) Click on the icon below to download the appropriate media player(s) for your event.

Internet Browsers

Flash Webcasts Standard Webcasts • Internet Explorer 6+ • Mozilla Firefox 3+ • Safari 4.x • Google Chrome 10+ • Internet Explorer 6+ • Mozilla Firefox 3+ To determine the version installed on your computer, complete the following steps: Open the browser. Click the Help menu. Click About. You can download a newer version of each browser by clicking on the icons below.

Download Offline install files of Instant Messengers

Downloading instant messenger on an erratic internet connection can be real test of your patience. First you need to download small file that will start the online install process of instant messenger.

Well, there is work around and you can download the full offline direct file of your favorite instant messenger. Checkout following links and bookmark them for future full offline direct install file download:

• Yahoo Messenger 9 Full Offline installer (final version).
• Yahoo Messenger for Vista Offline installer (discontinued).
• Google Talk installer (by default its direct download file).
• Windows Live Messenger 9 (Direct download via softpedia).

Above links should come handy for direct download of your favorite Instant Messenger? Did we miss anything? Give a shout by adding a comment!

Microsoft latest Download release links (win2008,Hyper-V,Service Pack,SQL,Win7,Office,AD,System center and many more)

Windows Server 2008 Service Packs

Windows Server 2008 x86	SP1 Built-in	SP2 Download
Windows Server 2008 x64	SP1 Built-in	SP2 Download
Windows Server 2008 ia64	SP1 Built-in	SP2 Download

   Some Latest Updated Microsoft Downloads   

Convert MS Outlook Contacts to vCard File

vCard Export Software is designed to convert MS Outlook contacts to vCard, MS Excel and Outlook Express Address Book. vCard Export provides a complete solution to export Outlook Contacts.

Software Features

• Converts MS Outlook Contacts to MS Excel file.
• Converts MS Outlook Contacts to vCard file (compatible with many email clients).
• Converts MS Outlook Contacts to WAB file.
• Converts Ansi Format (MS Outlook 2000/2002/XP), Unicode Format ( MS Outlook 2003/2007) to vCard, WAB & Excel File.
• Do not require any special skills.
• Software run successfully with MS Office 2007. SysTools vCard Export.
  

While using vCard Export to convert Outlook contacts, You must have the following installed on your PC:

• Configured profile of MS Outlook 2007/2003/2002/XP/2000.

 Download Here    Link1       Link2  

 Also share the link in your facebook or twitter 

A Portable Antivirus Software from Microsoft

Is your computer infected with a virus that is preventing you from downloading security updates from the Internet or from running any antivirus program on that machine? Or are your looking for an antivirus software that can be carried on a USB drive to quickly scan any disconnected computer(s) for viruses or malware?

You should check out Microsoft Safety Scanner. This is a free antivirus software, always updated with the latest definitions, and requires no installation - all you need to do is copy the program executable msert.exe to an infected computer and double-click that file. If it detects a problem, the infected files will be quarantined.

You may either do a thorough scan - check every file and folder - or a quick scan that checks a limited number of folders that are most likely to contain viruses, malware or spyware.

Microsoft Safety Scanner is available as a free download for both 32-bit and 64-bit version of Windows. You may use on Windows XP, Vista or Windows 7 machines and, unlike Microsoft’s other antivirus software, Safety Scanner doesn’t perform a check for genuine Windows.

The program expires after 10 days but you can always re-download it with the updated virus definitions. It won’t however scan your Outlook emails or your network drives for any possible infections.

A very simple free download manager by Microsoft

The Microsoft Download Manager enables you to download files simply and easily. It also makes downloading large files such as application and multimedia files quick and reliable.

File Name                                Size
MSDownloadManager.msi     1.3 MB         DOWNLOAD 

The Microsoft Download Manager enables you to download files simply and easily. It also makes downloading large files such as application and multimedia files quick and reliable. It was specifically designed to help users manage file downloads from supporting Microsoft Web sites. Once started, the Microsoft Download Manager’s easy-to-use interface displays the status of downloads and enables you to suspend active downloads or resume downloads that have failed.

System requirements

Supported Operating Systems: Windows 7, Windows Server 2008 R2, Windows Vista Service Pack 2, Windows XP Service Pack 3

The Microsoft Download Manager has specific system requirements in order for it to operate normally. See below for a list of Operating System and Web browser requirements. The Microsoft Download Manager requires one of the following operating systems: Windows© XP with Service Pack 3 Windows Vista© with Service Pack 2 Windows 7 Windows Server© 2008 R2 The Microsoft Download Manager supports the following Web browsers: Windows© Internet Explorer© 6 Internet Explorer 7 Internet Explorer 8 Internet Explorer 9 Mozilla© Firefox© 3.6

TuneUp Utilities makes Windows faster (Download)

Get the brand-new TuneUp Utilities™ 2012!

The Most Powerful TuneUp Utilities of All Time!

• Boosts PC speed by up to 50%, all thanks to Program Deactivator™ 2012
• Extends battery life with an all-new TuneUp Economy Mode
• Saves power by up to 30% and upgrades PCs with an enhanced power management
• over 30 tools in 1: more speed, better stability, less problems
TuneUp Utilities makes Windows faster, more secure, and comfortable. All important aspects of system configuration, security, cleaning and maintenance are combined under a modern graphical user interface.

Download TuneUp Utilities™ 2012

 OR  Download : Here                                                                      

        Download : Here

ACDSee Photo Editor 2008 Download

Award winning and in 5th Place on all Photo editor Software's in 2011.

Pros 

The help and support options associated with this program are great.

Cons 
This program is average in every area other than help and support.

The Verdict

      Download from Here  

If you want average photo editing software, we recommend this program.

Make the most of your photos with ACDSee Photo Editor 2008! It has all the tools, inspiration and clear instruction you need to turn your digital photos into truly captivating keepsakes. Create personalized greeting cards, scrapbook pages, invitations and more. With Photo Editor's easy to use artistic text, layout and editing features, you'll be amazed at what you can do with your photos.

Get Started Right Away

You don’t have to be a technical whiz to create beautiful layouts and gorgeous keepsakes. How-to lessons walk you through common tasks, with detailed and easy-to-follow steps. Antique a photo, apply a vignette, and create dazzling projects with ease. Spend less time guessing, and more time being creative with your photos.

NEW! If you need that extra boost of inspiration to get you started, Photo Editor comes packed with templates by top digital designers Andrea Gold, Maggie Lamarre and Vicki Stegall. You'll be on the fast track to creativity!

The ultimate tool for SQL developer productivity!

The ultimate tool for SQL developer productivity!

SoftTree SQL Assistant 6.0 
for Oracle, SQL Server, DB2, Sybase, MS Access, PostgreSQL, and MySQL

SQL Assistant easily integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It provides assistance with code typing, automatic word completion and database object and attributes browsing.

It provides functions for quick entry of common SQL constructs and code snippets. It also provides integrated and fully interactive SQL code assistance system for instant help with SQL command syntax and options available in specific database versions, code syntax checker, spell checker and a number of other vital coding tools.

A database application that can be used with both very small and very large database systems.

Here are some key features of "SoftTree SQL Assistant":

· Doubles SQL developer productivity.
· Improves code quality and accuracy.
· Provides advanced SQL code intellisense features, including support for databases, objects, parameters, script variables, syntax elements.
· Provides interactive SQL reference and SQL code assistance systems.
· Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation.
· Provides integrated real-time code syntax and spell checker
· Supports 8 major database systems: Oracle, SQL Server, DB2, MySQL, PostgreSQL, Sybase ASE, Sybase ASA, MS Access, and their SQL dialects.
· Integrates with many SQL and non-SQL editors .
· Fast and has small disk and memory footprint .
· Can be easily installed without interrupting any existing processes and used immediately.

Requirements:

· Oracle 8i, 9i, 10g, 11g
· Microsoft SQL Server 2000, 2005, 2008
· DB2 UDB 7, 8, 9, 9.5
· DB2 UDB for iSeries
· MySQL 5.x
· Sybase ASE 12.x, 15.x
· Sybase ASA 7, 8, 9, 10
· PostgreSQL 8.x
· Microsoft Access 2003, 2007
· 12.5 MB disk space
· 128 MB RAM
· CPU Pentium or compatible

Limitations:

· 14 days trial But Download From here for Full Ver Download  or Download or Download  

What's New in This Release: [ read full changelog ]

New Features and Major Changes:
· New Schedule feature for scheduling runs of SQL code on single and multiple database systems using sequential and concurrent parallel runs.
· Completely rebuilt and greatly enhanced Database Code Refactoring engine now supporting the following smart-refactoring methods: Rename Table or View; Rename Table or View Column; Rename Procedure or Function; Rename Procedure or Function Parameter; Rename Local Variable; Add Table Column; Drop Table Column; Add Procedure or Function Parameter; Drop Procedure or Function Parameter; Drop Procedure or Function; Drop Table or View; Extract View; Extract Procedure; Qualify Object Names.
· Database refactoring coverage expanded from 3 to 8 different database system types.
· Lots of enhancements in database refactoring methods, including updating Oracle synonyms when renaming based objects; column renaming in 'return table' in table functions in SQL Server, and many others.
· Code formatter and beautifier now support...

Download WaveMaker 6.4 @ VMWARE Product

WaveMaker is a visual development tool that lets everyone quickly build and deploy great-looking web and cloud applications. With WaveMaker, you can build a complete, 3-tier web application in minutes!

	Mac (Intel Only)
	Windows
	Linux DEB Package, 32-bit (Debian/Ubuntu)
	Linux DEB Package, 64-bit (Debian/Ubuntu)
	Linux RPM Package, All (RedHat/CentOS)

All users of the Select editor should check their restrictValues property after upgrade

The Select editor property "restrictValues" determines whether entering a value that does NOT appear in the menu is invalid. If restrictValues is true, then only values from the list are valid. If its false, then the menu is just a list of suggested values, but the user can type in anything. This incorrectly defaulted to false. We've changed the default to true. Please check your projects and verify that the restrictValue settings are correct for your editors.

IE 6 and IE 7 are no longer supported except via Chrome Frame

A new application-level property has been added called "promptChromeFrame" which has three possible values:

• chromeframe.html: IE 6/7 users will be shown the contents of chromeframe.html which will be in your project/webapproot folder, and which initially contains links to various ways of upgrading to a supported browser. You can edit this file to show anything you want.
• http://google.com/chromeframe: This immediately shows google's chromeframe download page
• Allow IE 6 and 7 users: This option will allow users to run the application without requiring a chromeframe plugin or a modern browser. Use this at your own risk.

While WaveMaker applications can be run using IE 6 and 7, there are a number of bugs, and we no longer are working to support these browsers and fix these bugs.

Infrastructure

OSX requires JDK6

OSX installations of Studio now require JDK6. To ensure you are using Java6, use the Java Preferences application to specify the default JDK prior to starting Studio.

New Deployment Dialog

The deployment dialog has been rewritten. Besides being easier to use, it now provides the following new features

1. Deploy to CloudFoundry's cloud (you must first create an account at cloudfoundry.com)
2. You can now change your database settings before deploying. When you generate your WAR/EAR file and deploy it to your target server, you can change from using your development database to your production, QA, demo, or other database connection settings.
3. Save your deployment settings so that once you've deployed with a specific set of settings, redeploying to the same target server and same target databases is a one click operation.

CloudFoundry Notes

Restrictions in support for other domains
The current version of CloudFoundry deployment lets you choose what cloudfoundry environment to deploy to, cloudfoundry.com, or a privately hosted version. Studio does not support switching back and forth between different cloudfoundry environments at this time. Users wishing to change the deployment domain musts clear browser cookies, or user a separate browser for each domain.

The list of currently deployed CloudFoundry apps only lists apps on cloudfoundry.com, and does not at this time show apps deployed elsewhere.

Experimental new print methods

A print() method has been added to 6.4 for all controls. You can call this.layoutBox1.print() or this.dojoGrid1.print() or print on any panel. This is a very experimental feature but is the easiest way to get basic printing working. For more information, reviewhttp://dev.wavemaker.com/wiki/bin/wmdoc_6.4/Printing#HExperimentalnewprintmethods

For more details find the link Here

Windows Server 2008 R2 Evaluation Virtual Hard Drive Images for Hyper-V (180 Days)

Files in this download

The links in this section correspond to files available for this download. Download the files appropriate for you.

Windows Server 2008 R2 Enterprise Evaluation (Full Edition).exe
1.0 GB DOWNLOAD

Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part01.exe
500.0 MB DOWNLOAD

Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part02.rar
500.0 MB DOWNLOAD

Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part03.rar
500.0 MB DOWNLOAD

Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part04.rar
500.0 MB DOWNLOAD

Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part05.rar
37.0 MB DOWNLOAD

Windows Server 2008 R2 Enterprise Evaluation (Server Core).exe 

706.0 MB DOWNLOAD

Overview

The Microsoft VHD format is the common virtualization file format for Hyper-V that provides a uniform product support system, and provides more seamless manageability, security, reliability and cost-efficiency for customers.

This VHD release is available in English only and is for evaluation and testing purposes. Evaluating any version of Windows Server 2008 R2 software does not require entering a product key, however will require activation within 10 days. Failing to activate the evaluation will cause the licensing service to shut the machine down every hour (The 10 day activation period can be reset four (4) times by using the rearm command. See below for further information on activation rearm). Once activated, the evaluation will run for 180 days. After this time, you will need to uninstall the evaluation software and reinstall a fully-licensed version of Windows Server 2008 R2.

As this installation requires Hyper-V, you will need to have a base install of Windows Server 2008 (64-bit edition) or Windows Server 2008 R2, running Hyper-V. For more information on obtaining and installing the latest version of Hyper-V, please visit the Hyper-V Homepage.

Both virtual machines available here are running Windows Server 2008 R2 Enterprise Edition Evaluation. One is the default full installation, and the other has been configured as a default Core installation. For more information on the difference between full and core installation please see the Windows Server 2008 Editions Overview pages. For download options please see the IMAGE SELECTION section in the instructions below.

As both virtual machines do not have anti-virus installed, they should not be connected to any network until it has anti-virus installed.

System requirements

Supported Operating Systems: Windows Server 2008 R2

Required Software: Windows Sever 2008 or Windows Server 2008 R2 installed with Hyper-V*
Processor: 2.0 GHz or faster (x64) Hardware Assisted Virtulization Required
Disk Space: At least 10.0 GB of free disk space
RAM: 2.5 GB of available physical RAM**

*The VM images themselves are 64bit images and as such you will need to determine 32bit application compatibility for the applications you may wish to install.

* *The amount of physical RAM depends on what applications are running on the Server. You can use the Task Manager to identify how much physical RAM is available on your machine. Running applications other than Hyper-V will consume available physical RAM.

Instructions

Using the Windows Server 2008 R2 VHD with Hyper-V

1. On your computer, install Windows Server 2008 or Windows Server 2008 R2 and Microsoft Hyper-V. Detailed instructions on how to install the latest version of Microsoft Hyper-V can be found here: http://www.microsoft.com/windowsserver2008/virtualization/install.mspx
2. Download the files required. There are 2 different images (Windows Server 200 R2 Enterprise Full Installation and Windows Server R2 Enterprise Server Core Installation), and 2 ways to download them based on your current internet connection – see IMAGE SELECTION section below for further information.
3. When you have installed Hyper-V and extracted the VHD files, copy the VHD file to a pre-selected location (recommended default location C:\Users\Public\Documents\Microsoft Hyper-V\Virtual Hard Disks)
4. Open Hyper-V Manager. Click Start, point to Administrative Tools, and then click Hyper-V Manager.
5. From the Action pane, click New, and then click Virtual Machine.
6. From the New Virtual Machine Wizard, click Next.
7. On the Specify Name and Location page, specify what you want to name the virtual machine and where you want to store it. (you can keep this as default location for ease).
8. On the Memory page, specify enough memory to run the guest operating system you want to use on the virtual machine (Recommendation at least 2Gb).
9. On the Networking page, connect the network adapter to an existing virtual network if you want to establish network connectivity at this point.
10. On the Connect Virtual Hard Disk page, select “Use and existing virtual hard disk”, and browse to the location you copied the VHD file to in step 3 above.
11. Select finish (you can also start the VHD at this time, however we recommend you create a snapshot before you start the VHD for the first time).
12. To logon to the machine, use the following credentials:
• Username: administrator, password: Pass@word1 (Administrator account)

IMAGE SELECTION

To make is easier to download the VHD images, we have created 2 different ways to download the files. You have the choice of downloading the entire compressed files as one image, or as a multi-part archive (All images are self-extracting archives). Below is the session legend (you can also download these files by right-clicking on them and saving them to your system).

Windows Server 2008 R2 Enterprise Evaluation (Full Edition)

Single Image

1. Windows Server 2008 R2 RC Enterprise Evaluation (Full Edition)

Multi-part Image

1. Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part01.exe
2. Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part02.rar
3. Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part03.rar
4. Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part04.rar
5. Windows Server 2008 R2 Enterprise Evaluation (Full Edition).part05.rar

Windows Server 2008 R2 Enterprise Evaluation (Server Core)

Single Image Only

1. Windows Server 2008 R2 Enterprise Evaluation (Server Core).exe

Additional information

Please refer to the documents below for further information

Installing Windows Server 2008 R2

Windows Server 2008 R2 Release Notes

How to manually rearm the 10 day activation grace period
When the initial 10-day activation period nears its end, you can run the Slmgr.vbs script to reset it back to 10 days. To do this, follow these steps:

1. Click Start, and then click Command Prompt.

2. Type slmgr.vbs -dli, and then press ENTER to check the current status of your activation period.

3. To reset the activation period, type slmgr.vbs –rearm, and then press ENTER.

4. Restart the computer.

This resets the activation period to 10 days, and can be used up to four times. After this you will need to either activate or reinstall