Accessing ASP.NET session variables with JavaScript

This seems to be common questions that have been asked and the answer is it is not possible directly. But with the help of AJAX it is possible as following article describes.

http://irahuldev.blogspot.com/2012/06/how-set-and-get-aspnet-session.html

Cheers
Samitha

Asp.net DropDownList with Custom Paging

When we developing with Asp.net DropDownList, one of the most common issue faced is when there are too many records filled in the control, the control goes up as you select the DropDownList. This is the default behavior of the DropDownList and one of the solution for this is to have DropDownList with Custom Paging. I found this article explaining how to implement a Asp.net DropDownList with Custom Paging.

Cheers

Samitha

Microsoft SQL Server 2012 SP1

Download SQL Server 2012 SP1 from here

Cheers

Samitha

SQL Server 2012 Error handling

Check out this article on error handling in SQL Server 2012

http://www.simple-talk.com/sql/database-administration/handling-errors-in-sql-server-2012/

Cheers
Samitha

Developing a SQL Server Backup Strategy

As a DBA it is important that you have developed a proper backup strategy. Following article describes concepts to consider when developing a backup strategy.

http://www.databasejournal.com/features/mssql/developing-a-sql-server-backup-strategy.html

Cheers
samitha

Unable to read the project file 'project.' The Web Application Project proj1 is configured to use IIS

If you ever com up with the error "Unable to read the project file 'project.' The Web Application Project proj1 is configured to use IIS"  edit the .csproj with notepad and change this line :

<WebProjectProperties>
          <UseIIS>True</UseIIS>

To :
<WebProjectProperties>
          <UseIIS>False</UseIIS>

Cheers
Samitha

SQL Server convert string to datetime

If you have used any of the fields in a table as a varchar to store date when querying the table will not return the expected result.
E.g
SELECT * from ISSUES where CREATED_DATE
  between '08/16/2012' AND '01/27/2013
Here CREATED_DATE field has been defined as string. To resolve this you;ll have to use SQL's convert funciton as follows
SELECT * from ISSUES where CONVERT(datetime,CREATED_DATE,120)
  between '08/16/2012' AND '01/27/2013'

For more date time formatting options check link below
http://msdn.microsoft.com/en-us/library/ms187928.aspx

Cheers
Samitha