In a previous post, I started the process of my study for the 70-432 exam. I’m working on that (as I have time) and I promised to post my notes here. My notes aren’t totally inclusive, they are just things I found interesting as I was doing my reading.
Here’s where I’m at today:
I’ve added this book, since it has practice tests as well: http://www.amazon.com/MCTS-Self-Paced-Training-70-432-PRO-Certification/dp/0735626057/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1238461542&sr=8-1
1. Install SQL Server 2008 and related services – file locations; default paths; service accounts
- NTFS is required for installation, but if you upgrade FAT32 won’t be blocked.
- Read-only and compressed drive installs are blocked.
- Dot Net might require a restart
- MSDE will upgrade to Express
- 2K5 Express will go to Workgroup
- Evaluation will upgrade to "real" versions
- IS and client components are not Instance related
- The Windows firewall may close TCP port 1433, which is the default port for SQL Server. UDP Port 1434 is the SQL Browser service, and if you have multiple instances you need to open that as well
- SQL Server 2008 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 Standard, Enterprise and Data Center editions.
- If you use EFS, the database files will be encrypted under the identity of the account running SQL Server
- SQL Server 2008 will install side-by-side with everything from 2K up, with the exception of IA64
- Windows 2008 Server Core not supported since there is no dot-net.
- Installation requires Shared Memory, Named Pipes, or TCP/IP protocols
- For server, you need Windows 2003 Stanard SP2 or higher
- Use Unicode to store multi-lingual data
- SQL Server 2008 supports setting collations at the following levels:
- The server-level collation can either be changed during setup, or by changing the Windows system locale before installation.
- Binary is the fastest sorting order and is case-sensitive, but can yield unexpected sort orders.
- Three editions have all features in SQL Server: Enterprise, Developer and Evaluation. Only Enterprise can be used in Production.
- http://msdn.microsoft.com/en-us/library/ms143504.aspx – Service Accounts
- Use the Configuration Manager to change the service accounts – it does things other than just set the account
- The DBTA requires an administrator to run the first time, then a dbo can run it on their own databases after that
- For SQL Server and SQL Server Agent to run as services in Windows, SQL Server and SQL Server Agent must be assigned a Windows user account.
- IS is not Instance-aware
- The Workgroup edition is where the memory limits start – at 4GB. Express is 1 GB.
- By default, sample databases and sample code are not installed as part of SQL Server Setup.
- Up to 16 Instances are available for install on all editions except Enterprise, which can have 50.
- Currently stopped at: http://msdn.microsoft.com/en-us/library/bb510455.aspx