One of the great things about working with SQL Server is the incredible support community that has grown alongside the product itself. From local user groups through to conferences and forum websites, the breadth and depth of knowledge available through these mediums is possible only because of many very talented people willing to share their own valuable time in helping others.
Back in 2007, I decided that the best way for me to further advance my knowledge (and therefore career prospects) was to become vigilant with reading and summarizing blogs, articles and whitepapers from Microsoft and SQL Server MVPs. There is a massive amount of freely available SQL Server knowledge out there (far more than I ever imagined) and I naively decided that the best way to manage and benefit from it was to categorize, summarize and link to what I believed to be the best available content. SQLCrunch was born as a result of that decision, and to this day I desperately try and keep up with the torrent of great information released on a daily basis.
Over the last few months, I've been completely consumed with my book, and as a result, the SQLCrunch updates have reduced in frequency somewhat. I've got 143 links queued up and ready to go, and will be adding these to the site over the next week or so. With so many links to add, rather than release them in chronological order (which I typically do), I've decided to release them grouped by category, starting this week with Business Intelligence links ....
Fast Track Data Warehouse Design
This whitepaper introduces and defines a repeatable architecture for building scalable SMP based data warehousing solutions in SQL Server 2008 ... Source : SQLCat.com - Whitepaper
Analysis Services Codeplex Projects
Codeplex is an absolute goldmine. Check out these Analysis Services projects including SSAS stress testing and load simulation, collecting SSAS performance data, powershell scripts and SSIS packages for querying/collecting SSAS DMVs, monitoring scripts for Management Data Warehouse and a whole lot more ... Source : Codeplex.com
In this post, Boyan walks us through an example implementation of a Slowly Changing Dimension (SCD) ... Source : Boyan Penev - Blog Post
The Data Loading Performance Guide
This paper contains the tricks and techniques used by the SQLCat team to achieve the ETL World Record for loading over 1TB of data in under 30 minutes ... Source : MSDN.com - Technical Article
Copying and Moving DTS packages
This post describes the process of copying and moving DTS packages between servers, including to SQL 2005/2008 destinations in which they need to be retained in legacy mode i.e.; not upgraded to SSIS packages ... Source : MSDN.com - Blog Post
In the first post in this series, Andy introduces us to the SSIS expression language, and provides some basic examples. Be sure to follow his later posts on derived columns, conditional splits and dynamic property expressions ... Source : Andy Leonard - SQLBlog.com
Reporting Services Performance Optimizations
In the latest addition to their Building and Deploying Large Scale Reporting Services Environments series, the SQLCAT team describes methods for optimizing Reporting Services architecture for higher throughput and performance, for both 2005 and 2008 environments ... Source : SQLCAT.com - Technical Notes
Thanks to Greg Low for pointing this one out. This BOL article walks us through the process of installing the sample Server Management reports for reporting on Reporting Services itself ... Source : SQL Server Books Online
...
Cheers
source: www.rodcolledge.com
Subscribe to this blog!
Comments