SQLCAT Team is back with their good old wonderful articles and this time it is around the Scale-out of SSRS and these field notes are like goldmines. Anyways, read the article here .
We finished all the three days of our online premier event - Virtual TechDays. I would consider it a success and I had lots of fun delivering something on each and every day. 2 session on Day 1 and Day 2 and today I did a lightweight session around Office tools and productivity features with Nikhil on...
If you ask me personally, I would very well advice you to bookmark the SQLCat Team site. Anyways, there are tons of interesting articles that get published which are fundamentally lessons from the field. Catch this technical notes on running Analysis Services 2008 on Windows Server 2008 vs Windows Server...
Craig has a couple of post on SQL Server 2008 Partitioned tables and Partitioned Indexes . Most interesting is the way Criag uses the ShowXMLPlan to explain the concepts. I sort of like this approach and is easy when writing articles. Earlier I used to have difficulty using the Execution Plan snapshot...
I am sure with RTM just right round the corner, it is important to get to know some of the tips and techniques that will help you and your customers move into SQL Server 2008. Hope this webcast takes you a step closer to this.
Check my blog post on TechNet over Performance Monitoring with SQL Server 2008 here . Feel free to pass your comments.
When released in early 2008, the Windows Server 2008 Security Guide will provide IT professionals with best practices and automated tools to help strengthen the security of servers running Windows Server 2008. The guide is now in Beta release, and is available for your review on Microsoft® TechNet .
Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services...
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping...
Check the BOL documentation on this Partitioning enhancement here .