Monday, 30 January 2017

How can I switch my signed in user in Visual Studio

git error we were unable establish the connection because it is configured for user
visual studio 2015 we were unable to establish the connection because it is configured for user
How can I switch my signed in user in Visual Studio 2013?

Try below options...

Option 1:

1. Close Visual Studio
2. Start the Developer Command Prompt from Visual Studio Tools installed with Visual Studio as an administrator.
3. type 'devenv /resetuserdata'  ('wdexpress /resetuserdata' for Express SKUs)
4. Start Visual Studio Normally.


Option 2:

Delete the following key in regedit

hkey_current_user\software\Microsoft\VSCommon\12.0\clientservices\tokenstorage\visualstudio\ideuser

Saturday, 21 January 2017

Sunday, 25 December 2016

Find a string by searching all tables in SQL Server


CREATE PROC SearchAllTables
(
@SearchStr nvarchar(100)
)
AS
BEGIN

    CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

    SET NOCOUNT ON

    DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
    SET  @TableName = ''
    SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

    WHILE @TableName IS NOT NULL

    BEGIN
        SET @ColumnName = ''
        SET @TableName =
        (
            SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
            FROM     INFORMATION_SCHEMA.TABLES
            WHERE         TABLE_TYPE = 'BASE TABLE'
                AND    QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
                AND    OBJECTPROPERTY(
                        OBJECT_ID(
                            QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
                             ), 'IsMSShipped'
                               ) = 0
        )

        WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)

        BEGIN
            SET @ColumnName =
            (
                SELECT MIN(QUOTENAME(COLUMN_NAME))
                FROM     INFORMATION_SCHEMA.COLUMNS
                WHERE         TABLE_SCHEMA    = PARSENAME(@TableName, 2)
                    AND    TABLE_NAME    = PARSENAME(@TableName, 1)
                    AND    DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'int', 'decimal')
                    AND    QUOTENAME(COLUMN_NAME) > @ColumnName
            )

            IF @ColumnName IS NOT NULL

            BEGIN
                INSERT INTO #Results
                EXEC
                (
                    'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
                    FROM ' + @TableName + 'WITH (NOLOCK) ' +
                    ' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
                )
            END
        END  
    END

    SELECT ColumnName, ColumnValue FROM #Results
END

Then call store proc
exec SearchAllTables '843DE4FEAF494C59A656B4CD4AAB7669'

then delete  store proc and temp tables

Monday, 12 December 2016

ASP.NET MVC makes use of some basic naming conventions for folder names

ASP.NET MVC makes use of some basic naming conventions for folder names:
Folder
Purpose
/Controllers
Controllers respond to input from the browser, decide what to do with it, and return response to the user.
/Views
Views hold our UI templates
/Models
Models hold and manipulate data
/Content
This folder holds our images, CSS, and any other static content
/Scripts
This folder holds our JavaScript files

Monday, 28 November 2016

RDF

Resource Description Framework (RDF) Model and Syntax Specification

https://www.w3.org/TR/1999/REC-rdf-syntax-19990222/#intro

Monday, 21 November 2016

PowerShell Need leading zero

Problem:
SET Today=%date:~4,2%%date:~7,2%%date:~10,4%%time:~0,2%%time:~3,2%%time:~6,5%.log
 echo %today%

If you run above script, you will get space, if the system time is AM.
Solution:
set hour=%time: =0%
SET Today=%date:~-4%%date:~4,2%%date:~7,2%_%hour:~0,2%%time:~3,2%%time:~6,2%.log
echo %Today%

Thursday, 17 November 2016

powershell PSScriptRoot one folder up

$ParentRootPath = Split-Path (Split-Path $PSScriptRoot -Parent) -Parent # This one will give parent parent path
$RootPath = Split-Path $PSScriptRoot -Parent # This one will give parent path