Solved CISCO VPN issue on Windows 10 and Windows 8

Below are the 3 solutions you can do to resolve the Cisco VPN client 5.0.07.0440 for x64 5.0.07.0410 and x86

Enable windows 10 dark theme

Here's an easier and faster way to do it. Just: 

 1 - Open search, type Powershell and open it

 2 - copy/paste the following command 

New-ItemProperty -Path HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\Themes\Personalize -Name AppsUseLightTheme -Value 0

3 - Press enter. Done.
If you want to undo, just copy/paste Remove-ItemProperty -Path

HKCU:\SOFTWARE\Microsoft\Windows\CurrentVersion\Themes\Personalize -Name AppsUseLightTheme

ICC 2015 cricket world cup live streaming

Popular Visual studio add-ons/plugins

SQL Prompt for Database Projects (works inside your SQL Management Studio as well)

SmartPaster - (FREE) Copy/Paste code generator for strings

 AnkhSvn - (FREE) SVN Source Control Integration for VS.NET

VisualSVN Server - (FREE) Source Control

ReSharper - IDE enhancement that helps with refactoring and productivity

CodeRush - Code gen macros on steroids

Refactor - Code refactoring aid

CodeSmith - Code Generator

PowerCommands is a Microsoft-created plugin that offers a variety of new features that one would think probably should have been in Visual Studio in the first place.

GhostDoc - (FREE) Simple code commenting tool

DXCore (FREE) and its many awesome plugins: DxCore Community Plugins, CR_Documentor,CodeStyleEnforcer, RedGreen

TestDriven.Net - (FREE/PAY) Unit Testing Aid

Reflector - (PAY) Feature rich .Net Disassembler Reflector AddIn's

Web Deployment Projects - Provides additional functionality to build and deploy Web sites and Web applications (source).

StudioTools - (FREE) Navigation assistant, code metrics tool, incremental search, file explorer in visual studio and tear off editor windows

Clipboard Manager

Maintains your clipboard data through removal of lines, a few other nice items but that one alone makes me happy.

Regionerate

While some have problems with regions I think if you use them, this tool is for you. Automatically region'izes your code into appropriate region blocks. Fully configurable for custom items etc.

SQL Server 2008 MERGE statement

One Statement for INSERT, UPDATE, DELETE

In earlier versions of SQL Server we had to write separate statements for Insert,update and Delete based on certain conditions but now, using MERGE statement we can include the logic of such data modifications in one statement that even checks when the data is matched then just update it and when unmatched then insert it.

One of the most important advantage of MERGE statement is all the data is read and processed only once. In previous versions three different statement has to be written to process three different activity (INSERT, UPDATE or DELETE), however using MERGE statement all update activity can be done in one pass of database table. This is quite an improvement in performance of database query.

Syntax of MERGE statement is as following:

MERGE
[ TOP ( expression ) [ PERCENT ] ]
[ INTO ] target_table [ WITH ( ) ] [ [ AS ] table_alias]
USING
ON
[ WHEN MATCHED [ AND ]
THEN ]
[ WHEN NOT MATCHED [ BY TARGET ] [ AND ]
THEN ]
[ WHEN NOT MATCHED BY SOURCE [ AND ]
THEN ]
[ ]
[ OPTION ( [ ,...n ] ) ];

Example:
Let’s create Student Details and StudentTotalMarks and inserted some records.

Student Details:

USE TestDataBase
GO
CREATE TABLE StudentDetails
(
StudentID INTEGER PRIMARY KEY,
StudentName VARCHAR(15)
)
GO
INSERT INTO StudentDetails
VALUES(1,'Aditya')
INSERT INTO StudentDetails
VALUES(2,'MARK')
INSERT INTO StudentDetails
VALUES(3,'SAM')
INSERT INTO StudentDetails
VALUES(4,'JOHN')
INSERT INTO StudentDetails
VALUES(5,'GARY')
GO

StudentTotalMarks:

CREATE TABLE StudentTotalMarks
(
StudentID INTEGER REFERENCES StudentDetails,
StudentMarks INTEGER
)
GO
INSERT INTO StudentTotalMarks
VALUES(1,230)
INSERT INTO StudentTotalMarks
VALUES(2,255)
INSERT INTO StudentTotalMarks
VALUES(3,200)
GO

In our example we will consider three main conditions while we merge this two tables. Delete the records whose marks are more than 250. Update marks and add 25 to each as internals if records exist. Insert the records if record does not exists. Now we will write MERGE process for tables created earlier. We will make sure that we will have our three conditions discussed above are satisfied.


MERGE StudentTotalMarks AS stm

USING (SELECT StudentID,StudentName FROM StudentDetails) AS sd
ON stm.StudentID = sd.StudentID
WHEN MATCHED AND stm.StudentMarks > 250 THEN DELETE
WHEN MATCHED THEN UPDATE SET stm.StudentMarks = stm.StudentMarks + 25
WHEN NOT MATCHED THEN
INSERT(StudentID,StudentMarks)
VALUES(sd.StudentID,25);
GO

There are two very important points to remember while using MERGE statement. 

•  Semicolon is mandatory after the merge statement. 
• When there is a MATCH clause used along with some condition, it has to be specified first among all other WHEN MATCH clause.

AS we can see there are 5 rows updated. StudentID 2 is deleted as it is more than 250, 25 marks have been added to all records that exists i.e StudentID 1,3 and the records that did not exists i.e. 4 and 5 are now inserted in StudentTotalMarks.

MERGE statement is very handy improvement for T-SQL developers who have to update database tables with complicated logic. MERGE statement also improves the performance of database as it passes through data only once.