Running SQL Server 2008 in a Hyper-V Environment

Estimating the Size of a Database Determining SQL Server database storage requirements,289483,sid87_gci1289528_mem1,00.html Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications Optimize disk configuration in SQL Server,289483,sid87_gci1262122,00.html Maximum Capacity Specifications for SQL Server Predeployment I/O Best Practices: SQL Server Best Practices Article Hardware and Software RequirementsContinue reading “Running SQL Server 2008 in a Hyper-V Environment”

How to Install SQL 2008 Server in Windows 7

I recently got HP Elite Book 8540w which comes with Windows 7. I want to install SharePoint 2010 in my laptop with SQL Server 208 R2. Before I can Install SharePoint 2010 in Windows 7, I want to install SQL Server 2008 R2 1. Download SQL Developer Edition from your MSDN or Trail Version 2.Continue reading “How to Install SQL 2008 Server in Windows 7”

Top 10 Secrets of a SQL Server Expert

Maintaining a SQL Server environment is a potentially complex endeavor. Here are the top 10 ways you can minimize complexity and reduce stress 1. Know Where to Find Information 2. Monitor and Maintain Performance 3. Take and Test Regular Backups 4. Develop a Comprehensive Disaster Recovery Strategy 6. Ensure the Security of Your System 7.Continue reading “Top 10 Secrets of a SQL Server Expert”

Introducing Microsoft SQL Server 2008 R2

PART I   Database Administration CHAPTER 1   SQL Server 2008 R2 Editions and Enhancements 3 CHAPTER 2   Multi-Server Administration 21 CHAPTER 3   Data-Tier Applications 41 CHAPTER 4   High Availability and Virtualization Enhancements 63 CHAPTER 5   Consolidation and Monitoring 85 PART II   Business Intelligence Development CHAPTER 6   Scalable Data Warehousing 109 CHAPTER 7   Master Data Services 125Continue reading “Introducing Microsoft SQL Server 2008 R2”