Menu

Posts tagged "SQL Server"

What are the Limitations of SQL Server Express Edition ?

Microsoft SQL Server comes in different versions that includes
  • SQL Server Enterprise
  • SQL Server Business Intelligence
  • SQL Server Standard
  • SQL Server Web
  • SQL Server Express
I have been using SQL Server Express 2012 for quite some time . What are the limitations of SQL Server Express compared to the other versions of SQL Server ? In Read More →

How to Export the Query Result to .csv file in SQL Server?

Here's another tip where you could export the query result to .csv file in SQL Server.

How to Export the Query Result to .csv file in SQL Server?

Follow the below steps to export the query result in SQL Server to .csv file. 1. Open SQL Server Management Studio 2. Click the button "New Read More →

How to escape single quote in SQL Server?

Today, when I was trying to insert a value to a table in SQL Server which had single quotes, I ended by getting the following error.

Unclosed quotation mark after the character string
The query looked like this INSERT INTO COUNTRIES (NAME) VALUES ('Test's')

How to escape a single Read More →

How to query the version number and other information related to SQL Server ?

Sometimes, you might want to query the  SQL Server version to know its exact version number and other information like Platform, Product Name etc. Here's a simple stored procedure in SQL Server that helps to retrieve not just the SQL Server version but also additional information about the SQL Server.
/* Read More →           

How to Create a Database Backup in SQL Server using SQL Scripts?

You can create a Database Backup in SQL Server easily by using the SQL Scripts. Just specify the BACKUP DATABASE statement by simply specifying the name of the database to backup and the path where the backup should be created. BACKUP DATABASE <database name> TO BACKUPDEVICE <Path> WITH <Options> The BACKUPDEVICE specifies the Read More →

How to take Database Backup in SQL Server 2008 R2?

It might be important to take the back of the SQL Server database regularly and store them in a secure place which will help you to recover or restore data in case of natural disaster or any other issues. In this blog post, I will demonstrate a step by step process Read More →

Difference between DELETE and TRUNCATE command in SQL Server

Below are few points that differentiate the DELETE and TRUNCATE command.
Sl. No.

Read More →

Difference between Primary Key and Unique Key

By default, primary key creates clustered index on the column and then enforces the uniqueness of the column whereas the unique key, by default creates a non-clustered index. Primary Key
  • By default, creates Clustered index
  • Doesn't allow null
  • Table can have only one Primary Key ( Can include multiple columns together Read More →

Which port number does SQL Server run on?

Which port number does SQL Server run on?

By default, Microsoft SQL Server runs on port 1433. If you want to change the TCP/IP port for SQL Server, you can modify it via SQL Server Configuration Manager -> SQL Native Client Configuration -> Client Protocols -> TCP/IP Properties.

Read More →

Fix for IntelliSense feature in SQL Server Management Studio 2008 R2 may stop working after you install Visual Studio 2010 SP1

Today , i encountered a wiered thing in my SQL Server Management Studio 2008 R2 where the intellisense was somehow not working in SSMS 2008 R2 :( . I had only SQL Server 2008 R2 Express installed on my machine and had recently installed the Microsoft Visual Studio 2010 Service Pack Read More →

Open DBDiff for SQL Server 2008

Last few weeks , i have been playing around with this cool tool called Open DBDiff . As the name suggests Open DBDiff tool lets you compare the database schema for SQL Server 2005 or SQL Server 2008  . Its a simple and effectve tool for database schema comparision . Open DBDiff Read More →

Event – Reliving TechEd India 2012 with Vinod

Here's a User Group meet with the combined efforts of BDotNet and BITPro on some interesting topics to be presented by Vinod. The event is titled as "Reliving TechEd India 2012 with Vinod" will be held on April 7, 2012 from 10.30 am to 1.30 pm at Microsoft, Krishna Hall, Embassy Read More →

Joomla 2.5 with Microsoft SQL Server support

The new version of Joomla 2.5 was released this week that includes new features like extension updates and multi-database support of Microsoft SQL Server.

What is Joomla?

Joomla is an open source Content Management System (CMS) that enables the users to create websites or online applications. The earlier versions of Joomla Read More →

Download Lightbox Gallery Module for DotNetNuke

The Lightbox Gallery Module for DotnetNuke is released and is now available for Download from the Codeplex site.

The current version of Lightbox Gallery Module for DotnetNuke is 01.09.00 and includes numerous features and bug Read More →

Download Visual Studio 11 Application Lifecycle Management Virtual Machine

Brain Keller in his blog announces the availability of the Visual Studio 11 Developer Preview ALM Virtual Machine . As per Brain Keller's Blog , the virtual machine is configured with:
  • Microsoft Windows Server 2008 R2 Standard Edition
  • Microsoft SQL Server 2008 R2
  • Microsoft Visual Studio 11 Ultimate Developer Preview
  • Microsoft Team Foundation Server Read More →

How to reset the value of identity Column in SQL Server ?

Here's a way to reset the value of the identity column in SQL Server . The scenario is explained below . For example , when the table "Customers" has a identity column with the initial value of 1 and seed 1 .Each time when you start an App and perform Read More →

Microsoft TechEd 2011 – India Agenda Announced

You might be aware that the Microsoft TechEd 2011 is happening in Bangalore from March 23-25 , 2011 .

Just few weeks back , the Agenda was included / updated . I was late in seeing that in the Microsoft TechEd website :( . The Developer tracks include Read More →

© 2011-2013 Senthil Kumar's Blog This is my personal blog .The opinions expressed here represent my own and not those of my employer . All Rights Reserved -- Copyright notice by Blog Copyright

Protected by Copyscape Duplicate Content Detection Software