SQL Server

While a SQL Server 2008 installation is fairly straight forward, a little planning and background knowledge can ensure the a successful install. Microsoft SQL MVP Sean McCown shares his insight with the readers.

Sean McCown, Microsoft SQL MVP, offers valuable insight on using Perfmon to determine if database slowness is being caused by SQL issues.

It’s a common misconception that you will get a performance gain by using several log files. Although this is something we see quite often, Sean McCown, Microsoft SQL MVP, show us how it simply isn’t true.

Brand new from the team at Train Signal and certified instructor Mel Haynes (MS) is SQL Server 2008 Administration Training. Whether you’re a beginner or an experienced administrator, this 10 hour video training course comes packed with everything you need to pass the Microsoft SQL Server 2008 Implementation and Maintenance Exam (70-432).

Download this document in full:  What is SQL Server® 2008 R2 Parallel Data Warehouse? SQL Server® 2008 R2 Parallel Data Warehouse is a highly scalable data warehouse appliance that delivers performance at low cost through a massively parallel processing (MPP).  SQL Server® 2008 R2 Parallel Data Warehouse is the integration of DATAllegro’s MPP Data Warehouse…

What is PowerPivot? PowerPivot (formerly known as Project Gemini) is our latest and hottest business intelligence innovation and intended to finally make BI accessible & easy to the masses using the #1 BI tool in the world: Microsoft Excel. PowerPivot actually consist of a client add-in for Excel 2010 called PowerPivot for Excel and a…

What is Application and Multi-server Management? Microsoft’s investments in Application and Multi-server Management will help organizations manage database environments more efficiently at scale with visibility into resource utilization for consolidation and improved efficiencies across the application lifecycle. These improvements will offer DBAs increased visibility and control, resource optimization, and efficiencies, ultimately leading to a healthier,…

What does StreamInsight mean for customers? While OLTP databases have matured and are capable of processing thousands of transactions per second; they are not optimized for processing continuous high volume, low latency streams of data. Microsoft’s innovative StreamInsight™ platform allows customers to use their own proprietary algorithms to build custom real-time applications, ISVs to build…

In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and full. These recovery models really just define how log management behaves so you can have what you need to perform your desired backups.

Microsoft® SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 with new technologies and capabilities specifically designed to make actionable intelligence accessible to all employees in the enterprise. It delivers a comprehensive data platform that provides built-in security, availability, and scale coupled with robust business intelligence offerings—helping enable high service levels…