Connect to Server - SQL Server Connecting Issue

I got the below issue today. I surprised by seeing this message because everything was working fine till last night. Suddenly, it was saying that permission problem, configuration issue, instance typing mismatch and so on.   

    I guess most of the people would have faced this issue. So, I want to blog this issue with solution to our new bees.

TITLE: Connect to Server

------------------------------

Cannot connect to localhost.

------------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

UHG, HYD - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Xchange, Bangalore interview Questions.

       I attended UHG Software Company’s interview in April 2012.  I have given all the questions which I faced during interview. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt !! ALL THE BEST!!

1.       What is the difference between primary key and foreign key?

2.       What is the difference between unique key and primary key?

3.       What is a stored procedure? How can you declare input parameters and output parameters?

4.       One scenario: There is an employee table. And, I am moving employee table data to employee1 table. Next, I am deleting employee table. Now, I am getting the error. How can I handle this situation?

5.       How many reports have you created till now? What type of reports have you developed?

Xchange, Bangalore - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies.
       I attended Xchange software company's interview in March 2012.  I have given all the questions which I faced during interview. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt !! ALL THE BEST!!

(1)Tell me about yourself in terms of roles and responsibilities?

(2) How to create a cube in SSAS? Explain detailed steps from creation to deployment?

(3) What is a hierarchy? How many types of hierarchies do you have in SSAS?

(4) What is a huge data migration means in your project?

(5) How did you load 1 tera byte data from source system to target system?

Print numbers from 1 to 10 using CTE

CTE stands for "Common Table Expression". A CTE is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE or DELETE statement that immediately follows the CTE.

The syntax of the CTE as follows

WITH expression_name [ ( column_name [,...n] ) ]

AS

( CTE_query_definition )

We can print the numbers by using CTE very easily.

WITH CTEName

AS

(

SELECT COUNT=1

UNION ALL

SELECT COUNT=COUNT+1

FROM CTEName where COUNT<10

)

SELECT COUNT FROM CTEName

SQL server 2008 R2 Editions

Microsoft always releases SQL server with different editions. The different editions of SQL server accommodate the unique performance, run time, price requirements of organizations and individuals.

1. SQL server 2008 R2 Data Center Edition
2. SQL Server 2008 R2 Enterprise Edition
3. SQL Server 2008 R2 Standard Edition
4. SQL Server 2008 R2 Developer Edition
5. SQL Server 2008 R2 Workgroup Edition
6. SQL Server 2008 R2 Web Edition
7. SQL Server 2008 R2 Express Edition
8. SQL Server 2008R2 Compact Edition

SqlServer History

I feel that every SQL Server professional must know about the evolution of SQL Server versions. So, I have come up with this article.

Version	year	Release Name	Code Name	Comments
1.0 (OS/2)	1989	SQL Server 1.0 (16-bit)		Microsoft, Sybase, and Aston-Tate joint venture.
1.1 (OS/2)	1991	SQL Server 1.1 (16-it)		Aston-Tate drops out of SQL Server development in 1990. Microsoft and IBM end joint development of OS/2.
4.21(WinNT)	1993	SQL Server 4.21	SQLNT
6.0	1995	SQL Server 6.0	SQL95
6.5	1996	SQL Server 6.5	Hydra
7.0	1998	SQL Server 7.0	Sphinx
	1999	SQL Server 7.0 OLAP Tools	Palato mania
8.0	2000	SQL Server 2000	Shiloh	SQL Server 2000 Service Pack 1 Released on   June 12, 2001 SQL Server 2000 Service Pack 2  Released on November 30, 2001
8.0	2003	SQL Server 2000 64-bit Edition	Liberty	SQL Server 2000 Service Pack 3 - Release date: January 17, 2003. SQL Server 2000 Service Pack 3a - Release date: May 19, 2003
9.0	2005	SQL Server 2005	Yukon
10.0	2008	SQL Server 2008	Katmai
10.25	2010	SQL Azure DB	CloudDB
10.5	2010	SQL Server 2008 R2	Kilimanjaro
11.0	2012	SQL Server 2012	Denali