SQL Server Uncategorized

SSAS Deployment Strategies

Introduction Building a data warehouse and then a cube based on the data warehouse has become child’s play, thanks to Microsoft’s business intelligence tools. SQL Server Analysis Service is used to build cubes for slicing and dicing data. After the cube has been built we need to deploy it to the SSAS server in order […]

How to Optimize SQL Server Query Plans – The Devil is in the Detail

When dealing with the performance database any detail should can never be neglected, because even the smallest thing can turn out to be a great opportunity for query optimization. Generally, one needs a significant amount of experience to detect that kind of details easily. But what shall the rest do till they gain the required […]

Managing the Report Content Using Report Manager : Subscriptions

In last article Managing the Report Content Using Report Manager: Caching we looked at caching and maintaining the history of the SSRS report. In this article we will be focusing on subscriptions. Reporting services comes with two methods of subscriptions: Windows File Share : Using this method you can place your report in the shared […]

Managing the Report Content Using Report Manager: Part I

What is Report Manager? Report Manager ships with Microsoft SQL Server Reporting Services and is a web application for managing deployed reports. The features of the report manager can be divided into following  types:- General Features: Creation of folders, folder hierarchies and data sources. Printing, searching, hiding, renaming, deleting ,downloading and moving the reports and data […]

Transactions in SQL Server Part I – An Introduction

A basic requirements in most SQL Server based applications is implementing a database operation (DDL or DML) in a single unit of work. The DDL requirement is more from a DBA’s perspective rather than the application, since any application would perform only INSERTs, UPDATEs and DELETEs on the existing data, and a DBA would be […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |