Search

Tutorials, tips&tricks, snippets..

#KISS: KEEP IT SIMPLE, STUPID!

Author

preruz

Round button in HTML5 with CSS3

Quick snippet below: how to create round button in HTML5 with CSS3.
Continue reading “Round button in HTML5 with CSS3”

Advertisements

Where can I find the IIS logs?

Where does IIS7 store logs by default? Here:

%SystemDrive%\inetpub\logs\LogFiles

JavaScript: add month to Date object

Here two simple snippets useful to add (or subtract) months to a Date object:
 

function add_months(dt, n) 
{
    return new Date(dt.setMonth(dt.getMonth() + n));      
}

dt = new Date();
console.log(add_months(dt, 10).toString());  

You can also create it as prototype, if you prefer:

Date.prototype.add_months = function(w){

var date = this;
date.setMonth( date.getMonth()+10 );

return date;

};

var date = new Date();
console.log( date.add_months(10).toString() );

Using European VAT Verification SOAP Service

EU created a service to obtain confirmation of the validity of the VAT identification number of any specified person. This service works with SOAP and can validate all the EU VAT. You just need to send the state code and the VAT.

Continue reading “Using European VAT Verification SOAP Service”

How to fix Recovery Pending State in SQL Server Database

This problem happened to me after I killed the connections PID to one of my databases. The single user mode was removed, but I wasn’t able to use the database, since it was in the Recovery Pending mode. How to fix this problem?

Continue reading “How to fix Recovery Pending State in SQL Server Database”

SQL Server: exit single-user mode

My database was in Single User mode. I don’t know how it entered in this mode, but this causes a lot of problem with the database itself. For example, trying to expand the database, you get an error:

The database ‘my_db’ is not accessible.(ObjectExplorer)

Also, when trying to delete it, you get:

Changes to the state or options of database ‘my_db’ cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

How to fix this?

Continue reading “SQL Server: exit single-user mode”

Sql Server “Saving changes is not permitted”

When you create a table in SQL Server and save it, sometimes, if you try to edit the table design you get this error:

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can’t be recreated or enabled the option prevent saving changes that require the table to be re-created.

This can happen also if the table is a new empty table, never used.
Continue reading “Sql Server “Saving changes is not permitted””

Create a class from XSD file (and avoid signature error)

It happens to have a XSD file, for example to communicate with an exisisting web service.
I have to create a class (in this case, C# language) starting from a XSD file provived from server side. How to do it?

Continue reading “Create a class from XSD file (and avoid signature error)”

How to create a WCF from WSDL (and prevent errors)

Sometimes you need to create a WCF service starting from a WSDL giving to you the specifications. It is a good practice and quite simple to do.

Continue reading “How to create a WCF from WSDL (and prevent errors)”

Powered by WordPress.com.

Up ↑