Keep it Simple and Smart
I have seen many different reasons and point of view on the use of cursors. Some people never used, some used at last resort and some used regularly. In each of these, they must have different reasons for their stand on cursor usage. There must have a reason or place
» Read moreHere is an example – Import CSV file to SQL table using Bulk-Insert CSV file means Comma Separated Values file. USE testdb GO CREATE TABLE table1 ( id INT, name VARCHAR(255), address VARCHAR(255) ) GO Create CSV file in Shared folder on any remote location with name csv.txt Suppose location
» Read moreHere is new feature of SQL Server 2008 – “Comma Separated INSERT Option” In this feature using a single INSERT statement you can pass multiple value for the table using comma separated option. USE testdb GO CREATE TABLE table1 ( id INT IDENTITY(1,1), name VARCHAR(255), address VARCHAR(255) ) SELECT
» Read moreHere is an example: Inserting same value multiple time in SQL table USE testdb GO CREATE TABLE table1 ( id INT IDENTITY(1,1), name VARCHAR(255), address VARCHAR(255) ) SELECT * FROM testdb..table1 INSERT INTO testdb..table1 VALUES (‘Varinder’,’ABC Street’) go 5 Result :
» Read moreThe primary purpose of replication is to distribute data from a master database to one or more secondary databases. Because Replication maintains a duplicate copy of data in synchronization with the master copy, the technology can be used to provide availability for application. Type of Replication Snapshot Transactional Merge Snapshot
» Read moreMicrosoft Webcast topic: “Introduction to SQL Azure (Level 100)” Sharing with brief introduction and difference between SQL Servers and SQL Azure SQL Azure is a highly available and scalable cloud database service built on SQL Server technologies. With SQL Azure, developers do not have to install, setup, and patch or
» Read moreI have attended the training session on MVC with Logiciel at Ludhiana on 3rd May 2011. It was a good session. Session Detail: Introduction and Overview Demo Project (Lab) Question/Answer There is lot of detailed stuff available over the internet. So just sharing you very brief notes… MVC Pre-requisites Visual
» Read moreI have attended the Microsoft Webcast topic: “Migrating from Crystal Reports to SQL Server 2008 Reporting Services” Here sharing with you the Key Points of this Webcast New Feature in SQL Reporting Services in SQL 2008 R2 Major Enhancement New Data visualization controls SharePoint Integration change Introduction of Reports Parts
» Read moreI have attended the Microsoft webcast topic “Developers and Testers Working Together” It was really useful tool for tester provided by Microsoft in Visual Studio 2010. This new feature is known as “Microsoft Test Manager” so sharing with you very brief information as below: Visual Studio 2010 introduces a new
» Read moreIn today’s life we all know soft skills are very important for IT Professionals. Lot of detailed stuff is available over the internet but here sharing with you the brief key points. Soft skills are often described by using terms often associated with personality traits, such as: Social Graces Language
» Read moreVarinder Sandhu is using WP-Gravatar