How to Setup Dual CCTV Monitors

How to Setup Dual Monitors

Using dual monitors refers to using two physical display devices to increase the viewing space running on a single computer. Microsoft Windows Operating Systems and Mac OS X now support dual and multiple monitor configurations.

Setting up dual monitors is easy. However, it requires the user to add a second video card or install a video card that can support a dual head or two separate physical outputs. The following instructions are for those with only one video card installed in their computers:-

Make sure that the computer is working fine and that it can support more than one video card. Boot in safe mode to make sure that only one video adapter and monitor is shown in Device Manager.

Next, turn off the system and install the second video card. Once installed, connect the second monitor.

If the installation is done correctly, the computer should boot the same way as always and the second monitor should still appear dark. Depending on the presence of the correct drivers bundled with the OS, drivers for the second video card may have to be installed.

Configuring Dual Monitors under Microsoft Windows

Check Device Manager. To do this, right-click My Computer then choose Properties > Hardware > Device Manager. There should be 2 monitors under the Display Adapters.

To configure the second monitor, right-click the desktop and choose Properties. Go to the Settings tab where there are two boxes, one bigger than the other. These represent the two monitors plugged into the computer. Click the second window marked “2” and change the second monitor’s resolution and color depth. Make sure that the display parameters chosen are within the monitors’ limits.

Do not forget to click the “Extend my Windows desktop into this monitor” option. If this is done properly, the 2 monitors should have the same size. Click OK and the 2nd monitor should work properly.

Troubleshooting Dual Monitor Setups

If the above instructions were followed but the second monitor is still not working, check if the operating system supports both monitors.

Also, check the kind of video card that was installed. If the computer has only one AGP slot and a PCI or ISA slot has to be used for the second video card, change the BIOS setting so that the PCI boots before the AGP display adapter.

Set up Dual Monitors Using a Splitter

In order to connect two monitors to the same computer, a VGA or DVI-D splitter can also be used, depending on the computer hardware’s specifications. A VGA splitter simply connects to a computer via a male-to-female VGA cable end. It then splits the digital signal into two parts, without compromising the quality of either part, and directs each part to its respective VGA cable end, allowing a single VGA cable to connect one computer to two separate VGA-based monitors. If a user wishes to connect more than two monitors to a computer, he/she should use a VGA splitter that uses more cable ends.

How to Display Separate Applications on Each Monitor

Although a VGA splitter connects two or more monitors to a single computer, the secondary monitor will be completely blank until the user makes the necessary changes to Windows. In order to display separate applications on each monitor:

1) Click the Start Menu and open the Control Panel.

2) Open the “Appearance and Personalization” category and select “Adjust screen resolution.”

3) Select the “Multiple Displays” menu and choose “Extend these displays.” This will activate the secondary monitor.

4) Launch the programs to be accessed and drag them to the secondary monitor. This is done by simply dragging the program window to the side of the primary monitor, causing the program to appear on the secondary monitor.

Difference between SQL SERVER 2000,2005,2008 and 2012

SQL SERVER 2000:

1.Query Analyser and Enterprise manager are separate.

2.No XML datatype is used.

3.We can create maximum of 65,535 databases.
4.Cant compress the tables and indexes.
5.Datetime datatype is used for both date and time.
6.No varchar(max) or varbinary(max) is available.
7.No table datatype is included.
8.No SSIS is included.
9.CMS (Cenntral Management Server) is not available.
10.PBM (Policy Based Management) is not available.
11.High Availability Clustering or Log Shipping require Enterprise Edition. Expensive hardware.
SQL SERVER 2005:

1.Both are combined as SSMS(Sql Server management Studio).
2.XML datatype is introduced.
3.We can create 2(pow(20))-1 databases.
4.Exception Handling
5.Varchar(Max) data type
6.DDL Triggers
7.DataBase Mirroring
8.RowNumber function for paging
9.Table fragmentation
10.Full Text Search
11.Bulk Copy Update
12.Cant encrypt the entire database.
13.Can Compress tables and indexes.(Introduced in 2005 SP2)
14.Datetime is used for both date and time.
15.Varchar(max) and varbinary(max) is used.
16.No table datatype is included.
17.SSIS is started using.
18.CMS is not available.
19.PBM is not available.
20. High Availability Clustering, Database Mirroring or Log Shipping available in Standard Edition. Database Mirroring can use cheap hardware. 

SQL SERVER 2008:

