SQL Server code name ‘Denali’ – Community Technology Preview 3 (CTP 3)

SQL, SQL-Advanced, SQL-General, SQL-Server 2011, Varinder Sandhu

Microsoft 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 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

» Read more
, , ,

SQL Server – Reset auto number (IDENTITY) column in SQL Server

SQL, SQL-Advanced, SQL-General, SQL-Query, SQL-Scripts, Varinder Sandhu

How 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) column in SQL Server using DBCC CHECKIDENT command. Following example shows how to reset auto number (IDENTITY) column the IDENTITY column Hope this post helps you.

» Read more
, ,

XAMPP Installation Steps

Others, Varinder Sandhu

XAMPP 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 Server MySQL PHP Perl Officially, XAMPP’s designers intended it for use only as a development tool, to allow website designers and programmers to test their work on their own computers

» Read more
, , , , ,

SQL Serevr Replication – Setup and configure Subscription on SQL 2008R2 – Part 4 of 4

SQL, SQL-Advanced, SQL-General, SQL-Replication, Varinder Sandhu

New 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 Synchronization” Select option “Create the subscription” Wait for the subscription process to finish. Finally subscriber has been created. Reference URL http://varindersandhu.in/2011/08/12/sql-server-how-to-setup-sql-server-replication/

» Read more
, , , , , ,

SQL Serever Replication – Setup and configure the Publication on SQL Server 2000 – Part 3 of 4

SQL, SQL-Advanced, SQL-General, SQL-Replication, Varinder Sandhu

In 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 your database and press “Next” In the “Select Publication Type” screen select “Transactional publication” (second option) en press “Next” On the “Specify Articles” Screen check all the checkboxes on the

» Read more
, , , , , ,

SQL Server Replication – Setup and configure a SQL Server 2000 as a main Publisher/Distributor – Part 2 of 4

SQL, SQL-Advanced, SQL-General, SQL-Replication, Varinder Sandhu

Click 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 tree for this server in SQL Server Enterprise Manager Close this screen and the following SQL Server properties screen. Now you can see the Publisher in SQL Server Enterprise Manager

» Read more
, , , , , ,

SQL Server Replication – Configure the SQL Server Agent – Part 1 of 4

SQL, SQL-Advanced, SQL-General, SQL-Replication, Varinder Sandhu

Once 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 System account, but for SQL Server Replication to work this must be changed to a specific created user account that has all the necessary rights to run as a service.

» Read more
, , , , , ,

SQL Server – How to Setup SQL Server Replication – Part 0 of 4

SQL, SQL-Advanced, SQL-General, SQL-Replication, Varinder Sandhu

Introduction 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 2000 SQL Server 2008R2 This document describes below points Configure the SQL Server Agent Setup and configure a SQL Server 2000 as a main Publisher/Distributor Setup and configure the Publication

» Read more
, , , , , ,

ASP.Net – Web Browser’s Role

.Net Framework, ASP.Net, Varinder Sandhu

Role 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 was made with HTTPS, the web browser uses the certificate to authenticate the server and then decrypt future communications. Process the response. If the server has provided HTML, the browser

» Read more
, , , ,

ASP.Net – Web Server’s Role

.Net Framework, ASP.Net, Varinder Sandhu

The web server provides the content and the web browser displays it to the user. At the simplest, a web server sends static files, such as static HTML or image files, through an HTTP connection to a web browser. Modern web servers do far more, however. When a web server receives a request, some of the actions it takes are to: Verify that the request is structured legitimately. Sometimes, malicious clients send malformed web requests to compromise web servers. Web

» Read more
, , , ,

Office 2007 – How to create watermarks in Word 2007

MS Office, Varinder Sandhu

Watermarks are used to print text or a graphic behind document text. Watermarks are transparent, and therefore any text or inserted object printed over a watermark is clearly visible. So, here will see how we can place watermarks on our Word documents in MS Word 2007? Start Word Go to Page Layout Menu Click the Watermark command in the Page Background group It shows a window with different watermark templates as: Confidential, Do Not Copy, Draft, Sample, Urgent, ASAP etc.

» Read more
,

SQL Server – Location of Installation Log file

SQL, SQL-Advanced, SQL-General, SQL-Tips and Tricks, Varinder Sandhu

A few times we were trying to locate the installation log file folder if we faced any issue or problem while installation of SQL Server. Basically, we want to know reason of issue or problem. So location of Log file folder as below SQL Server 2008 and 2008 R2 %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\ SQL Server 2005 %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\ You can find the Summary.txt file in above mentioned location. This file shows the SQL Server components that were detected during

» Read more
, ,
1 … 15 16 17 18 19 … 26