Running SQL Server 2008 in a Hyper-V Environment


Estimating the Size of a Database http://msdn.microsoft.com/en-us/library/ms187445.aspx Determining SQL Server database storage requirements http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1289528_mem1,00.html Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications http://msdn.microsoft.com/en-us/library/ee410782.aspx Optimize disk configuration in SQL Server http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262122,00.html Maximum Capacity Specifications for SQL Server http://msdn.microsoft.com/en-us/library/ms143432.aspx Predeployment I/O Best Practices: SQL Server Best Practices Article http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx 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”