Memory utilization per database – SQL Server

I am trying to find the memory utilization per database(using dmvs) in a sql server instance, ie (Buffer Cache + Procedure Cache) over a period of time. I have the query to get the buffer cache utilization, what i require is procedure cache, plus any other parameter that a database will use in terms of memory.

SELECT DB_NAME(database_id) AS [Database Name],
COUNT(*) * 8/1024.0 AS [Cached Size (MB)]
FROM sys.dm_os_buffer_descriptors
WHERE database_id > 4 -- system databases
AND database_id <> 32767 -- ResourceDB
GROUP BY DB_NAME(database_id)    
ORDER BY [Cached Size (MB)] DESC OPTION (RECOMPILE);

40 Free High-Quality Web Button PSD Downloads

This collection of downloadable PSD freebies of web buttons features calls to action buttons, social media buttons, download buttons and other GUI buttons from top-notch websites and designers. Using PSDs made by these talented and generous designers can help you speed up the completion of your projects. You can also download, experiment and study the files to learn new UI design techniques.

http://designinstruct.com/roundups/free-web-button-psd-downloads/

Web Service Security for Windows Phone

Windows Phone
December 15, 2011

Windows Phone applications have the ability to exchange data with computers all over the world. However, the more valuable the data is – for example, if it is financial data or personal information – the more important it is to make sure that your application requests and receives data using security procedures that reflect the value of that data. This topic describes several different ways to help secure Windows Phone applications when they make calls to web services.

The three major areas that are described are:

  • Authentication
  • Encryption of communication
  • Prompting for usernames and passwords

http://msdn.microsoft.com/en-us/library/gg521147(v=vs.92).aspx

Log IP Address Of Contact Form Reply

http://forums.appthemes.com/log-ip-address-contact-form-reply-7649/page-2/

reCaptcha on the contact form of single-page ads

To prevent issues with SPAM on contact form page ad only made a few changes in the files “sidebar-contact.php” and “style.css” to replace the captcha fully employed by reCAPTCHA…

http://forums.appthemes.com/recaptcha-contact-form-single-page-ads-15208/

How to change icon of a “Batch File” or convert it to “exe”

Just like bakuryu suggested download Batch To Exe Converter 1.3.3 from here . It is a small, free and powerful tool.

W3C CSS3 working draft: The ‘overflow-x’ and ‘overflow-y’ properties.

http://www.brunildo.org/test/Overflowxy2.html

Calling Server Side Method Using jQuery/Ajax

With this post I would show how to call server side method from client side. Here we will use jQuery to utilize the Ajax Capabilities which will help us to get/post data to/from server Asynchronously. There are many methods available to perform an async callback to the server. Here I will show a simple example as in how to call a code behind Webmethod.

http://weblogs.asp.net/karan/archive/2010/09/12/calling-server-side-method-using-jquery-ajax.aspx

Any way to disable Google Map in new version 3.1?

You can disable Google Map editing the file sidebar-ad.php

Go to WordPress admin => Appearance => Editor
Select the file sidebar-ad.php

Early on in the code you will find several in this line:

$ gmap_active = true;

Change the “true” to “false”

It has to look like this:

CSS3 Spinning Icons and toggle-button

CSS3 Spinning Icons

http://inspectelement.com/demos/css3/iconspin/

 

 

CSS3 toggle-button

http://lab.simurai.com/css/toggle/#box