Restoring SQL Server Database simple summary steps

I always tend to forget the order of this. A short summary for restoring a Sql server  .bak file:

1. Restore database. (Run Sql Server Manager as admin, make sure you window user have access rights to appropiate folders etc).

2. Delete the accompanied database user that is on the “database”. (user should be on database server scope not on the database)

3. If there isn’t already a user on the database server user level, create one, and set the user mapping for user -> database owner of -> newly restored db.

How to: View and Edit Code by Using Peek Definition (Alt+F12)

How to: View and Edit Code by Using Peek Definition (Alt+F12)

Visual Studio 2013

You can use the Peek Definition command to view and edit code without switching away from the code that you’re writing. Peek Definition and Go To Definition show the same information, but Peek Definition shows it in a pop-up window, and Go To Definition shows the code in a separate code window. Go To Definition causes your context (that is, the active code window, current line, and cursor position) to switch to the definition code window. By using Peek Definition, you can view and edit the definition and move around inside the definition file while keeping your place in the original code file.

via How to: View and Edit Code by Using Peek Definition (Alt+F12).

Show all tables where table name contains ‘log’

Select * From INFORMATION_SCHEMA.TABLES
Where
table_name LIKE '%log%'
AND
table_name NOT LIKE '%catalog%'

Show table columns with a specified name:

Use DatabaseName
Select*From INFORMATION_SCHEMA.COLUMNS Where column_name ='ColName'

sql – I want to show all tables that have specified column name – Stack Overflow.

An Overview of Project Katana : The Official Microsoft ASP.NET Site

The ASP.NET Framework has been around for over ten years, and the platform has enabled the development of countless Web sites and services. As Web application development strategies have evolved, the framework has been able to evolve in step with technologies like ASP.NET MVC and ASP.NET Web API. As Web application development takes its next evolutionary step into the world of cloud computing, project Katana provides the underlying set of components to ASP.NET applications, enabling them to be flexible, portable, lightweight, and provide better performance – put another way, project Katana cloud optimizes your ASP.NET applications.

via An Overview of Project Katana : The Official Microsoft ASP.NET Site.

Windows 8 – Run everything as Administrator

If you dont need Metro apps to work enter this into powershell:

Run PowerShell as Administrator and paste the following to disable UAC:

Set-ItemProperty -Path "HKLM:\Software\Microsoft\Windows\CurrentVersion\Policies\System" -Name "EnableLUA" -Value "0"
shutdown -r -t 0

If you want metro apps to work: (this doesnt seem to work for me):

If you entered my registry change to disable UAC, re-enable it with the following command:

PowerShell as Administrator (This requires a restart)

Set-ItemProperty -Path "HKLM:\Software\Microsoft\Windows\CurrentVersion\Policies\System" -Name "EnableLUA" -Value "1"

#Default value is 1

shutdown -r -t 0

To enable automatic silent UAC elevation for administrators without breaking the Microsoft Store you should do the following instead.

PowerShell as Administrator (This takes effect immediately)

#The following is equal to the Security Policy “User Account Control: Behavior of the elevation prompt for administrators in Admin Approval Mode” = “Elevate without prompting”

Set-ItemProperty -Path "HKLM:\Software\Microsoft\Windows\CurrentVersion\Policies\System" -Name "ConsentPromptBehaviorAdmin" -Value "0"

#Default value is 2

#The following is equal to the Security Policy “User Account Control: Allow UIAccess applications to prompt for elevation without using the secure dekstop” = “Enabled”

Set-ItemProperty -Path "HKLM:\Software\Microsoft\Windows\CurrentVersion\Policies\System" -Name "EnableUIADesktopToggle" -Value "1"

#Default value is 0

via Windows 8- Run everything as Administrator – Microsoft (Windows) Discussion & Support – Neowin Forums.