This technical note describes the consolidation options, considerations, and best practices for Microsoft® SQL Server® 2008 Analysis Services that the SQL CAT team has derived from working with Analysis Services customers. In this technical note, we also discuss an Analysis Services load balancer solution that one of our internal customers uses to load balance queries from Microsoft Excel® and SQL Server Reporting Services clients across multiple query servers to increase query performance and provide availability.

Sometimes, you have to fix it yourself

by Wesley Brown

SQLServerCentral.com

Blogs

The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...

SQL Saturday #37 - Philadelphia

by Press Release

SQLServerCentral.com

SQLSaturday

Come to this great one day training event in Philadelphia, PA. SQL Saturday is a great way to get free training on all aspects of SQL Server.

Dynamically Map Column Data Based on Column Pattern Profiling

by Ira Whiteside

SQLServerCentral.com

Integration Services (SSIS)

Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.

Managing Analysis Services Deployment - Part 3

by Shahfaisal Muhammed

SQLServerCentral.com

Analysis Services (SSAS)

Part 3 of this series, Shahfaisal Muhammed brings a common method of deploying your SSAS projects to a new server: backup and restore. The rest of the series covers other methods.

Multiple Mirrors

by Steve Jones

SQLServerCentral.com

Editorial

Should we evolve the database mirroring technology to work with multiple mirrors? Steve Jones says this might be an interesting idea.

Professional Microsoft SQL Server 2008 Reporting Services - Sample Chapter

by Press Release

SQLServerCentral.com

Reporting Services (SSRS)

Learn about SQL Server 2008 Reporting Services with this new title from Wiley. We have a sample chapter you can read to see if you like this book.

Development Lifecycle Deployment SSAS, SSRS, SSIS

by Devin-Knight

SQLServerCentral.com

Blogs

Many companies have a very rigid development lifecycle for all products or solutions they develop. Deploying to each of these...

SQL Server Lazy Writer Issue: Warning, No Free Buffers Found

by Additional Articles

MSSQLTips.com

Administration

This tip is intended to help someone who is or will be facing a no free buffer found issue with the SQL Server LazyWriter. Recently, we experienced some unknown issues with our SQL Server and after inspecting the error log file we noticed the following errors: "SQL Server has encountered 50 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file..." and "LazyWriter: warning, no free buffers found." These error messages were followed by a SQL Server memory dump file like SQLDump0030.mdmp in the file system.

The T-SQL Hammer

by Chad Miller

SQLServerCentral.com

Blogs

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...

Microsoft SQL Server 2008 Analysis Services Consolidation Best Practices

Sometimes, you have to fix it yourself

SQL Saturday #37 - Philadelphia

Dynamically Map Column Data Based on Column Pattern Profiling

Managing Analysis Services Deployment - Part 3

Multiple Mirrors

Professional Microsoft SQL Server 2008 Reporting Services - Sample Chapter

Development Lifecycle Deployment SSAS, SSRS, SSIS

SQL Server Lazy Writer Issue: Warning, No Free Buffers Found

The T-SQL Hammer

Blogs

Upgrading SQL Server Containers on the Laptop

How to Find Expensive Queries in Amazon Redshift

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

How Long is a Long I/O?

T-SQL Trigonometric Functions in SQL Server

Question of the Day

How Long is a Long I/O?