Jan 16, 2015 | Desktop Development, jQuery Calenders / Date Pickers, Utilities & Plug-ins
A jQuery plugin that provides support for various world calendars (localization) The current version is 2.0.0 and is available under the MIT licence. http://keith-wood.name/calendars.html Islamic Calender also available: Days and Months: Yawm al-ahad Yawm al-ithnayn... Dec 22, 2014 | Desktop Development
Background: Take some time-off and write/publish Blogs. This is going to be my first article on Linked IN, so I will try to make it concise. We know technical resources in the field of Information Technology are extensively involved in various projects and deadline... Dec 22, 2014 | Management
Employee motivation (Intrinsic motivation) can be one of the challenging tasks for an effective Manager; it needs continuous efforts and inter-personal skills in order to truly motivate your employees or a team of resources as motivation doesn’t last long.... Dec 22, 2014 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2012
The purpose of this article is to enlist recommended items that needs to be excluded from AntiVirus or AntiMalware scanning software’s on server machine where Microsoft SQL Server is installed. This can also help improve the overall SQL Server performance, these... Jun 17, 2013 | Android Development, Mobile Development
What’s Android? Android is an open source mobile operating system released under the Apache license, it in market from around 11 years now. OS is powered by Linux kernel, most of the code, libraries and API’s etc. are written in C and application software runs on... Mar 13, 2012 | Microsoft SQL Server, SQL Server 2012, TSQL
SQL Server 2012 introduces two new analytical functions FIRST_VALUE and LAST_VALUE. FIRST_VALUE returns the first value in an ordered set of values and LAST_VALUE returns the last value in an ordered set of values The syntax for these functions are: FIRST_VALUE... Mar 10, 2012 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008
There are 3 steps involved for Configuring the Transactional Replication: 1.Configuring the Distribution Database. A database which contains all the Replication commands. Whenever any DML or DDL schema changes are performed on the publisher, the corresponding commands... Mar 9, 2012 | Microsoft SQL Server, TSQL
T-SQL script to refresh all VIEWS in DATABASE. declare c cursor for select name from sysobjects where type = ‘v’ and uid = 1 open c declare @ViewName varchar(500) fetch next from c into @ViewName while @@fetch_status = 0 begin BEGIN TRY exec sp_refreshView... Mar 9, 2012 | Microsoft SQL Server, SQL Server 2005, TSQL
SQL 2005 System Objects for getting information about Transaction Locks sys.dm_tran_locks: Shows us all locks held on all resources for all transaction. We start from this view since we want to get information about locked resources. sys.partitions: Contains... Mar 9, 2012 | Microsoft SQL Server, SQL Server 2005, SQL Server 2008, TSQL
T-SQL script to enable Cross Database Chaining in Microsoft SQL Server through query analyzer: Use [MY_DATABASE_NAME] GO ALTER DATABASE [MY_DATABASE_NAME] SET DB_CHAINING ON GO EXEC sp_grantdbaccess ‘GUEST’ GO Grant CONNECT to GUEST GO Grant SELECT to... 
Recent Comments