1.Both are combined as SSMS(Sql Server management Studio).
2.XML datatype is used.
3.We can create 2(pow(20))-1 databases.
4.Exception Handling
5.Varchar(Max) data type
6.DDL Triggers
7.DataBase Mirroring
8.RowNumber function for paging
9.Table fragmentation
10.Full Text Search
11.Bulk Copy Update
12.TDE (Transparent Data Encryption) to encrypt the entire database introduced in 2008.
13.Can compress tables and indexes.
14.Date and time are separately used for date and time datatype,spatial and timestamps with internal timezone is used.
15.Varchar(max) and varbinary(max) is used.
16.Table datatype introduced.
17.SSIS avails in this version.
18.Central Management Server(CMS) is Introduced.
19.Policy based management(PBM) server is Introduced.
20. Auditing - monitoring of data access.
21. Resource Governor. Restrict users or groups from consuming high levels or resources.
22. Activity monitor: consolidates this information by detailing running and recently executed processes, graphically.
23. Backup compression.

SQL Server 2008 to SQL Server R2• Backup compression is available in R2 standard (was only in Enterprise)
• SQL Server 2008 R2 Express Edition database size limit increased to 10 GB (from 4GB)
• PowerPivot for SharePoint introduced for loading, querying, and managing PowerPivot workbooks that you publish to a SharePoint 2010 server
• PowerPivot for Excel is used to assemble and create relationships in large amounts of data from different sources, and then use that data as the basis for PivotTables and other data visualization objects that support data analysis in Excel.
• Utility Explorer introduced for centralized management of managed SQL instances.
• Master Data Services introduced to manage master (reference) data and maintain an auditable record of that data as it changes over time.
• Enhanced security to prevent an authentication relay attack.

SQL SERVER 2012:

1.The SQL Server 2012 uses 48 bit precision for spatial
2.In SQL server 2012 has unlimited concurrent connections
3.By default it supports 15,000 partitions
4.Available new string functions CONCATE and FORMAT
5.Available new conversion  functions are PARSE ,TRY_CONVERT,TRY_PARSE
6.Microsoft.SqlServer.Dac and Microsoft.SqlServer.Dac.Extensions are introduced to perform  operations on Packages.

SQL Server 2008R2 to 2012• Inclusion of Visual Studio 2010 (BI edition)
• AlwaysOn technology – allowing automatic replication and switching to mirrored database/server in the event of problems
• In most instances, the performance is 10 times faster than the predecessor (Microsoft claim)
• Buffer rate is high in SQL Server 2012 because of data compression.
• Data visualization tool is available in SQL Server 2012.This allows snapshots of data.
• Support for persistent computed columns and extra geographical approach is possible with spatial features in SQL Server 2012.
• Allows for warm Service Patch patching – meaning SQL or server does not have to be rebooted/restarted to apply patches
• New ‘Contained Databases’ feature allowing easier movement of database instances between servers
• New ‘ColumnStore’ indexes – which turn indexes 90 degrees in use (instead of one index per row, you get multiple column indexes per row which has a major impact on performance)
• New TRY_CONVERT T-SQL command, which will perform data type conversion, but will NULL rather than error where conversion fails.
• New OFFSET/FETCH command which allows automatic capture of pages of rows (like SELECT TOP 90 * from…, but gives a starting row number for the page)
• Redesign of SQL Server management studio – providing new features, better intellisense, new viewing tools and cleaner interface
• Custom user server roles – meaning you can define roles with specific access (such as BI data reader) and assign these custom roles to defined users (therefore faster user maintenance)
• New virtual Windows FileTable commands in T-SQL lets you manage a folder like a table of documents, but still have external control over the contents: UPDATE C:\Docs\*.* SET ReadOnly = 1 WHERE Author = ‘Bob’ AND Created < ’20100101′;)
• NEGATIVE – SQL Server Management Studio will no longer run on XP. Needs Windows Vista, 7 or 8.
• NEGATIVE – SQL Server is no longer licenced on server, but either CALS or Cores in server CPU which could increase costs for large user connection scenarios.
• NEGATIVE – AWE is no longer supported, meaning your SQL Server instance on x86 with 32GB of RAM is only going to be able to use 4GB. Note – SQL now designed to run on 64bit hardware.

During the CCTV / Access Management Software installation the mail Database is on SQL based. So you must know Difference between SQL SERVER 2000,2005,2008 and 2012.