URL:

		Notes:

		Give different type of servers 20 IPS (0
			x.x.z.0 - server
			----------------------------
			x.x.z.[1-2]11 - cluster 1 (LAN)
			x.x.z.[1-2]21 - cluster 2 (HBN)
			
			HBN - Heart Beat Network
		LAN - Local Area Network (Management and Production)
		WAN - Wide Area Network (DMZ)
		Users/Clients - Desktop or Mobile - Internet - Firewall - DMZ/VPN(Clients) - Firewall - LAN -
		Web -> Business -> Data
		VHD - SQL Shared disk / SAN (Shared Storage) Fiber
		Management 

			Solution must contain these parts

Database	Microsoft SQL 2005 Project	Contains Tables and Stored procedures.
Business	C#	Contains objects generated from tables.
Common	C#, Class	Contains common functions.
Provider	C#	.Procedures - Contains classes generated from database stored procedures
.Security - Contains classes related to database and security.
Also contains other procedures for data manipulations
Website	C#, ASP.NET 2.0 Web Project	Web Site project.

		

Pattern

Name = <Prefix>-<Country>-<City>-<Environment>-<Cluster><Index>.<Domain>

Examples: Company, Great Britain, London, Live, Domain Controller, Cluster Host 01

DC01.company.local

COM-L-DC01.company.local

COM-GB-LND-L-DC01.company.local

Alpha codes defined by official standards:

Country (alpha-2 codes): https://en.wikipedia.org/wiki/ISO_3166-2

GB Cities (alpha-3 codes): https://en.wikipedia.org/wiki/ISO_3166-2:GB

US States (alpha-2 codes): https://en.wikipedia.org/wiki/ISO_3166-2:US

Classless Inter-Domain Routing (CIDR)

RFC1918 - Internet Assigned Numbers Authority (IANA) assigned blocks of the IP address space for private networks. Internet registry will never assign external Internet IP addresses from the blocks defined below:

Subnet Examples

You can split each supernet address range to different ammount of subnets. For example you can split Business (172.16.0.0/12) range into subnets:

Broadcast Address - is an IP Address that allows information to be sent to all machines on a given subnet rather than a specific machine.

Gateway - is a node (a router) on a computer network that serves as an access point to another network. Gateway in most cases gets first available Address on Windows based networks or last Address on Linux based network.

Pattern

     <product> = <solution>\<feature>\<project>

Project Naming Pattern

Type	Suffix	Description
Console	Console	Command Line Executable
Library	Engine	Shared objects
Library	Controls	Shared controls
LibService	Service	Library which contains service for hosting
Console, WinService	Server	Server
WinApp, WebApp	Client	Client
WinApp, WebApp	Manager	Management interface for server and clients
WinApp, WebApp	Uater	Application to test <feature> projects
WebService	API	IIS .NET Web Service

Server Patterns and Locations

    <com> – Company:  COM
    <env> – Environment:  L | T | L 
    COM   - Databases (SQL)
    SVC   – Services
    WEB   – Websites
    APP   – Applications (RDS)
    <id>  – Server ID: 01 – 32
    <prd> – product.Replace(" ","")

IANA Port Categories:
        0 –  1023 – System or Well Known ports.
     1024 – 49151 – User or Registered ports.
    49152 - 65535 – Dynamic (Private) or Ephemeral Ports.

Port Number Pattern:
    Port = <Solution><Feature><Project><Mode>

Example:
		18700 = COM Solution Messenger Server (LIVE)
		18711 = COM Solution Messenger Client (UAT)

Solution:
     1 – COM Solution
     2 - COM Solution 2
Project:
    80 - Reports Server HTTP
    81 - Reports Server HTTP MEX
    82 - Payments Proxy Server HTTP
    83 - Payments Proxy Server HTTP MEX
    86 - Visual Studio Development Server *
    90 - Messenger (UDP)
    91 - Status Server
    92 – Database (SQL Mirroring)
    93 – SQL Instance
    94 – Solution Win (Form Messenger Receiver).
Type:
     0 – Server
     1 - Client
     2 – SQL Witness (Mirroring Manager)
     3 – SQL Principal (Main Database)
     4 – SQL Mirror (Copy Database)
Mode:
     0 - LIVE
     1 - UAT
     2 - DEV
     3 - DEMO
     4 - DR (Live, UAT, Dev, Demo)

Why ports are different for LIVE, UAT, DEV and DEMO? Because it:
a) Allows to run all services in different modes on same PC (Developer's PC)
b) Separates environments, therefore UAT cannot send data to LIVE by accident.

Port    Project              Type   Mode   Notes
------- -------------------- ------ ------ --------------------
18700 - COM Solution Messenger Server (LIVE)
18701 - COM Solution Messenger Server (UAT)
18702 - COM Solution Messenger Server (DEV)
18703 - COM Solution Messenger Server (DEMO)
18704 - COM Solution Messenger Server (DR)

18710 - COM Solution Messenger Client (LIVE)
18711 - COM Solution Messenger Client (UAT)
18712 - COM Solution Messenger Client (DEV)
18713 - COM Solution Messenger Client (DEMO)
18714 - COM Solution Messenger Client (DR)

# -------------------------------------------------------------
#  Hosts File ()
# -------------------------------------------------------------

127.0.0.1	local.

# -----------------------------
#   Servers
# -----------------------------

10	-DAT.     # Databases Cluster
11	-DAT01.   # Database Cluster Host 01
12	-DAT02.   # Database Cluster Host 02

