Thursday, July 31, 2008

Mod Mount&blade Native Extension

truncate the log file of a Microsoft SQL database

With SQL 2000 always ran into the problem of the automatic log file size of the database, it defaults to the LDF file grows in size continuously until it reaches the maximum size set in the database, or worse, up to end of disk space.

This situation is created simply because the LDF file keeps track of all transactions, even when properly committed.

To resolve this problem, simply run the command: DBCC

BACKUP LOG [database name] WITH TRUNCATE_ONLY

simple, immediate, and above all, decisive.

via: merlinox.tumblr.com

Thursday, July 17, 2008

What Is The White Mucus In My Urine

Quick Restart services

developing batch applications that perform tasks in a Microsoft environment, one is invariably working with windows services.

With this type of programs the way they work is slightly different, and so no longer able to launch applications with the development environment, it is more often confronted with the awkward interface for managing services.

Well, well the end is not uncomfortable, but working with and debugging these applications there is a stop and start hundreds of times a day.

order to stop and then start the services with a single click, you can easily create a. Bat with these 3 lines of code:

NET STOP "service name"

pause net start "service name"


The pause between the two commands is essential, because operationally it will launch this command, the service is stopped as soon as you can compile the executable, and a completed build with a single shipment in the DOS window open, you can restart the service.

Comfortable, convenient and quick ...

Tuesday, July 15, 2008

How To Replace Cigarette Lighter Receptical

SandBox, a protected environment to perform software

Some time ago, downloading a software from the network while I've just updated the virus infected my pc with an unpleasant troian.Da then, in addition to solving the problem of anti-virus, I started to run into a suspicious file secure environment. I always just one click away from a virtual machine and start if necessary, once checked and tested the software I use on the real machine.
A few days ago I discovered a much more practical.

software Sandboxie fact is responsible for running a particular software you choose, in a "black box" by not allowing the process you direct access to writing the disc.
Image http://www.sandboxie.com/

Much more practical than a slow virtual machine, and altogether effective.

Thursday, July 10, 2008

Electronic Stratego Buy

My PC has a black hole!!

I looked at my PC and I found the following items ...

- Browse the entire network
- My Bluetooth
- Research new hardware
-
Empty Recycle Bin - Delete Temporary Internet files ...
...

these things have in common?
Well ... no matter how powerful your PC is, how many processors are available or how much RAM is installed, use these components will make the PC unusable for a short period, often arbitrary ...

Well ... have access to a hole black for the performance ...

Friday, February 15, 2008

Broken Capilary Urethra

Issue an alert following a postback

Programming web applications we often find ourselves in a position of wanting to communicate something to the user in a clear manner, drawing attention to a particular condition, or an error.

on Windows Forms Using messagebox the classic, comfortable, full of options and very practical.

ASP.NET pages instead we issue the javascript code to display an js alert with the message of the case.

then I wrote a handy function in the web pages that is very similar to the following: public void
 
MessageBoxScriptInject (string messageToShow)

{/ / I give him comatose with javascript ... String =
messageTranslated
messageToShow.Replace ("'", "\\ \\ '");
messareTranslated
messareTranslated.Replace = ("\\ n", "");
messareTranslated
messareTranslated.Replace = ("\\ r", "");

/ / Create the javascript

System.Text.StringBuilder js = new System.Text.StringBuilder ();
js.AppendLine (
window.alert ('"+
messareTranslated +"'); ");

/ / injected code in the page (syntax. NET 2.0)
this.ClientScript.RegisterStartupScript (
typeof (string),
Guid.NewGuid (). ToString (),
js.ToString (),
true);}

Friday, February 8, 2008

Mount And Blade 1.003trainer

Reindex an entire database on SQL server

Those who work on applications running on SQL Server database is large enough to identify early on that application is one of the critical time "spent" to access the database and that the response time of each query can change substantially if the indexes are created carefully.

After creating the DB and the indices, they tend to deteriorate with time, losing performance during logon.

A practical way to restore the performance of the indices is run on each database, perhaps as a schedule of nightlife, a script like this:

 
use Database;
GO exec
sp_msforeachtable 'dbcc DBREINDEX ("?") with NO_INFOMSGS';
GO