Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Saturday, June 13, 2015

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 herechinnilax

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

Monday, May 7, 2012

MySQL on Windows ( Webinar Series)



Join us for a series of live webinars that will explore different aspects of using MySQL on Windows. With experience gained by working with MySQL customers such as TicketMaster, Adobe, and iStockphoto, this webinar series will give you information on everything from where and how to get started to best practices for building new or migrating existing applications to MySQL on Windows.
MySQL for Online Apps Webinar Series
Whether you are already using MySQL or considering a new project, register today to learn how you can make the best use of MySQL on the Windows platform. Convenient sessions provided for EMEA and North American time zone for most of the series. Register now!

Part 1: Getting Started with MySQL on Windows

In the first installment of our series, we'll cover the benefits of deploying MySQL on Windows. You will learn the basic "How-To's" of installation, security and configuration and how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the new Query Analyzer.
North America: On Demand Replay now available. Register now »


Part 2: MySQL for the SQL Server DBA

In our next installment of the series, you will get an overview of MySQL's internal architecture including storage engines, security and datatypes. Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access. This webinar is ideal for SQL Server DBAs interested in learning how to leverage current knowledge against MySQL.
North America: On Demand Replay now available. Register now »


Part 3: Building MySQL on Windows

Join us for Part 3 of the Windows and MySQL webinar series with Iggy Galarza, Software Engineer and Jimmy Guerrero, Sr Product Manager from Sun Microsystems. In this presentation we'll demonstrate how to setup an environment for building MySQL on Windows from source. While not strictly necessary, installing and running the Windows build system in a virtual machine allows for a single source repository to be shared among multiple flavors of Windows and/or other operating systems. We will focus on using only free or open source tools in the build environment, specifically we'll be using: VMWare Server, Microsoft Visual Studio Express 2005, Microsoft Windows Platform SDK, KitWare CMake, GNUWin32 Bison and Red Hat CygWin. If you are interested in learning how to build MySQL on Windows, this webinar is for you.
North America: On Demand Replay now available. Register now »


Part 4: Migrating from Access to MySQL

In this webinar we will explore the benefits of migrating Microsoft Access data to MySQL including migration best practices, migration tools, scripts and datatype mapping. Finally, we will demonstrate how to leverage Access front-ends with a MySQL-backend.
North America: On Demand Replay now available. Register now »


Part 5: Migrating from SQL Server to MySQL

In Part 5 we will explore the benefits of migrating from Microsoft SQL Server to MySQL. We will cover migration best practices, migration tools, scripts, datatype mapping and functional equivalents.
North America: On Demand Replay now available. Register now »


Part 6: Windows Server Failover Clustering with MySQL

In our final webinar in series this year, we will explore the benefits of leveraging Microsoft Windows 2008 Server Failover Clustering with MySQL. We will also cover installing and configuring Failover Clustering and best practices concerning MySQL storage engine selection and behaviors with Failover Clustering.
North America: On Demand Replay now available. Register now »


Part 7: MySQL Cluster on Windows

As we continue our series into 2010, we will explore the benefits of leveraging MySQL Cluster on Windows and cover step by step, how to get started with installing, configuring, and running MySQL Cluster on Windows.
North America: On Demand Replay now available Register now »

Part 8: Developing Windows Applications with MySQL

Join this webinar to learn the benefits of developing Windows applications with MySQL including best practices for development with Visual Studio and how to get the most from the latest version MySQL Connector/Net.
North America: On Demand Replay now available Register now »

Part 9: Working with Spreadsheets and MySQL

In this presentation we will explore the benefits of leveraging MySQL in conjunction with your existing spreadsheet program to include importing and exporting data from Microsoft Excel or OpenOffice Calc to MySQL.
North America: Presentation Slides now available Register now »

Part 10: Running MySQL Securely on Windows

Join us as we demonstrate how to install and configure MySQL to run securely on Windows. We'll also cover how MySQL's internal security model, authentication and privileges model works.
North America: On Demand Replay now available Register now »

Source from the Link mysql.com

Wednesday, December 28, 2011

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

