Keep it Simple and Smart
PARSE() and TRY_PARSE() are new conversion function introduced in SQL Server Denali. TRY_PARSE() tries to translate the result of an expression to specified data type if the translation is possible, otherwise, it returns NULL. PARSE() tries to translate the result of an expression to specified data type if the translation
» Read moreMicrosoft SQL Server code name ‘Denali’ enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence. SQL Server code name ‘Denali’ enables a cloud-ready
» Read moreHow to reset auto number (IDENTITY) column in SQL Server? Sometimes we need to reset the auto number – identity column in a table. Using the DELETE statement is not enough. The statement only deletes the data but not reset the identity column. We can reset the auto number (IDENTITY)
» Read moreXAMPP is a free and open source cross-platform web server solution stack package, consisting mainly of the Apache HTTP Server, MySQL database, and interpreters for scripts written in the PHP and Perl programming languages. XAMPP’s name is an acronym for: X (to be read as “cross”, meaning cross-platform) Apache HTTP
» Read moreNew Subscription wizard as below Select the publication and then press “Next” Next you have choose the subscriber and subscription database Here we are choosing the Push subscription Select Push subscription (First one) then press “Next” Select Agent Schedule “Run Continuously” the press “Next” Select Initialize when as “At first
» Read moreIn part 2, we have configured a SQL Server as a main publishing server, we have to create a publication of databases which the clients can subscribe. Click on New Publication “Create Publication Wizard” starts, check the “Show advanced options in this Wizard” checkbox and press “Next” After please select
» Read moreClick on the Configuring Publishing, subscribes and Distribution option then the Configuring Publishing and Distribution Wizard starts up. Specify the UNC (Universal Naming Convention) path Select “No”- accepting default settings – and press next. Successfully enabled…” message should appear. Notification that a “replication object” has been added to the console
» Read moreOnce you are going setup SQL Server Replication configures the SQL Server Agent as: Make Sure SQL Server Agent is running Right click My Computer -> Manage… -> Choose from the tree at the left: “Services and Applications” -> “Services” By default the SQL Server Agent runs under the local
» Read moreIntroduction This document describes a scenario how to setup the Transactional SQL Server Replication. Before we proceed for Replication setup you can read brief note about “Understanding of Replication” http://varindersandhu.in/2011/05/14/understanding-of-replication/ Here we will setup the Transactional SQL Server Replication between SQL Server 2000 and SQL Server 2008R2. Pre-requisite SQL Server
» Read moreRole of Web Browser’s Send requests to the web server. If the user enters http://www.microsoft.com, the web browser resolves the www.microsoft.com Domain Name System (DNS) address, uses HTTP to connect to the server, and requests a page. Authenticate the server. If the server has an SSL certificate and the request
» Read moreVarinder Sandhu is using WP-Gravatar