During previous 5 years I have downloaded files from FTP server. Those were texts and images, that had been downloaded from FTP resources. During these 5 years its quantity became enormous – over 150 000 items in each folder. It worked automatically, that's why I hadn't paid attention to disc size and quantity of files. But once the space decreased too much.
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.
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.
(more...)
C# snippet below helps to read SQL data to List<T> generic collection without any extensions or frameworks only with SQL and LINQ.
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% CPU load, you must immediately find which process matches your application pool.
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.
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.
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.
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.
(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.
