How to enable HTTP Compression of Static and Dynamic Contents IIS

Enabling compression of static and dynamic contents of your website will be more help to load your website faster on browsers.

To enabling both you must have to install “Dynamic Compression” and “Static Compression” on the server features and roles.

Open server manager
Roles > Web Server (IIS)
Role Services (scroll down) > Add Role Services
Add desired role (Web Server > Performance > Dynamic Content Compression & Static Content Compression)
Next, Install, Wait for couple of seconds…Done!

To Enable it:
Open your web.config and add the following configuration in webServer tag.

<system.webServer>
<urlCompression doStaticCompression="true" doDynamicCompression="true" dynamicCompressionBeforeCache="true"/>
<httpCompression noCompressionForHttp10="false" noCompressionForProxies="false" dynamicCompressionDisableCpuUsage="93" dynamicCompressionEnableCpuUsage="93" staticCompressionDisableCpuUsage="99" staticCompressionEnableCpuUsage="99">
<scheme name="gzip" dll="%Windir%\System32\Inetsrv\gzip.dll" staticCompressionLevel="9" dynamicCompressionLevel="4" doDynamicCompression="true" doStaticCompression="true"/>
</httpCompression>
</system.webServer>

 

remove duplicate values from a excel cell

Microsoft Excel is used by everyone in the world for all data related things, some time we have duplicate cell contents in rows or in columns.

To remove these duplicate values from the sheet we already have a feature “Remove Duplicates” in latest version of the excel application. But if we have some duplicate values in a single cell then this feature will not work, we need some another alternative, either we delete manually or can create a Macro / Addins / Custom Function.

Manual process will not help because it required lot of concentration,  To resolved that I have created a Addins which we can integrate in excel application and access this custom function like other we generally used.

Steps to create addins:
– Go to View – > Macro
– Define Name “RemoveDuplicatesFromCell” and click on create Button
– Add the following code at Module1 file
– Save the file as RemoveDuplicatesFromCell.xla

Function RemoveDuplicatesFromCell(txt As String, Optional delim As String = " ") As String
Dim x
With CreateObject("Scripting.Dictionary")
.CompareMode = vbTextCompare
For Each x In Split(txt, delim)
If Trim(x) <> "" And Not .exists(Trim(x)) Then .Add Trim(x), Nothing
Next
If .Count > 0 Then RemoveDuplicatesFromCell= Join(.keys, delim)
End With
End Function

 

Only Office – Multifunctional service for business with low cost

Only Office is a great tool which can use by any small scale organization for Project management, online editors, documents management, emails and few more things. Like all the features are available in other products too like Google, Microsoft Office Online, Microsoft SharePoint. All these products stores data to their own cloud servers, they are some expensive for the start-ups or small companies, also their model based on subscription. We need to pay them monthly or yearly subscription.

Only office also host on their cloud machines but we can setup this on our machines too.  A subscription model of this application also cost effective. Any small scale company can afford it. If they want to setup their own machine then it can also be possible.

If we have a small team and would like to share docs between them without worrying about versions, sharing permissions, we can do it easily with this tool. It also support web editors where anyone can open and edit documents without installing the required software’s on local machines. This will help to reduce resources as well.

Only office also easily integrated with existing applications using iframe without worrying and wasting lot of time. It has application programming interface (API) too, so programmers can easily integrate it. Programmers can easily create real time users, upload files, sharing permission to the file without going to portal.

Only office installation is also easy, it provides single click installation for beginners, setup will take case all the things, we need to provide public IP and credentials to start that.

Only office comes with two applications, first Community Server and second one is document server. Community server will take care of all the things like project management, users, sharing, emails, authentication and authorizations. Document server serve the documents online with the support of Iframe.

If anyone wants to use the application for editors only then he can setup document server ONLY. Both application needs to install on separate machines. They are internally responsible for data transfer.

See more about only office please click here

