Skip to main content

Posts

SQL Server Transaction per interval

If you are wondering how much SQL transaction is happening on your database, run the below query. DECLARE @First INT DECLARE @Second INT SELECT @First = cntr_value FROM sys.dm_os_performance_counters WHERE OBJECT_NAME = 'SQLServer:Databases' -- Change name of your server AND counter_name = '%Transactions/sec%' AND instance_name = '_Total'; -- Database name -- delay time WAITFOR DELAY '00:00:01' SELECT @Second = cntr_value FROM sys.dm_os_performance_counters WHERE OBJECT_NAME = 'SQLServer:Databases' -- Change name of your server AND counter_name = '%Transactions/sec%' AND instance_name = '_Total'; -- Database name SELECT (@Second - @First) 'TotalTransactions' GO If you are having some problem in execution, please confirm the OBJECT_NAME and instance_name by running select * FROM sys.dm_os_performance_counters . You can change the WAITFOR DELAY time to meet your time interval requirement. I have used curren...

Postal Code for Bhutan

To know your postal code, go to this link -> http://www.bhutanpost.com.bt/postcode/postcode.php . Postcode is a code of digits added to postal address to facilitate mail delivery. Each country has its own coding system and in some countries it is referred to as Zip Code. Bhutan Post has 5-numeric digits code that indicates the following: 1. The first digit indicates the Region . 2. The second digit indicates the Dzongkhag 3. The third digit indicates the Dungkhag under a Dzongkhag 4. The last two digits indicate the delivery area, i.e, General Post Office (GPO)/Post Office (POs),Community Mail Office (CMOs)

Zimbra Mail Error: not enough free space in mail queue

If you are using Zimbra Mail and you are not able to send any mails and also you see an Error Message " not enough free space in mail queue " under /var/log/message. Then you should try out this solution. 1. Login to the server, and then again login as zimbra as follows: #su - zimbra 2. Check the Postfix message_size_limit, by default it should be 10MB (i.e. '10240000' bytes) as follows: $postconf message_size_limit message_size_limit = 10240000 3. If the value is higher than that, set it as follows to 10MB $ zmprov modifyConfig zimbraMtaMaxMessageSize 10240000 $ postfix reload Now try sending Mail, It should work. You could try out this solution for Error: " SMTP Server Reported: 452 4.3.1 Insufficient System Storage "

Remove unwanted widget from wordpress dashboard

Edit the function.php file as follows and make available only ones that you need them to be displayed on your dashboard. function remove_dashboard_widgets() { //Plugins - Popular, New and Recently updated WordPress Plugins remove_meta_box('dashboard_plugins', 'dashboard', 'normal'); //Wordpress Development Blog Feed remove_meta_box('dashboard_primary', 'dashboard', 'side'); //Other WordPress News Feed remove_meta_box('dashboard_secondary', 'dashboard', 'side'); //Right Now - Comments, Posts, Pages at a glance remove_meta_box('dashboard_right_now', 'dashboard', 'normal'); //Recent Comments remove_meta_box('dashboard_recent_comments', 'dashboard', 'normal'); //Incoming Links remove_meta_box('dashboard_incoming_links', 'dashboard', 'normal'); //Quick Press Form remove_meta_box('dashboard_quick_press', 'dashboard', ...

Windows 8 God Mode

You can access GodMode on Windows 8, similar to Windows 7. GodMode is actually a folder which would contain all computer setting panels. 1. Create one new folder on your desktop 2. Rename the folder by pasting the following string and click Enter. GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Microsoft Security Essential scan alert everyday

You get an orange icon alert on Microsoft Security Essential, stating " I hadn't done a scan for a while and my computer may be at risk. " even when you have done the computer scan. Such alert is shown if you are running CCleaner everyday. CCleaner is actually removing MSE history file which MSE checks to determine the last time a scan was conducted. In case you don't want to receive such alert, you can prevent ccleaner from deleting the MS Antimalware scanning file. How to prevent CCleaner from deleting MS Antimalware history file. 1. Open CCleaner 2. Under Cleaner > Applications tab > Windows 3. Uncheck MS AntiMalware