An IT Solution

Cross database query Sql Azure Azure cross database query performance sql azure select from another database reference to database and/or server name in is not supported in this version of sql server. All the above statements are reference to the issue we face while shifting data from Sql Server to Azure Database. While using Sql Server (Any version) we can reference any database with in Sql server according to user rights assigned to user. We can use statements like "select * from db1.dbo.customers" But now in Sql Azure the system and terminology has changed. Now, azure has new concept of External Tables  and sp_execute_remote  in introduced. Now we need to know the who is who in Azure. External Tables = "Is for Select" sp_execute_remote="Execute External Store Procedures" Before proceeding. Please create 2 azure databases as per your choice. Here I am naming them as. DbCustomers and DbPayments  and keep a reference to them ...

 Normal code generated by MySql:- CREATE TABLE `categorymaster` (   ` CategoryID ` int(11) NOT NULL AUTO_INCREMENT,   ` Category ` varchar(200) DEFAULT NULL,   `IsActiv` int(11) DEFAULT NULL,   `ImagePath` varchar(200) DEFAULT NULL,   `DisplayOrder` int(11) DEFAULT NULL,   PRIMARY KEY (` Category `) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; In the above data stucture I want to make the " Category " as Primary Key and " CategoryId " as Auto Increment. But Table Wizard always give errors so, I decided to write my own Statement. Following is the statement which will create perfect structure according to my requirement. DROP TABLE `dbname`.`categorymaster`; CREATE TABLE `categorymaster` (   `CategoryId` int(11) unsigned NOT NULL AUTO_INCREMENT,   `Category` varchar(200) DEFAULT NULL,   `IsActiv` int(11) DEFAULT NULL,   `ImagePath` varchar(200) DEFAULT NULL,   `DisplayOrder` in...

How to create User Login in Sql Server 2005/2008 Note - You must be a member of "system admin" to create a new user or database. Following is the steps to create user login in database for database level security :- Step 1 . Open Sql Server >> Enter User Name >> Enter Password >> Click Connect Step 2 . Open Security >> Logins >> Right Click >> New Login Step 3. Enter login name >> Select Radio button "Sql Server Authentication" >>Enter password>>Enter confirm password>> Un-Check Enforce password policy >> Click Ok Step 4. Right click on Databases >> Click new database Step 5. Enter Database name>> Owner "<default>" >> Click Ok Step 6 . Open Newly created database (My Case it is Test)>> Security>> Users>> Right click on dbo >> New users. Step 7. Enter user name>> Login name >> default schema...

Task - Expose Sel Server to Internet or Remote Access via IP OS - Windows Server 2008 R2 Sql Version - Sql Server 2008 R2 To expose the server to internet we need open port for sql server (default port is 1433) To open a port in the Windows firewall for TCP access 1. On the Start menu, click Run, type WF.msc, and then click OK. 2 . In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane (upper right corner). 3. In the Rule Type dialog box, select Port, and then click Next. 4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, In my case we are using the default which is 1433. Click Next. 5. In the Action dialog box, select Allow the connection, and then click Next. 6. In the Profile dialog box, I am going to Leave Domain turned on and turn private and public off. Then click Next. 7. In the Name d...

Generally the cause of Server Application Unavailable is the .net framework. Error Snapshot For ex. one of our site is in version 1.1 and the recently added site is in 2.0 or later or any other different versions running on the IIS. How to Resolve:- We need to create a new application pool on the IIS and assign the same to the version of the site. Following image illustrates how to check the version of site. For ex. Pool3_5 for version 3.5 and  Pool4_0 version 4.0 . Following image illustrates how to create new Pool. Step 1: Step 2: Step 3:  You can also verify the IIS logs to locate the issue.

While setting up an new Web server with Windows Server 2003 and IIS 6. I have to set up my own custom domain (for ex. myname.com) as the default site on IIS. Means if I will run the server from IP my custom domain has to run. The process is so, easy we need to setup few things in custom site. Right click on Site>>Properties>>WebSite>>Click on Advnaced Button>>Leave the "Host header value" to be blank. Please refer the image..