General Medical Terms

  • Patient
  • Hospital / Facility
  • Hospitalist / Provider
  • PCP – Primary Care Physician
  • Referring Physician
  • Consulting Physician
  • Ordering Physician
  • Admitting Physician
  • Attending Physician
  • Dictating Physician
  • Discharging Physician
  • Insurance – Primary, Secondary
  • SSN – Social Security Number
  • ICD –  International Classification of Diseases
  • CPT – Current Procedural Terminology
  • DRG – Diagnosis Related Groups
  • Billing
  • Admission
  • Discharge
  • LOS – Length of Stay
  • Discharge Notes
  • DOS – Date of Service
  • Modifiers
  • ER – Emergency Room
  • ICU – Intensive Care Unit
  • MRI – Magnetic Resonance Imaging
  • Medicare
  • Medicaid
  • POS – Place of Service
  • MRN – Medical Record Number

 

Capture single monitor screenshot from multi monitor setup

When you hit Print Screen key,  windows will take screen shot of  the monitor and copy it to clipboard.

But some users have multiple monitors setup for better productivity,  that time you will find screenshot of all monitors are captured.

You need  how to capture the  screen shot of the current monitor where you are working on. Then you can use  ALT + PrintScreen or CTRL + ALT + PrintScreen.

IIS7/8 URL Rewrite – rewriting non-www to www

In order to Redirect non-www to www on your website, manually edit the web.config file of site and add the following rewrite rule:

<rewrite>
<rules>
<rule name="Redirect example.com to www" patternSyntax="ECMAScript" stopProcessing="true">
<match url=".*" />
<conditions>
<add input="{HTTP_HOST}" pattern="^example.com$" />
</conditions>
<action type="Redirect" url="http://www.example.com/{R:0}" />
</rule>
</rules>
</rewrite>

How to access your machine in browser using VNC?

Steps to access windows machine remotely using browser:

  • Download and install TightVNC , while installation provide password for access. all other info must be default.
  • Install Cygwin with Python  to C:\CYGBIN
  • Download Kanaka noVNC and extract it.
  • Copy Kanaka Folder to C:\CYGBIN\Kanaka
  • Now run the Cygwin.bat using “Run as Admisistrator”
  • Go to root using “cd ..”
  • Now go to Kanaka folder using cd.
  • Type “./utils/launch.sh –vnc localhost:5900”
  • After this command CYGWIN will display some configration with below URL.http://localhost:6080/vnc.html?host=localhost&port=6080
  • Type the URL in browser.. You will see a authentication popup. Provide password which you had setup in step #1.
  • Let’s Enjoy.

XPS To PDF

XPS To PDF is a converter that converts XPS documents to PDF format. Both XPS (XML Paper Specification) and PDF (Portable Document Format) file formats are useful in sharing finalized documents (legal documents, contracts, reports, resumes etc) as the fonts are embedded into the documents itself, it’ll have consistent appearance over multiple devices.

XPS is a PDF like document format created by Microsoft, as an alternative to PDF (developed by Adobe).

You can just download the tool and use it. It is simple to use.

Comparison between ASP.Net and ASP.Net MVC

ASP.Net is development platform for building websites, pages using HTML, CSS, JavaScript’s and Server Side Scripting.

Few years back Microsoft released new version of ASP.Net called ASP.Net MVC which is mainly based on Model View Controller design. It is a lightweight and have all enhanced features of asp.net with more security and testable framework.

Asp.Net Web Forms Asp.Net MVC
It follow a traditional event driven development model It is a lightweight and follow MVC (Model, View, Controller) pattern based development model
It has server controls. It has html helpers.
It has state management (like as view state, session) techniques. It has no automatic state management techniques.
It has file-based URLs means file name exist in the URLs must have its physically existence. It has route-based URLs means URLs are divided into controllers and actions and moreover it is based on controller not on physical file.
It follows Web Forms Syntax It follow customizable syntax (Razor as default)
In It, Web Forms (ASPX) i.e. views are tightly coupled to Code behind (ASPX.CS) i.e. logic. In It, Views and logic are kept separately.
It has Master Pages for consistent look and feels. It has Layouts for consistent look and feels.
It has built-in data controls and best for rapid development with powerful data access. It is lightweight, provide full control over markup and support many features that allow fast & agile development
It has User Controls for code re-usability. It has Partial Views for code re-usability.
It is not Open Source. Asp.Net Web MVC is an Open Source.