IT

Configuration references:

• Download Microsoft® SQL Server® 2008 Express with Tools: De notar que existem várias distribuições de instalação do SQL Server 2008 Express Edition. Esta versão permite a instalação do SQL Server Management Studio bastante útil para manipular a base de dados.
• Instalando o SQL Server 2008 Express por Silas Mendes
• How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)
• Configuring the Windows Firewall to Allow SQL Server Access
• HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express

Articles and other Information references:

• Data Development... 
• SQL Server Online Resources;
• SQL Server Books Online;
• SQL Server Profiler Reference:
  SQL Server Profiler is a tool that captures SQL Server events from a server. The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem. SQL Server Profiler is used for activities such as Stepping through problem queries to find the cause of the problem; Finding and diagnosing slow-running queries; Capturing the series of Transact-SQL statements that lead to a problem. The saved trace can then be used to replicate the problem on a test server where the problem can be diagnosed; Monitoring the performance of SQL Server to tune workloads; Correlating performance counters to diagnose problems);
• Transact-SQL Reference (Database Engine)
  
  
  
  • A list of Transact-SQL functions by category, (Rowset Functions; Aggregate Functions; Ranking Functions; Scalar Functions; 
  • Tutorial: Writing Transact-SQL Statements;