Google feedburner – The feed does not have subscriptions by email enabled

Google, Varinder Sandhu

I have faced an issue with feedburner while doing the email subscriptions; even I have signup to Feedburner and I have my feed address as http://feeds.feedburner.com/varindersandhus After that I have set up my email subscriptions on my blog. For testing email subscriptions I have subscribed with one email address then I faced error as shown below … So let me share with you how to fix this error … Login to feedburner Once you have done that click on the

» Read more

SQL Server – Collation Sequences

SQL, SQL-Advanced, Varinder Sandhu

Collation sequence control how server treats character data for storage, retrieval, and sorting and comparison operation. SQL Server 2008 allows you to specific sequence to support any language currently used around the word. Collation sequence can be specified at instance, database, table and column level. The only collation sequence that is mandatory is defined at instance level, which defaults to all other level  unless it is overridden specifically. A Collation sequence defines the character set that is supported, including case

» Read more
, , ,

SQL Server – Database Read Only

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

Here is simple script with you can set your database in Read-Only Mode Once you specify database is in read-only mode then users can read data from the database, not modify it. Here is Script : Mark Database Read Only USE [master] GO ALTER DATABASE database_name SET READ_ONLY WITH NO_WAIT Similarly you can change database Read-Only Mode to Read-Write Here is script : Mark Data Read- Write Mode USE [master] GO ALTER DATABASE database_name SET READ_WRITE WITH NO_WAIT GO Alternative

» Read more
, , , ,

SQL Server – Management Studio – Add an External Tool to the Tools Menu

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

We can launch any Microsoft Windows or Microsoft .NET Framework application from SQL Server Management Studio. External applications can be added to, and run from, the Tools menu. To add an external tool to the Tools menu On the Tools menu, click External Tools. In the Title text box, type the name you want to appear in the Menu contents list. In the Command text box, type the program name. Include the path to the executable file if necessary. In the Arguments text

» Read more
, , , ,

SQL Server – Use of Cursors

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

I have seen many different reasons and point of view on the use of cursors. Some people never used, some used at last resort and some used regularly. In each of these, they must have different reasons for their stand on cursor usage. There must have a reason or place where we can use cursors in an efficient manner. Cursors are a bad choice, unless you understand enough about them to justify their use in limited circumstances. Cursors have their

» Read more
, , , ,

SQL Server – Import CSV file to SQL table – Bulk-Insert

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

Here is an example –  Import CSV file to SQL table using Bulk-Insert CSV file means  Comma Separated Values file. USE testdb GO CREATE TABLE table1 ( id INT, name VARCHAR(255), address VARCHAR(255) ) GO Create CSV file in Shared folder on any remote location with name csv.txt Suppose location of the file is \\dcc-566\Share\CSV.txt Content of CSV file as : Now let‘s Import this CSV file into Table1. BULK INSERT table1 FROM '\\dcc-566\Share\CSV.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR

» Read more
, , , , ,

SQL Server – Comma Separated INSERT Option

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

  Here is new feature of SQL Server 2008 – “Comma Separated INSERT Option” In this feature using a single INSERT statement you can pass multiple value for the table using comma separated option. USE testdb GO CREATE TABLE table1 ( id INT IDENTITY(1,1), name VARCHAR(255), address VARCHAR(255) ) SELECT * FROM testdb..table1 INSERT INTO testdb..table1 VALUES (‘Varinder’,’ABC Street’), (‘Amit’, ‘CDE Street’), (‘Dinesh’,’XYZ Street’) Result :    

» Read more
, , , , ,

SQL Server – Insert same value multiple time in SQL table

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

  Here is an example:  Inserting same value multiple time in SQL table USE testdb GO CREATE TABLE table1 ( id INT IDENTITY(1,1), name VARCHAR(255), address VARCHAR(255) ) SELECT * FROM testdb..table1 INSERT INTO testdb..table1 VALUES (‘Varinder’,’ABC Street’) go 5 Result :  

» Read more
, , , ,

SQL Server – Understanding of Replication

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

The primary purpose of replication is to distribute data from a master database to one or more secondary databases. Because Replication maintains a duplicate copy of data in synchronization with the master copy, the technology can be used to provide availability for application. Type of Replication Snapshot Transactional Merge Snapshot Replication Snapshot Replication takes the entire set of data and sends it during the each cycle of replication. This is full copy of data that is sent by Publisher to

» Read more
, , , , , ,

SQL Server Azure

SQL, SQL-Advanced, Varinder Sandhu

Microsoft Webcast topic: “Introduction to SQL Azure (Level 100)” Sharing with brief introduction and difference between SQL Servers and SQL Azure SQL Azure is a highly available and scalable cloud database service built on SQL Server technologies. With SQL Azure, developers do not have to install, setup, and patch or manage any software. High availability and fault tolerance is built-in and no physical administration is required. Additionally, developers can get productive on SQL Azure quickly by using the same familiar

» Read more
, , , ,

MVC- Model–View–Controller

ASP.Net, MVC, Varinder Sandhu

I have attended the training session on MVC with Logiciel at Ludhiana on 3rd May 2011.  It was a good session. Session Detail: Introduction and Overview Demo Project (Lab) Question/Answer There is lot of detailed stuff available over the internet. So just sharing you very brief notes… MVC Pre-requisites Visual Web Developer 2008 Express Edition SP1 http://www.microsoft.com/express/download/ SQL Server 2008 Express Edition http://www.microsoft.com/express/sql/download/ Micorosft.NET Framework 3.5 SP1 http://msdn.microsoft.com/en-us/netframework/ Microsoft ASP.NET MVC http://www.asp.net/mvc/ MVC can be defined as an architectural pattern

» Read more
, , , ,

Migrating from Crystal Reports to SQL Server 2008 Reporting Services

Crystal Report, SQL, SQL-Reporting Services, Varinder Sandhu

I have attended the Microsoft Webcast topic: “Migrating from Crystal Reports to SQL Server 2008 Reporting Services” Here sharing with you the Key Points of this Webcast New Feature in SQL Reporting Services in SQL 2008 R2 Major Enhancement New Data visualization controls SharePoint Integration change Introduction of Reports Parts New Report Designer New Report Builder Same BIDS Designer for Report Server 2008 and 2008R2 reports Redesigned Report Manager user Interface Extended Protection network authentication settings Why Migrate from Crystal

» Read more
, , , , ,
1 … 18 19 20 21 22 … 26