To create a full backup of MS SQL Server database with compression use this SQL command: use YourDataBaseName go BACKUP DATABASE YourDataBaseName TO DISK = 'Z:\BACKUP_FILE_NAME.bak' WITH COMPRESSION According to database size and your server capabilities, backup time can vary. Read more»
Application logs can stop your machine if you do not control their size. By default, webserver IIS doesn’t clean IIS logs and stores them in c:\inetpub\logs. If your server is high loaded, logs of IIS can get critical size in 2-3 weeks. Read more»
C# snippet below helps to read SQL data to List<T> generic collection without any extensions or frameworks only with SQL and LINQ. Read more»
Application pool allows you to isolate your applications from one another in case if they are running on the same server. According to this, if there are errors in one application, they will not influence other web applications executing on the same server or the IIS server itself. But if your w3wp process has 100% […] Read more»
There’s a table in html page and you need to get the quantity of it’s rows. It’s easy to get it with jQuery. Read more»
In Linux OS (Debian, Ubuntu, CentOs) log files of web server can grow and grow. According to web server activity, they can grow to a very big size. To remove files is a bad solution because they won’t be restored and you loose new logs. Read more»
Для того, чтобы определить, является ли значение переменной числом или нет, можно использовать встроенную функцию isNaN(). Название isNaN означает «is Not a Number». Соответственно, функция возвращает обратное значение от того, число это или нет, т. е. если значение переменной число, то функция вернет false (ложь), а если не число, то true (истину). Read more»
The syntax of jQuery code how to retrieve radio button items in cycle. For example, you have radio buttons with names, first you need to get them to array. For this case I will do it manually. Read more»
You can easily copy files from one directory to another. You can easily create cmd-file with the command XCOPY and it’s keys and make copies of files. Read more»
I’m trying to remove all permissions from a list item in SharePoint 2010. There was a lot of permissions because of the “Limited access”. I couldn’t check all items because of the constraint of maximum selected items. This script is 100% compatible with SharePoint 2013 and SharePoint 2016. Read more»
