[Visual Studio] How to actually search all files in Visual Studio

I think you are talking about ctrl + shift + F, by default it should be on "look in: entire solution" and there you go.

[SSMS] Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF

Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF. 



 
SET IDENTITY_INSERT [AllAppsUITest].[dbo].[TestEnvironment] ON


Then Insert

 

/* Turn Identity Insert ON so records can be inserted in the Identity Column  */
SET IDENTITY_INSERT [dbo].[TableName] ON
GO
INSERT INTO [dbo].[TableName] ( [ID], [Name] )
VALUES ( 2, 'InsertName')
GO
/* Turn Identity Insert OFF  */
SET IDENTITY_INSERT [dbo].[TableName] OFF
GO

[Excel] Scroll Locked - Arrow Key not moving

Turning off scroll lock without the keyboard key

Windows 10 users

1. Press the Windows key.
2. Type on-screen keyboard and press Enter.
3. When the on-screen keyboard appears, click the ScrLk button.

[MS Word] Font Size

Calibri 

Font size 11

Font size 14

Font size 18

Font size 24

Font size 36

Font size 48

Font size 72

[Coded UI] find matching control for wintabpage

           BrowserWindow br = new BrowserWindow();

            WinTabPage page = new WinTabPage(br);

            MessageBox.Show(page.FindMatchingControls().Count.ToString());

            foreach (WinTabPage pg in page.FindMatchingControls())
            {
                MessageBox.Show(pg.FriendlyName.ToString());
                Console.WriteLine(pg.FriendlyName.ToString());
            }



If the browser window is not specified, it finds a lot of tabs including VS, and every opened apps.

[Coded UI] ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded

System.InvalidOperationException
  HResult=0x80131509
  Message=The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.
  Source=<Cannot evaluate the exception source>
  StackTrace:
<Cannot evaluate the exception stack trace>

[MS Word] insert a blank line before a table in the first page

here is the tip: