What?s new in PowerPivot for Excel wi...

What’s new in PowerPivot for Excel with SQL Server Code Name "Denali" CTP3 http://ping.fm/3dzqH

What?s New for Business Intelligence ...

What’s New for Business Intelligence in SQL Server Denali - Microsoft Next version of SQL Server, code name Denali, ... http://ping.fm/K0gZZ

Sample SQL Server Developer Resume ? ...

Sample SQL Server Developer Resume – BI - < NAME- DBATAG> PROFESSIONAL SUMMARY: Over 7 years of experience in analyz... http://ping.fm/yBxnr

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 for Time Intelligence
• User Defined Self Service Alerting
• BI Semantic Model (BISM)
• New Project Crescent
• Reporting Services Improvements
  • rendering to .docx format and .xlsx formats
  • compressed and sip files

Download SlideDesk for More information. Shortly I would be working on these items and will come out with more details.

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 understanding of data & analytics.
• Hands on experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2008/2005/2000.
• Experience in Upgrading of SQL Server 2000/2005 databases to SQL Server 2005/2008.
• Extensive experience in using T-SQL (DML, DDL) in SQL Server 2008/20005/2000 platforms.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Expert Experience in Normalization, De-normalization.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.
• Skilled in Business Intelligence tools like SQL Server 2005 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Expertise in building and migration of various DTS packages.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
• Excellent in rendering reports, managing subscriptions, creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Experience in SharePoint & Performance Point Servers.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005 Analysis Services.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Experience in Application Development Analysis, Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications.
• Good knowledge of Computer Science theory & strong in modern programming languages.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

EDUCATION AND CERTIFICATIONS:

• Bachelor of Technology in Computer Science and Engineering
• Masters in Computer Science
• Cisco Certified Network Associate (CCNA)
• Microsoft SQL Server 2008 Maintenance and Implementation

TECHNICAL SKILLS:

• Databases: SQL Server 2000/2005/2008, MS Access 2000, MS Excel, Oracle 9i/10g, Mainframes, DB2
• Programming Languages: T-SQL, PL/SQL, C, C++, HTML, XML, Java
• Operating Systems: Windows 98/2000/2003/XP/NT/Vista, Windows 2000Advanced Server, Windows 2003 Enterprise Server, UNIX.
• IDE & BI Tools: SQL Server BI Development Studio (BIDS), SharePoint, MS Visual Studio 2008/2005
• Version Control: Team Foundation Server (TFS), Visual SourceSafe (VSS).
• ETL Tools: SSIS, Data Stage, DTS
• Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose
• Design Methodology: Unified Modeling Language 1.1 using Rational Rose.
• Packages: Microsoft Office 2007/2003/2000

PROFESSIONAL EXPERIENCE:

Mayo Clinic	March 2010 – July 2011
SQL Server Developer/SSIS/SSRS/SSAS	Minneapolis, MN

Mayo Clinic is a not-for-profit medical practice and medical research group. It specializes in hard-to-treat diseases, and is known for innovative and effective treatments for diseases that had gone undiagnosed or under treated in the same patients with other doctors. The project is a complete solution for the Clinic which includes modules like patient registration system, doctor scheduling, lab track system, discharge system billing system, and deposit system. It is a multi-user system with great search facility. It has a dynamic facility for adding the registration type for each patient. An advanced search facility has helped clients, patients and doctors to search their desired records easily.

Responsibilities:

• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Migrating DTS packages to DTSX using DTSX-change.
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Implemented failure alerts using email in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Created and used extended stored procedure in SSAS.
• Snapshot Replication was been used to synchronize the data between their Different Stores.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration (import & export – BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designed logical/physical data models and defined primary key, foreign key using Erwin tool
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Used DBCC commands to troubleshoot issues related to database consistency.

Environment: SQL Server 2008, Oracle, MS Access, Excel, Windows Server 2008, VSS, ERWIN, Microsoft Visual Studio, MS Visio, MS Integration, Analysis and Reporting Services, Management Studio.

ProTech Associates	February 2008 – February 2010
SQL Server Developer/SSIS/SSRS/SSAS	Columbia, MD

ProTech Associates was founded in 1984 and since then has devoted its efforts exclusively to develop technology solutions for associations. It closely works with each association customer to gain a deep understanding of their organization to develop a solution that best suited their specific needs. The project mainly dealt with creating SSIS packages, building cubes on the OLAP systems, generate reports by extracting data from the cube and checking the performance tuning of stored procedures, troubleshooting and maintenance.

Responsibilities:

• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Created Triggers to enforce data and referential integrity.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Used DataDefractor tool to normalize semi-structured Spreadsheets, fed it into the SSIS pipeline in the form of normalized output of factual data and contextual metadata.
• Reduced the repetition of the particular group in the Excel sheet using the Vertical Sub-Pages and Horizontal Sub-Pages Layout features using DataDefractor Tool.
• Deployed the packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Fine-tuned SSAS cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Identified the dimension, fact tables dimension, fact tables and designed the data warehouse using star schemas
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Used Script Logic Script Logic Quest Lite Speed dramatically to reduce storage costs by quickly compressing data up to 95%.
• Migration of an MS Access application to SQL Server 2000.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created Perspectives of the cube to simplify the process of browsing for the end users.
• Used MDX to create calculated members in the cube.
• · Used to support the data processing engine in database intensive operations like query
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Created Drill-through, Drill-down, Linked Reports and Sub-Report using RDL.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Created queries for generating drill down reports in SSRS 2008.
• Formatted the reports using the Global variables, expressions and Functions.

Environment: MS SQL Server 2008 R2, TSQL, SQL Integration Services (SSIS), SQL Reporting Services (SSRS), Data Warehousing(SSAS), MSIIS, MDX, SAP BPC,MS Access 2003/2005, VB.NET, C#, SQL Profiler.

VHA (Value Health America)	August 2006 – January 2008
SQL Server Developer/SSIS/SSRS	Irving, TX

Value Health America (VHA) is a nationwide network of community-owned health care system and their physicians. The system here includes modules like patient registration system, doctor scheduling, lab track system, discharge system billing system, and deposit system. It is a multi-user system with great search facility. It has a dynamic facility for adding the registration type for each patient. An advanced search facility has helped clients, patients and doctors to search their desired records easily.

Responsibilities:

• Responsible for Data Modeling based on the client requirements.
• Prepared the Technical and Function specifications based on the project requirements.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Modified stored procedures to meet current design and used them in SQL Server.
• Developed queries in Data Warehouse in OLTP/OLAP environment.
• Created complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Modified web pages to do database inserts, deletes, modify.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Created report models from OLTP & OLAP.
• Trained 10 business users so that they can create reports from the report model I created.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Involved in Development, Review and testing of the new system by implementing business rules and transformations. 

Environment: SQL Server 2008/2005, T-SQL, DB Artisan, MS Integration, Analysis and Reporting Services, Management Studio, Query Analyzer, Windows 2007 Server, Oracle 9i.

Life Insurance Corporation of India (LIC)	October 2005 – June 2006
SQL Server Developer/SSIS/SSRS/DBA	Hyderabad, India

Life Insurance is an OLTP system which stores the customer information regarding members and their payments and policies. The warehouse was running on SQL Server 2000 with a web based Dot Net front-end, Implemented infrastructure to support over 15 database servers consisting of more than 150 databases.

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed and implemented stylish report layouts.
• Identified the Data Source and defining them to build the Data Source Views.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implemented full and differential backups and also created and managed DB objects.
• Make recommendations for File group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment : SQL Server 2005/2000, T-SQL, DB Artisan, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, Oracle 9i.

ICICI Bank	June 2004 - September 2005
SQL Server Developer	Hyderabad, India

ICICI InfoTech Services Limited is an IT solutions provider by consolidating all IT resources within the ICICI Group. ICICI group also offers a full range of financial services products to serve the needs of small and large corporations, government, institutional and individual investors.

Responsibilities:

• Setting up new MS SQL Server instances and databases.
• Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Have written several stored procedures and Triggers as per the client requirements.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans and DTS packages.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, DTS Designer, SQL Profiler, Index Tuning Wizard and MS-ACCESS 2000.

Download this Resume as Word File or  PDF file

SQL Server Partial Data backup, a new...

SQL Server Partial Data backup, a new backup type in SQL Server 2005 http://ping.fm/DwRrs

SQL Script to get Backup Information ...

SQL Script to get Backup Information - SQL Script to know when all was last backup was being performed ? SQL Script ... http://ping.fm/Q5vHy

SQL Server Partial Data backup, a new backup type in SQL Server 2005

One of my training participant was asked discussing about refresh of large databases where I suggested him a partial backup strategy but I was shocked when he misunderstood the things and understood that partial backup is same filegroup backup.

So let's understand,

What is SQL Server Partial Database Backup ?

Partial backups were introduced for SQL Server 2005. Partial backups will backup the primary filegroup, any read/write file groups, and any read-only files that are specified during the backup. The partial backup is designed to not backup any data that is placed in a read-only file group. So, you can use a partial backup to backup your entire database – except for the read only data. Partial backups are meant to be used in a simple recovery model situation, although they can be used in a full recovery model situation as well.

Data Loss:

The partial backup provides bare minimum protection from data loss. The partial backup serves as a base for differential partial backups – which can be applied to the partial backup to bring the database closer to a point in time near the actual database failure. A full recovery model with transaction logs provides the best chance to restore the database up to the point of failure.

Size:

A key advantage of using a partial backup as opposed to a full database backup is the reduced file size. The read only filegroups only have to be saved once, therefore the partial backups will be smaller than what would be required for a full database backup.

Resources Required:

The strain on the database will likely be much less for a partial database backup than it is for a full database backup since specified read only filegroups won’t have to be backed up.

How to take a Partial Database Backup ?

Backup Type Partial and Differential partial are newly introduced in SQL Server 2005 and still not supported by SSMS and Maintenance Plans. To take this sort of backup we need to manually write SQL  statement like below

BACKUP DATABASE [ANKUR] READ_WRITE_FILEGROUPS TO DISK = N'c:\ANKUR-25Sep2011.BAK'  -- Full Partial  backup 
BACKUP DATABASE [ANKUR] READ_WRITE_FILEGROUPS TO DISK = N'c:\ANKUR-25Sep2011.BAK' WITH  DIFFERENTIAL  -- Differential Partial backup 

For More Details check BOL.

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 important maintenance part and a DBA should know, what type of backup and when  was it taken last time.

SQL Script to get last backup date and time and type of backup

/*-------------------------------------------------------------------------------------------------------------------------------Description    :     This stored procedure will send out alert email if there is a blocking which lasted more than specified duration)
-- Copyright 2011 - DBATAG

-- Author        :    DBATAG
-- Created on    :    20/09/2011
-- Version       :    1.0
-- Dependencies  :
--                Table                            Procedure
-- Description      : Get backup date and time of last backup and type of backup and till now, how many backups has been performed on aparticular DB.
----------------------------------------------------------------------------------------------------------------------------*/
SELECT sDB.name AS DatabaseName 
      ,MAX(sDB.recovery_model_desc) AS RecModel 
      ,MAX(BS.backup_start_date) AS LastBackup 
      ,MAX(CASE WHEN BS.type = 'D' 
                THEN BS.backup_start_date END) 
       AS LastFull 
      ,SUM(CASE WHEN BS.type = 'D' 
                THEN 1 END) 
       AS CountFull 
      ,MAX(CASE WHEN BS.type = 'L' 
                THEN BS.backup_start_date END) 
       AS LastLog 
      ,SUM(CASE WHEN BS.type = 'L' 
                THEN 1 END) 
       AS CountLog 
      ,MAX(CASE WHEN BS.type = 'I' 
                THEN BS.backup_start_date END) 
       AS LastDiff 
      ,SUM(CASE WHEN BS.type = 'I' 
                THEN 1 END) 
       AS CountDiff 
      ,MAX(CASE WHEN BS.type = 'F' 
                THEN BS.backup_start_date END) 
       AS LastFile 
      ,SUM(CASE WHEN BS.type = 'F' 
                THEN 1 END) 
       AS CountFile 
      ,MAX(CASE WHEN BS.type = 'G' 
                THEN BS.backup_start_date END) 
       AS LastFileDiff 
      ,SUM(CASE WHEN BS.type = 'G' 
                THEN 1 END) 
       AS CountFileDiff 
      ,MAX(CASE WHEN BS.type = 'P' 
                THEN BS.backup_start_date END) 
       AS LastPart 
      ,SUM(CASE WHEN BS.type = 'P' 
                THEN 1 END) 
       AS CountPart 
      ,MAX(CASE WHEN BS.type = 'Q' 
                THEN BS.backup_start_date END) 
       AS LastPartDiff 
      ,SUM(CASE WHEN BS.type = 'Q' 
                THEN 1 END) 
       AS CountPartDiff 
FROM sys.databases AS sDB 
     LEFT JOIN 
     msdb.dbo.backupset AS BS 
         ON BS.database_name = sDB.name 
WHERE ISNULL(BS.is_damaged, 0) = 0 -- exclude damaged backups          
GROUP BY sDB.name 
ORDER BY sDB.name;

Note : In backupset table, we get the following backups status which means

1. D = Database



2. I = Differential database



3. L = Log



4. F = File or filegroup



5. G =Differential file



6. P = Partial



7. Q = Differential partial



8. NULL - not specified

Backup Type Partial and Differential partial are newly introduced in SQL Server 2005 and still not supported by SSMS and Maintenance Plans. To take this sort of backup we need to manually write SQL  statement like below

BACKUP DATABASE [ANKUR] READ_WRITE_FILEGROUPS TO DISK = N'c:\ANKUR-25Sep2011.BAK'  -- Full Partial  backup 
BACKUP DATABASE [ANKUR] READ_WRITE_FILEGROUPS TO DISK = N'c:\ANKUR-25Sep2011.BAK' WITH  DIFFERENTIAL  -- Differential Partial backup 

Schedule Analysis Services Database B...

Schedule Analysis Services Database Back Up - Can we schedule a Analysis Service (OLAP)Database backup ? How to Back... http://ping.fm/VO4u4

Backing Up an Analysis Services Datab...

Backing Up an Analysis Services Database - How to Backup Analysis Services Database ? Backing up Analysis Services d... http://ping.fm/OXKgF

Max Memory setting for SQL Server Ana...

Max Memory setting for SQL Server Analysis Services - Can we set a MAX Memory setting for Microsoft SQL Server Analy... http://ping.fm/Olj0G

SQL Server Analysis Services Authenti...

SQL Server Analysis Services Authentication Modes - Question : Can I have SQL Server Authentication Modes for SQL Se... http://ping.fm/b0C58

StreamInsight 1.2 ? New in SQL Server...

StreamInsight 1.2 – New in SQL Server Code Name "Denali" CTP3 http://ping.fm/4yxtU

SQL SCRIPT to identify Bottleneck / D...

SQL SCRIPT to identify Bottleneck / Diagnostic Information Queries http://ping.fm/9q9mC

Question & Answer Section ? Beta - It...

Question & Answer Section – Beta - It's my immense pleasure to launch Questions & Answers service at SQL Server Trai... http://ping.fm/B0pyN

Performance Issue with ACT, should we...

Performance Issue with ACT, should we upgrade to ACT 2011 Premium for better performance ? http://ping.fm/CTDVW

SQL Script to know Temporary Tables a...

SQL Script to know Temporary Tables and Their Size - Check my previous Post How to Optimize tempdb ? , where I have ... http://ping.fm/PcUbP

SQL Script to get Client Connection D...

SQL Script to get Client Connection Details - Being a DBA, to optimize a performance, at times, you might want to kn... http://ping.fm/aOwNW

Script to Identify worst Performing Q...

Script to Identify worst Performing Queries - Being a DBA, to optimize a performance, a DBA need to know What are mo... http://ping.fm/2vzkD