ASP.NET SEO around VIEWSTATE

This article will bring you several SEO policies in terms of ViewState in ASP.NET.

ASP.NET SEO around VIEWSTATE

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

After reading my earlier article SQL SERVER – master Database Log File Grew Too Big, I received an email recently from another reader asking why does the log file of model database grow every day when he is not carrying out any operation in the model database. As per the email, he is absolutely sure that he is doing nothing on his model database; he had used policy management to catch any T-SQL operation in the model database and there were none.

This was indeed surprising to me. I sent a request to access to his server, which he happily agreed for and within a min, we figured out the issue. He was taking the backup of the model database every day taking the database backup every night. When I explained the same to him, he did not believe it; so I quickly wrote down the following script. The results before and after the usage of the script were very clear.

What is a model database?

The model database is used as the template for all databases created on an instance of SQL Server. Any object you create in the model database will be automatically created in subsequent user database created on the server.

NOTE: Do not run this in production environment.

During the demo, the model database was in full recovery mode and only full backup operation was performed (no log backup).

Before Backup Script

Backup Script in loop

DECLARE @FLAG INT
SET @FLAG = 1WHILE(@FLAG < 1000)BEGIN
BACKUP DATABASE [model] TO  DISK = N'D:\model.bak'SET @FLAG = @FLAG + 1ENDGOAfter Backup Script

Why did this happen?

The model database was in full recovery mode and taking full backup is logged operation. As there was no log backup and only full backup was performed on the model database, the size of the log file kept growing.

Resolution:

Change the backup mode of model database from “Full Recovery” to “Simple Recovery.”.

Take full backup of the model database “only” when you change something in the model database.

Let me know if you have encountered a situation like this? If so, how did you resolve it? It will be interesting to know about your experience.

What is jQuery Connect ? How to use jQuery Connect?

This is a jQuery plugin that is used to connect / bind a function to another function. It is more of assigning a handler for another function. Connect is used to execute a function whenever a function from another object or plugin is executed. We can connect to an event of a DOM element too using this function. In the sense same connect function can be used for both DOM elements and for the functions.

1.$.connect(refobj,refFuncName, connObj,connFunc);

This means that, when the reference function is executed, the connected function gets executed automatically after it. To understand more please analyze the following example

view source

print?

01.function A(){

02.this.fun1 = function(){

03.called1 = 'calssA-fun1';

04.}

05.}

06.var a = new A();

07.function B(){

08.this.fun2 = function(){

09.called2 = 'classB-fun1';

10.}

11.}

12.var b = new B();

13.$.connect(a,'fun1',b,fun2);

Here we connected "fun2" of object b to "fun1" of object a. When we call b.fun2, a.fun1 will also execute automatically.
This is very handy to execute some function when some other function is executed from the plug-in . In order to play with it follow these steps.

• Download jquery.connect.js file.
• Include this file in your html file.
• Take help of $.connect function as illustrated to connect a function to another function.