Blog - SQL Programmers

SQL Server Programmers Blog

SQL Server Upgrade Advisor Tool 

10/14/2014
SQL Server upgrade advisor is an upgrade tool, which assist you to identify the issues while upgrading SQL Server to the higher versions. These issues have to be fixed after or before upgrade. This tool is used to assess the available SQL... read more
 

Upgrading SQL Server 2005 to SQL Server 2012 

10/13/2014
To successfully upgrade from SQL Server 2005 to SQL Server 2012, the user should start by listing down the complexities of the application. An upgrade should be treated as a project: with proper planning and testing. Difficulties in the upgrading ... read more
 

HTML5 Introduction 

12/14/2012
HTML5 It is a new standard for HTML Cleaner markup Full fill the need of Web application Geo Location Support Client Side database It will not support old browsers. Supports only modern... read more
 

Configuration Functions in 2012 

11/21/2012
Configuration Functions in SQL server returns the current configuration setting of the SQL Server. The following are the scalar functions available in Sql Server 2012 to return the configuration settings. 1. @@DATEFIRST It will return the ... read more
 

Application State in Asp.net 

11/09/2012
Application state is a data repository used to store data on the application machine. The data is stored in the memory and can be easily retrieved. It acts as a global variable shared by multiple users or sessions. A small portion of often used... read more
 

List View and Data Pager Control in Asp.net 

11/01/2012
Paging in a website plays a vital role in web application development. The default paging supports in asp.net are Grid View and DataGrid. The page control “Datapager” was introduced in asp.net 3.5 version. Datapager will work only when the... read more
 

Report Grouping & Sorting 

10/17/2012
Reports are used to view information in a user friendly manner. The relational data refers to one-to-many relationship between records that are stored in separate tables. This relational data can be viewed easily with grouping and sorting options ... read more
 

C# Class Library 

09/12/2012
Class library is made up of a single or many files used by a programmer when developing an application program. A file in a library can have one or more classes. All the classes should be implemented with a behaviour which can be accessed to the... read more
 

C# 4.0 New Features 

09/07/2012
C# is an important language and continuously developing language of Microsoft. Each version of C# has new features included in it. This article explains the new C# 4.0 features that improves code clarity and helps to control LINQ to object... read more
 

SQL Server 2008 – HierarchyID 

08/24/2012
The HierarchyID data type is one of the new features in SQL server 2008. This data type allows storing and querying the hierarchical data easily. Hierarchical data is a set of data related to each other by hierarchical relationships. When one... read more
 
Page 1 of 10 1 2 3 4 5 6 7 8 9 10 > >>