Track Data Changes (SQL Server)

Works for SQL Server starting with 2008.
Enable change data capture for a database:
EXEC sys.sp_cdc_enable_db
GO
Check if it is enabled:
SELECT [name], database_id, is_cdc_enabled  
FROM sys.databases
WHERE is_cdc_enabled = 1
GO
Enable change data capture for a table:
EXEC sys.sp_cdc_enable_table
@source_schema = N‘dbo’,
@source_name= N‘MyTable’,
@role_name= NULL,
@filegroup_name = N‘CDC’,
@supports_net_changes = 0
GO
Check if table is tracked:
SELECT [name], is_tracked_by_cdc  
FROM sys.tables
WHERE is_tracked_by_cdc=1
GO
Select changes:
select * from [cdc].SchemaName_SourceTableName_CT
Cleanup tracked changes:
EXECUTE sys.sp_cdc_change_job
    @job_type = N‘cleanup’,
    @retention = 2880;  

Open command prompt from any folders context menu

There are many tools that can do that for You, but it easy to make it yourself.

When a user right-clicks a Shell object such as a file, the Shell displays a shortcut (context) menu. This menu contains a list of commands that the user can select to perform various actions on the item. These commands are also known as shortcut menu items or verbs. Shortcut menus can be customized.

What you have to do is just add some registry entry in [HKEY_CLASSES_ROOT\Folder\shell\.

All entries here are responsible for what menus to show when you press right menu button and open context menu for a folder.

Command cmd.exe /K \”cd /d %1\”” will open command prompt and navigate to current folder (%1 will by replaced by folder name You are opening context menu automatically )

More on this here.

Save this to any .reg file and execute it:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Folder\shell\CMD\command]
@=”C:\\Windows\\System32\\cmd.exe /K \”cd /d %1\””