SQL Server 2008 Data Warehousing Channel 9 Videos

Eric Hanson has created a series of SQL Server 2008 data warehousing videos posted on Channel 9.  They cover data compression, backup compression, star join enhancements, parallel query enhancements, change data capture, grouping sets, and partition-aligned indexed views.   Quick and informative videos to get you up to speed on SQL Server Data Warehousing.  For these videos, checkout http://channel9.msdn.com/Search/?Term=eric%20hanson   Enjoy!  

Rate this:

Disk Partition Alignment Best Practices for SQL Server

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows. This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis, and remediation; and it describes…

Rate this:

Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)

For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Link | Watch this video Author: Denny Lee, Microsoft Corporation This video demonstrates how to measure and understand the performance of packages, based on lessons learned from enterprise customers. In this video, you will learn the following guidelines for improving performance: How the limits of the source system affect performance. Why disk I/O is important. Why…

Rate this:

Webcast on SQL Auditing

For a great webcast on SQL Auditing, check out Database Security: Challenges & Solutions by Ayad Shammout, the Lead Technical DBA at Caregroup Healthcare (Harvard Hospitals) at http://www.brighttalk.com/webcasts/3755/attend   Description Organizations across the globe are being inundated with regulatory requirements.  They also have a storng need to better manage their IT systems to ensure they are operating efficiently and stayign secure.  Auditing is a critical component from the standpoint of regulatory compliance, and ensuring data security and privacy is a big challenge.  In the focus of this presentation, we will look on how to implement a defence-in-depth strategy that can…

Rate this:

Reporting Services, Report Builder, and ReportViewer Controls

I had been asked a number of times what is the difference between Reporting Services, Report Builder, and ReportViewer Controls, so here’s a quick recap: Reporting Services: This is the server-based reporting platform as part of the Microsoft BI stack that allows you to create reporting solutions against multiple data sources.  More information can be found at: http://msdn.microsoft.com/en-us/library/ms159106.aspx.  As part of the Visual Studio 2008 Business Intelligence Development Studio, you can create your reports in a development shell which ultimately creates Repot Definition Language (RDL). Report Builder 2008: Report Builder is an Office-like tool that allows you to create reports with all…

Rate this:

Handling Cross-forest deployments

In many corporate or external-facing SharePoint deployments, it becomes necessary to develop multiple forests or domains to handle different users.  A great explaination of this concept can be found in the SharePoint Team’s blog on Support for Cross-forest deployments.    The basic idea here is that you have two domains, e.g. DomainA and DomainB.  DomainA has your SharePoint servers and you want to be able to add users from DomainB to be allowed access to your site.  An example would be to use the People-Picker on your SharePoint site and you want to add DomainBUser1.  This can work if there…

Rate this:

Professional Microsoft SQL Server Analysis Services 2008 with MDX

For those of you interested in reading up on the latest and greatest for SQL Server 2008 Analysis Services, coming out in March 2009 is the Professional Microsoft SQL Server Analysis Services 2008 with MDX by Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Denny Guang-Yeu Lee.  Yes, I am back to my usual self and writing books again!    Heck, check out my ugly mug on the book for crying out loud.     For more information, check out the Wrox publisher link: Professional Microsoft SQL Server Analysis Services 2008 with MDX   As well, on Wednesday February 25th, 1:30pm…

Rate this: