SQL Server 2008 | Ward Vissers

System Center Virtual Machine Manager 2012 Beta Evaluation

System Center Virtual Machine Manager 2012 delivers industry leading fabric managment, virtual machine management and services deployment in private cloud environments. Virtual Machine Manager 2012 offers key new features that include hypervisor creation and management, network management, storage management, private cloud creation, self-service usage and service creation. It features deep investments in server application virtualization, service design and service modeling all of which can be used to efficiently offer an on-premises private cloud.

Feature Summary

Fabric Management
- Hyper-V and Cluster Lifecycle Management – Deploy Hyper-V to bare metal server, create Hyper-V clusters, orchestrate patching of a Hyper-V Cluster
- Third Party Virtualization Platforms – Add and Manage Citrix XenServer and VMware ESX Hosts and Clusters
- Network Management – Manage IP Address Pools, MAC Address Pools and Load Balancers
- Storage Management – Classify storage, Manage Storage Pools and LUNs
Resource Optimization
- Dynamic Optimization – proactively balance the load of VMs across a cluster
- Power Optimization – schedule power savings to use the right number of hosts to run your workloads – power the rest off until they are needed
- PRO – integrate with System Center Operations Manager to respond to application-level performance monitors
Cloud Management
- Abstract server, network and storage resources into private clouds
- Delegate access to private clouds with control of capacity, capabilities and user quotas
- Enable self-service usage for application administrator to author, deploy, manage and decommission applications in the private cloud
Service Lifecycle Management
- Define service templates to create sets of connected virtual machines, os images and applica tion packages
- Compose operating system images and applications during service deployment
- Scale out the number of virtual machines in a service
- Service performance and health monitoring integrated with System Center Operations Manager
- Decouple OS image and application updates through image-based servicing
- Leverage powerful application virtualization technologies such as Server App-V

System Requirements

Supported Operating Systems:Windows 7 Enterprise;Windows 7 Professional;Windows 7 Ultimate;Windows Server 2008 R2;Windows Server 2008 R2 Datacenter;Windows Server 2008 R2 Enterprise
- Windows Server 2008 R2 (full installation) Standard, Enterprise, Datacenter x64
- Windows 7 Professional, Enterprise, Ultimate x32, x64
- Windows Remote Management (WinRM) 2.0
- Windows PowerShell 2.0
- Microsoft .NET Framework 3.5 Service Pack 1 (SP1)
- Windows Automated Installation Kit (AIK) for Windows 7
- SQL Server 2008 or SQL Server 2008 R2 Standard, Enterprise, and Datacenter
- Windows Deployment Services (WDS) – (Version on Windows Server 2008 R2)
- Windows Software Update Services (WSUS) 3.0 SP2 64bit

Download System Center Virtual Machine Manager 2012 Beta Evaluation HERE

Microsoft Assessment and Planning Toolkit 5.5

The Microsoft Assessment and Planning Toolkit (MAP) is an agentless, automated, multi-product planning and assessment tool for quicker and easier desktop and server migrations. MAP provides detailed readiness assessment reports and executive proposals with extensive hardware and software information, and actionable recommendations to help organizations accelerate their IT infrastructure planning process, and gather more detail on assets that reside within their current environment. MAP also provides server utilization data for Hyper-V server virtualization planning; identifying server placements, and performing virtualization candidate assessments, including ROI analysis for server consolidation with Hyper-V.

MAP helps make the following IT planning projects faster and easier:

Migration to Windows 7, Windows Server 2008 R2, and Microsoft Office 2010
Migration to Windows 7 compatible versions of Internet Explorer
Migration to cloud-based services
Server virtualization with Hyper-V
SQL Server consolidation and migration to SQL Server 2008 R2
Assessment of current software usage and client access history for simplified software asset management
PC security assessment and migration to Microsoft Forefront Client Security

You can use MAP to inventory the following technologies:

Windows 7
Windows Vista
Windows XP Professional
Office 2010 and previous versions
Windows Server 2008 or Windows Server 2008 R2
Windows Server 2003 or Windows Server 2003 R2
Windows 2000 Professional or Windows 2000 Server
VMware ESX
VMware ESXi
VMware Server
Linux variants
LAMP application stack discovery
SQL Server 2008
SQL Server 2008 R2
MySQL
Oracle
Sybase

Download MAP 5.5 HERE

Microsoft Application Compatibility Toolkit (ACT)

The Microsoft Application Compatibility Toolkit (ACT) 5.5 is a free tool from Microsoft. It helps customers understand their application compatibility situation by identifying which applications are compatible with the Windows 7 RC and Windows Vista® operating system and which require further testing. ACT helps customers lower their costs for application compatibility testing, prioritize their applications, and deploy Windows more quickly. You can use the ACT features to:

Verify an application’s compatibility with a new version of the Windows operating system, or a Windows Update, including determining your risk assessment.
Become involved in the ACT Community, including sharing your risk assessment with other ACT users.
Test your Web applications and Web sites for compatibility with new releases and security updates to the Windows® Internet Explorer® Internet browser.

Software Requirements:

Type of Software	Type of Software
Operating Systems	– Windows 7 – Windows Vista – Windows Vista with Service Pack 1 (SP1) – Windows XP with Service Pack 2 (SP2) or Service Pack 3 (SP3) – Windows Server 2003 with Service Pack 2 (SP2) – Windows Server 2008 R2
Database Components	– Microsoft SQL Server 2008 – Microsoft SQL Server 2005 – Microsoft SQL Server 2008 Express – Microsoft SQL Server 2005 Express
.NET Framework	– ACT requires the .NET Framework 2.0 or newer.

Download HERE

EBook: Introducing Microsoft SQL Server 2008 R2

Microsoft released SQL Server 2008 R2 to manufacturing (RTM). To promote this new version they have released a free ebook: Introducing Microsoft SQL Server 2008 R2.
To download the ebook just click on the picture.

Microsoft Assessment & Planning Toolkit

The Microsoft Assessment and Planning (MAP) Toolkit is an agentless toolkit that finds computers on a network and performs a detailed inventory of the computers using Windows Management Instrumentation (WMI) and the Remote Registry Service. The data and analysis provided by this toolkit can significantly simplify the planning process for migrating to Windows® 7, Windows Vista®, Microsoft Office 2007, Windows Server® 2008 R2, Windows Server 2008, Hyper-V, Microsoft Application Virtualization, Microsoft SQL Server 2008, and Forefront® Client Security and Network Access Protection. Assessments for Windows Server 2008 R2, Windows Server 2008, Windows 7, and Windows Vista include device driver availability as well as recommendations for hardware upgrades.

You can use MAP to inventory the following platforms:

Windows 7
Windows Vista
Windows XP® Professional
Windows Server 2008 or Windows Server 2008 R2
Windows Server 2003 or Windows Server 2003 R2
Windows 2000 Professional or Windows 2000 Server
VMware ESX
VMware ESXi
VMware Server

Reporting
– Identification of currently installed Windows client operating systems, their hardware, and recommendations for migration to Windows 7 and Windows Vista. The tool also reports if desktops have anti-virus and anti-malware programs installed and if the Windows Firewall is turned on.
– Identification of currently installed Windows Server operating systems, their hardware, and recommendations for migration to Windows Server 2008 R2 and Windows Server 2008.
– Identification of currently installed Microsoft Office software and recommendations for migration to Microsoft Office 2007.
– Detailed assessment and reporting of server utilization gathered using the Performance Metrics Wizard.
– Recommendations for server consolidation and virtual machine placement using Hyper-V
– Assessment of client machines, servers, and the technology environment for the implementation of Microsoft Application Virtualization (APP-V)
– Identification of machines where Microsoft SQL Server components are installed.
– Identification of virtual machines, their hosts, and details about each.
– Identification of Windows Server Roles

Hardware Requirements:
– Windows 2003 x86/x64 or Windows 2008 x86/x64
– 1,5 GB (2 GB 2008)

Software Requirements:
– NET Framework 3.5 SP1
– Windows Installer 4.5
– Microsoft Office Word 2007 or Word 2003 SP2
– MIcrosoft Office Excel 2007 or Excel 2003 SP2
– SQL Server 2008 Express Edition, SQL Server 2008, or SQL Server 2005

Download Microsoft Assessment and Planning (MAP) Toolkit HIER

Installeren VMWare vSphere 4.0 op Windows 2008 x64 SP2

1. Zorg dat je werkende Windows 2008 x64 server hebt en werkende SQL Server . Ik heb tijdens deze installatie SQL Server 2008 standaard gebruikt. Maak op de sql server 2 Databases op aan bijvoorbeeld vmware & vmware udm

2. Download de Microsoft Native SQL Client voor 2008 hebt. Downloaden doe je hier: X64 Package (sqlncli.msi) – 7963 KB

3. Open de System32DNS door het volgende commando uit te voeren in run: %systemdrive%\Windows\SysWoW64\Odbcad32.exe
Microsoft: kb942976
VMWare: kb1010401

4. Maak 2 Systeem-DSN’s aan, een voor VMware zelf en een voor de update manager
Zie de volgende scherm afbeeldingen. Doe de volgende stappen dus 2 keer.