A minimum working window service list for a typical home user who upgraded his/her "old" computer to windows 10 recently

Microsoft is pushing window users to upgrade to windows 10 (for free). But if you have some old computers which does not have much memory you may end up with very serious performance issues once upgraded. My laptop had 4 G memory. My computer runs terribly slow once I upgraded from Windows 7 to Windows 10.

I spent lot of time configuring my laptop to optimize the performance and it was not responsive at all. I was even thinking about downgrade back to windows 7. But I finally get the issue fixed by only starting needed windows services. I used msconfig to disable all services (some services will NOT be disabled) and then add only services to make sure I can use internet, printer and audio.

Here is the list of services running at my laptop. (the list is obtained by running "net start" command).
Hope this can save time for people with similar situations.

1. Application Information
2.    Background Intelligent Transfer Service
3.    Background Tasks Infrastructure Service
4.    COM+ Event System
5.    CoreMessaging
6.    Cryptographic Services
7.    DCOM Server Process Launcher
8.    DHCP Client
9.    Diagnostics Tracking Service
10.    DNS Client
11.    Group Policy Client
12.    Local Session Manager
13.    Network Connected Devices Auto-Setup
14.    Network Connection Broker
15.    Network List Service
16.    Network Location Awareness
17.    Network Store Interface Service
18.    Plug and Play
19.    Power
20.    Print Spooler
21.    Remote Procedure Call (RPC)
22.    Remote Procedure Call (RPC) Locator
23.    RPC Endpoint Mapper
24.    State Repository Service
25.    System Events Broker
26.    Task Scheduler
27.    TCP/IP NetBIOS Helper
28.    Tile Data model server
29.    Time Broker
30.    User Manager
31.    User Profile Service
32.    Windows Audio
33.    Windows Audio Endpoint Builder
34.    Windows Connection Manager
35.    Windows Defender Service
36.    Windows Error Reporting Service
37.    Windows Event Collector
38.    Windows Event Log
39.    Windows Update
40.    WLAN AutoConfig
41.    Workstation
42.    WWAN AutoConfig

A good place to check all windows 10 services:
http://www.blackviper.com/service-configurations/black-vipers-windows-10-service-configurations/

Canadian securities regulation and CCMR: cooperative capital market regulatory system

• Passport system but Ontario does not participate in it.  Canadian Securities Administrators (CSA).
• CSA maintains 4 databases:
• SEDAR: System for Electronic Document Analysis and Retrieval
• SED: System for Electronic Disclosure by Insiders
• NRD: National Registration Database
• CTO: National Registration Database
• IIROC (Investment Industry Regulatory Organization of Canada)
• equity and debt market
• criticized by investor advocates as ineffective.
• Investment Dealers Association of Canada (IDA) 
• Market Regulation Services Inc. (RS) 
• MFDA (Mutual Fund Dealers Association)
• No federal regulator
• 
  

1) https://en.wikipedia.org/wiki/Canadian_securities_regulation
2) http://ccmr-ocrmc.ca/

List All Primary Key Columns Within a Database

SELECT
schema_name(ta.schema_id)  SchemaName
,ta.name  TableName
,col.name  ColumnName
,indcol.key_ordinal IndexPositoin
,ind.name IndexName
,ind.type_desc IndexType
,ind.fill_factor Fill_Factor
from sys.tables ta inner join sys.indexes ind
on ind.object_id = ta.object_id
inner join sys.index_columns indcol
on indcol.object_id = ta.object_id
and indcol.index_id = ind.index_id
inner join sys.columns col
on col.object_id = ta.object_id
and col.column_id = indcol.column_id
where ind.is_primary_key = 1
order by 1,2,4

List of all FK in a database

SELECT
OBJECT_NAME(referenced_object_id) 'Referenced table'
,OBJECT_NAME(parent_object_id) 'Parent table'
,cref.NAME 'Referenced column name'
,c.NAME 'Parent column name'
FROM sys.foreign_key_columns fkc INNER JOIN sys.columns c
ON fkc.parent_column_id = c.column_id AND fkc.parent_object_id = c.object_id
INNER JOIN sys.columns cref
ON fkc.referenced_column_id = cref.column_id AND fkc.referenced_object_id = cref.object_id
--where   OBJECT_NAME(parent_object_id) = 'tablename'
order by 1, 2

SSIS quick notes

http://www.bidn.com/blogs/Daniel/ssas/1361/ssis-blocking-non-blocking-and-partially-blocking-transformations
http://www.developer.com/db/top-10-common-transformations-in-ssis.html

A Non Blocking transformation is a dam that just lets the water spill over the top
A Blocking transformation is a dam that lets nothing through until the entire volume of the river has flowed into the dam

Synchronous are components like the Conditional Split or Derived Column Transformation where rows flow into memory buffers in the transformation and the same buffers come out. 

Asynchronous transformation has two types, fully blocking and partial blocking.

Synchronous = non blocking. input and output use same memory buffer
Asynchronous = partial blocking and blocking. Need new memory buffer for output
blocking = no output until all input memory are processed

Merge Join is similar to database join
Merge needs input to be sorted but Union All does not requires this

Non Blocking

• Audit
• Character Map
• Conditional Split
• Copy Column
• Data Conversion
• Derived Column
• Import Column
• Lookup
• Multicast
• Percentage sampling
• Row count
• Row sampling
• Script component

Partially Blocking

• Data mining
• Merge
• Merge Join
• Pivot/Unpivot
• Term Extraction
• Term Lookup
• Union All

Blocking

• Aggregate
• Fuzzy Grouping
• Fuzzy Lookup
• Sort

Some of the best sql free tools

http://www.johnsansom.com/top-10-free-sql-server-tools/

Some of the best sql free tools

http://www.johnsansom.com/top-10-free-sql-server-tools/