Wednesday, October 7, 2009

connect to an instance of Microsoft SQL Server 2005 from a remote computer


When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message. This problem may occur when you use any program to connect to SQL Server. For example, you receive the following error message when you use the SQLCMD utility to connect to SQL Server:
Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
This problem may occur when SQL Server 2005 is not configured to accept remote connections. By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps:
Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.
This article describes how to complete each of these steps.
Back to the top

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition       
You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:                                              
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and
then click SQL Server Surface Area Configuration.                                                      
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services
and Connections. On the Surface Area Configuration for Services and Connections page,         
expand Database Engine, click Remote Connections, click Local and remote connections,
click the appropriate protocol to enable for your environment, and then click Apply.
------------------------------------------------------------------------------------------------------------Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Back to the top
Enable the SQL Server Browser service
-------------------------------------------------
If you are running SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, SQL Server 2005 Express is installed with a default instance name of Computer Name\SQLEXPRESS. You are only required to enable the SQL Server Browser service one time, regardless of how many instances of SQL Server 2005 you are running. To enable the SQL Server Browser service, follow these steps.

Important These steps may increase your security risk. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses. We recommend the process that this article describes to enable programs to operate as they are designed to, or to implement specific program capabilities. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this process in your particular environment. If you choose to implement this process, take any appropriate additional steps to help protect your system. We recommend that you use this process only if you really require this process.
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply.

Note When you click the Automatic option, the SQL Server Browser service starts automatically every time that you start Microsoft Windows.
Click Start, and then click OK.
Note When you run the SQL Server Browser service on a computer, the computer displays the instance names and the connection information for each instance of SQL Server that is running on the computer. This risk can be reduced by not enabling the SQL Server Browser service and by connecting to the instance of SQL Server directly through an assigned TCP port. Connecting directly to an instance of SQL Server through a TCP port is beyond the scope of this article. For more information about the SQL Server Browser server and connecting to an instance of SQL Server, see the following topics in SQL Server Books Online:
SQL Server Browser Service
Connecting to the SQL Server Database Engine
Client Network Configuration
Back to the top
===============================================================
Create exceptions in Windows Firewall
--------------------------------------------------
These steps apply to the version of Windows Firewall that is included in Windows XP Service Pack 2 (SP2) and in Windows Server 2003. If you are using a different firewall system, see your firewall documentation for more information.

If you are running a firewall on the computer that is running SQL Server 2005, external connections to SQL Server 2005 will be blocked unless SQL Server 2005 and the SQL Server Browser service can communicate through the firewall. You must create an exception for each instance of SQL Server 2005 that you want to accept remote connections and an exception for the SQL Server Browser service.

SQL Server 2005 uses an instance ID as part of the path when you install its program files. To create an exception for each instance of SQL Server, you must identify the correct instance ID. To obtain an instance ID, follow these steps:
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Configuration Manager.
In SQL Server Configuration Manager, click the SQL Server Browser service in the right pane, right-click the instance name in the main window, and then click Properties.
On the SQL Server Browser Properties page, click the Advanced tab, locate the instance ID in the property list, and then click OK.
To open Windows Firewall, click Start, click Run, type firewall.cpl, and then click OK.
Create an exception for SQL Server 2005 in Windows Firewall
----------------------------------------------------------------------------------
To create an exception for SQL Server 2005 in Windows Firewall, follow these steps:
In Windows Firewall, click the Exceptions tab, and then click Add Program.
In the Add a Program window, click Browse.
Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program, click Open, and then click OK.

Note The path may be different depending on where SQL Server 2005 is installed. MSSQL.1 is a placeholder for the instance ID that you obtained in step 3 of the previous procedure.
Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs an exception.
Create an exception for the SQL Server Browser service in Windows Firewall
To create an exception for the SQL Server Browser service in Windows Firewall, follow these steps:
In Windows Firewall, click the Exceptions tab, and then click Add Program.
In the Add a Program window, click Browse.
Click the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe executable program, click Open, and then click OK.

Note The path may be different depending on where SQL Server 2005 is installed.