Monthly Archives: September 2011

SQL Script for getting Backup Information

SQL Script to know when all was last backup was being performed ? SQL Script to know when all was last backup was being performed and what type of backup was taken ? SQL Script to what type of backup is being configured and when it was last run? Backuping all databases is the most [...]

What’s New for Business Intelligence in SQL Server Denali

Microsoft Next version of SQL Server, code name Denali, has lot more new features. Let’s quickly list down all those features. Data Quality Services (DQS) Master Data Services v. 2.0 Impact Analysis and Lineage Integration Services Improvements PowerPivot v. 2.0 New Hierarchies and KPI’s New Visual Diagram View New Measure Grid New Data Type Table [...]

Sample SQL Server Developer Resume – BI

< NAME> PROFESSIONAL SUMMARY: Over 7 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services. Extensive SQL Development experience in Banking, Insurance and Healthcare industries with a strong [...]

Schedule Analysis Services Database Back Up

Can we schedule a Analysis Service (OLAP)Database backup ? How to Backup Analysis Services Database ? YES, we can schedule a OLAP database backup. Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis Services database and its objects. We can take Analysis Services Database Backup in various ways [...]

Backing Up an Analysis Services Database

How to Backup Analysis Services Database ? Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis Services database and its objects. We can take Analysis Services Database Backup in various ways Manually, graphically using SQL Server Management Studio Manually, using a XMLA command / script Schedule a Analysis [...]

Create a XMLA for SQL Analysis OLAP Database Backup

What is Script to take OLAP Database backup manually ? How to Backup Analysis Services Database ? YES, we can create a XMLA script to backup OLAP database . Backing up Analysis Services database, lets administrators save a particular state of a SQL Server Analysis Services database and its objects. We can take Analysis Services [...]

Max Memory setting for SQL Server Analysis Services

Can we set a MAX Memory setting for Microsoft SQL Server Analysis Services like Microsoft SQL Server Database Engine ? How can control memory for SQL Server Analysis Services ? Yes, we can control memory utilization of SQL Server Analysis Services. But this is also true that we cannot directly restrict the SQL Server analysis [...]