InfoPath, REST and Soap - Well explained by MVP

InfoPath with Database

Windows Grep

Windows Grep is a tool for searching files for text strings that you specify. Although Windows and many other programs have file searching capabilities built-in, none can match the power and versatility of Windows Grep. 

Windows Grep is designed for searching plain-ASCII text files, such as program source, HTML, RTF and batch files, but it can also search binary files such as word processor documents, databases, spreadsheets and executables.
Windows Grep runs on Windows 98, 2000, XP, Vista and Windows 7

Download the Exe from http://www.wingrep.com/

SharePoint : Customize Content Query web part - Best

SQL Server recover the "sa" password

We often forget password or sometimes we may remove the sysadmin role for the sa user. This will make us struck in doing administration tasks. To overcome this we need to execute the following commands in SQL Command prompt. 

Step - 1:

Start SQL Server Instance in Single User Mode. How to do click here

Step - 2:

Open a command prompt (Start -> Run -> cmd)

osql -E -S .\SQLEXPRESS_or_SQLInstanceName

exec sp_password @new='NEWPASSWORD', @loginame='sa'

go

alter login sa enablegoexit 

Solution - 2

Change SQL Server Password with the Query Windows in Management Studio. We need to use the Windows authentication to login to the Management studio.

• Step 1. Open SQL Server Management Studio
• Step 2. Open a new query
• Step 3. Type the follow commands and excute:
  GO
  ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
  GO
  USE [master]
  GO
  ALTER LOGIN [sa] WITH PASSWORD=N’NewPassword’ MUST_CHANGE
  GO