30	-SVC.     # Services Cluster
31	-SVC01.   # Service Cluster Host 01
32	-SVC02.   # Service Cluster Host 02

50	-WEB.     # Websites Cluster
51	-WEB01.   # Website Cluster Host 01
52	-WEB02.   # Website Cluster Host 02

# -----------------------------
# Domain Servers
# -----------------------------

201	-DC01.  # Domain Server 01
202	-DC02.  # Domain Server 02
210	-WSUS.  # Windows Server Update Services
220	-EXCH.  # MAIL Exchange Services
230	-EPO.   # Anti-Virus ePolicy Orchestrator
240	-DFS.   # Distributed File System (DFS)

70	-RDS.     # Remote Desktop Cluster
71	-RDS01.   # Remote Desktop Cluster Host 01
72	-RDS02.   # Remote Desktop Cluster Host 02

91	-RDSH01.  # Remote Desktop Session Host 01
92	-RDSH02.  # Remote Desktop Session Host 02

In order to build Dac.Solution solution these components must be installed:

• Crystal Reports Redistributable
  Software\Authoring and Programming\SAP Crystal Reports 2008 12.0\SP3\cr2008sp3_redist.zip

Releases

Configs - Various configuration files (DEV, UAT, LIVE)

1.8.0.0 - Win and Web release

1.9.0.0 - Win and Web release

1.2.0.0 - Win and Web release

...

Resources

AJAX Control Toolkit - Microsoft AJAX

Credit Card Validation - Card validation

EnterpriseLibrary - Microsoft Practices EnterpriseLibrary

HTTP Namespace Manager - Configurations tools for reports

Interop - COM objects used in .NET

Krypton Toolkit - Used in Solution Win

Microsoft Data Connection - SQL UI tools used in Support apps

VSTSDB SQL 2005 Schemas - Schema files for Database projects

 

\\company.com\dfs\IT\Development\Software\Server Software\Microsoft SQL Server 2008 Developer Edition 10.0\Add-ons:

Microsoft SQL Server System CLR Types (part of SQL Server Feature Pack)

Microsoft SQL Server 2008 R2 Management Objects (part of SQL Server Feature Pack)

Microsoft SQL Server 2008 R2 Native Client (part of SQL Server Cumulative Update)

 

RedGate dotNET Reflector: http://www.red-gate.com/products/reflector/

Note: SQL 2005 projects are available at the moment only.

VS 2010 does very detail comparison between 2 database schemas. It will produce very big list of changes. In order to make life and comparison results much simpler:

1. Open Visual Studio 2010
2. Tools -> Options -> Database Tools -> Schema Compare
3. Switch to [General] tab on the right
4. Expand "[x] Comparison options" and check
   
   • [x] Ignore ANSI_NULLS
   • [x] Ignore column collation
   • [x] Ignore column order
   • [x] Ignore comments
   • [x] Ignore file names and paths for files and log files.
   • [x] Ignore file group to which an object belongs
   • [x] Ignore full-text catalogue file path
   • [x] Ignore QUOTED_IDENTIFIERS
5. Switch to [Object Types] tab on the right
6. Expand "[x] Ignored object types" and check
   
   • [x] Database Options

-- Scheduled events:
-- Full Backup    - Every Day:     Starts: 00:00:00                 (1 per day)
-- Differential   - Every 6 Hours, Starts: 06:00:00, Ends: 23:59:59 (3 per day)
-- TransactionLog - Every Hour:    Starts: 01:00:00, Ends: 05:59:59 (5 per 6 hours)
-- TransactionLog - Every Hour:    Starts: 07:00:00, Ends: 11:59:59 (5 per 6 hours)
-- TransactionLog - Every Hour:    Starts: 13:00:00, Ends: 17:59:59 (5 per 6 hours)
-- TransactionLog - Every Hour:    Starts: 19:00:00, Ends: 23:59:59 (5 per 6 hours)

3226 flag must be switched ON so frequent logs won't flood SQL and Windows Events log.

-- 3226 flag - suppress successful backup operation log entry.
-- DBCC TRACEON (3226, -1) -- Enable global trace flag.
-- DBCC TRACEOFF(3226, -1) -- Disable global trace flag.
-- DBCC TRACESTATUS        -- List enabled trace flags.

Singe Transaction Log backup file (*.trn) must be used for one scheduled event.

New design:

PROS:

• Simplifies project
• Makes 100% synchronization of schema possible
• Eliminates mistakes related to update of customised procedures

CONS:

• In SQL Management studio it is harder to see on which instance you are working at the moment. Developers can modify something on database till they realize that its a wrong instance till they become familiar with new system.

Instance Prefix:

• DEV  - Shared developers database
• UAT - Shared Uat Database
• LIVE - Live or personal Developer's machine (default).

Instances:

<ServerName1>\COMINS1[DEV|UAT] Instance of SQL Server 2000

[Dacport]

[Manic]

[Intranet]

Link Servers:

• "COMINS2" -> <ServerName2>\COMINS2[DEV|UAT]

<ServerName2>\COMINS2[DEV|UAT] Instance of SQL Server 2005

[Solution]

[Signals]

LinkServers:

• "COMINS1" -> <ServerName1>\COMINS1[DEV|UAT]

Folders:

D:\SQLBACK - backup files (*.bak, *.dif, *.trn)

D:\SQLDATA - data files (*.mdf, *.ndf)

D:\SQLLOGS - log files (*.ldf)