I know this is too late to give a write up on what I learn and enjoyed at Tech-Ed 2011. Tech-Ed is one of the technical education and networking place where lots and lots of technical stuffs are running around everywhere. If you have lots of thirst on technical on Microsoft products, you can enter into any of the session and learn it.
Tag Archives: SQL Server
SQL Data Camp @ Chennai – 17th July 2010
Posted by Vidhya Sagar
on June 14, 2010
No comments
We are excited to open our mouth wide to shout "Yes, We are ready. Are you?"
SQL Data Camp @ Chennai is all set for making a claim to be First ever largest SQL Server Event to be held in India.
Resource Database – 5th System database
Posted by Vidhya Sagar
on April 17, 2009
Comments Off
In this article we are going to take a look at the 5th system databases available right from SQL Server 2005. As everyone know till SQL Server 2000 there are four system database is available and they are master, model, msdb and tempdb databases. From SQL Server 2005 Microsoft has introduced a new system database to the database engine called Resource database (actual name for this database is mssqlsystemresource ) which is hidden to the users. Read more »
Creating Linked server to MYSQL from SQL Server
Posted by Vidhya Sagar
on April 3, 2009
Comments Off
In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to MYSQL database server from SQL Server environment and then going to query data’s from MYSQL. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For creating ODBC connection we need the ODBC drivers for that RDBMS platform. In this we need drivers for MYSQL, this is not included in windows you need to download it from MYSQL Website. Lets discuss on this step by step
Testing Environment
Windows Server 2008
SQL Server 2008
MySQL Version 5.0.51
MySQL ODBC Driver 5.1
MySQL DBName : sqlarticles
ANSI_WARNINGS parameter on ISQL vs ISQLW (query analyzer)
Posted by Vidhya Sagar
on November 29, 2008
No comments
Couple of days back I saw a question on MSDN forums where a user is not getting any warnings when using isql (commandline utility) and he is getting warnings when using isqlw (query analyzer GUI) for the same query. I’m just writing this article because many of them face this problem when they do batch processing data’s through isql.
Example:
Consider you are having a table with column char(3) and if you insert a value which has 4 characters then sql client utility should throw a error. When you connect SQL Server using query analyzer, then Ansi_warnings are on by default and you will receive this error & the transaction will not happen. However if you connect SQL server using isql command line utility then you won’t get this error, instead it will truncate the last character and insert it into the table. Lets check it out! Read more »