Friday, August 7, 2015

MDX Concepts

Posted by at
Labels:

SQL Server Concepts

SQL Server - History (Evolution)
SQL Server - Introduction
SQL Server - Versions
SQL Server - Editions
Highlights of SQL Server by Version
SQL Server  - System Requirements
Database Overview
E-R-MODEL (Entity-Relational)
Table Relationships
SQL Server - System Databases
SQL Server - Commands
SQL Server - T-SQL Basics
SQL Server - Data types
SQL Server - DateTime Functions
SQL Server - Create Statements
SQL Server - Alter Statement
SQL Server - Constraints
SQL Server - Normalization
SQL Server - How Data Stored
SQL Server - Import and Export Wizard
SQL Server - Operators
SQL Server - Set Operators
SQL Server - System Functions
SQL Server - Ranking Functions
SQL Server - IDENTITY Column
SQL Server - Computed Column
SQL Server - CASE Expression
SQL Server - CTE (Common Table Expression)
SQL Server - Alias Names
SQL Server - Logical Functions
SQL Server - Temporary Tables
SQL Server - Table Variables
SQL Server - Sub Queries
SQL Server - Backup and Restore
SQL Server - Synonyms
SQL Server - Joins
SQL Server - System Views
SQL Server - Views
SQL Server - Indexes
SQL Server - Stored Procedures
SQL Server - Cursors
SQL Server - Control Flow Language
SQL Server - Dynamic SQL
SQL Server - User - Defined Functions
SQL Server - Triggers
SQL Server - Data Integrity
SQL Server - ACID Properties
SQL Server - Transactions
SQL Server - Isolation Levels with Examples
SQL Server - Error Handling
SQL Server - CDC (Change Data Capture)
SQL Server - DBCC Commands
SQL Server - Defaults and Rules
SQL Server - Naming Conventions and Standards
SQL Server - Best Practices
SQL Server - Differences 
SQL Server - Replace Function

SQL Server - Interview Questions and Answers

Scenarios:


Working with NULL Values in SQL Server

What is the use of SETNOEXEC Statement in SQL ServerHow to Convert Tabular data into Comma separated string in SQL ServerTRIGGERS, TRIGGERS PERFORMANCE AND RULES FOR CREATING THE TRIGGERSNew Features in Microsoft SQL ServerConvert Seconds to Minutes, Hours and Days in SQL ServerImprove Error Handling using Throw Statement in SQL Server 2012

Sub Queries Vs Joins

A Beginner’s Guide to the OUTPUT Clause in SQL Server
Inner and Left Outer Join with Where Clause vs ON Clause
Solution for SQL Server Error “Saving Changes is Not Permitted”
View and Edit Two Files Side By Side in SQL Server and Notepad++

Display Line Numbers in SQL Server Query Editor WindowRestore SQL Server system database master.mdf without BackupHow Does SQL Server work & perform DML OperationNew features of Microsoft SQL Server 2012 : DenaliInsert default values for all columns in table - SQL ServerScript to get Database Files detail - SQL ServerHow to Enable ‘sa’ Login in SQL ServerSQL Server Authentication ModesHow to Set Backup Compression in SQL ServerIdentify Database Bottlenecks with Performance Monitor CountersRowcount for all tables in SQL Server DatabaseHow to get a total row count in faster waySQL Server - Full Text Search

Deterministic and Non-deterministic Functions in SQL Server
Encrypt Database with Transparent Data Encryption (TDE)
Posted by at
Labels:

SSRS Concepts

SSRS (SQL Server Reporting Services)
SSRS Architecture
Report Server Project
Report Model Project
Report Builder
Data Source
    Embedded Data Source
    Shared Data Source
Data Set
    Embedded Data Set
    Shared Data Set
    Filters at Data set Level
Data Regions
RDL (Report Definition Language)
My First SSRS Report
Report Server Project Wizard
Report Server Project Wizard1
Create a Report using Wizard
Custom Report Template in SSRS
SSRS Query Designer
              Tabular Report
              Matrix Report
                     Filters at Tablix Report
                     Filter at Tablix Level
              Chart Report
                      Bar Chart
                      Pie Chart
                      Drill-Down Chart
                      Column Chart
              Text box
              Image Report
              Line
              List
              Rectangle
             Gauge Report
             Map Report
                  Document Map Report
             Data Bar
             Spark line
             Indicator
Types of Reports:
              Drilldown Report
              DrillThrough
                    Go To URL Action
              Sub Report
Tabbed Report
Parameterized Reports
           Parameters in Report
           Report Parameters
           Multiple Parameters
           Drop-Down List Parameters
           Cascading Parameters
           Multi-Value Parameter
Grouping in Report
Grouping in SSRS Report
Row Grouping
Sorting in SSRS
Sort the data at Tablix
Interactive Sorting in Report
Interactive Sorting
Page Header and Page Footer
Built-In-Functions
Commonly used functions
Linked Report
Caching
Snapshot
Subscriptions
      Standard Subscriptions
      Data-Driven Subscriptions
Roles
Security




Scenario Based:

Installations:

Install SSRS Report Builder 3.0

Development:

How to show tablix inside the tablix
Creating Calculate field in SSRS
Create a report with Excel as Source
Create a report with Excel as Source1
Create a report with Excel as Source2
Conditionally Setting column visibility in SSRS
Keep Headers Visible while scrolling
Repeat Table Header on Each page in SSRS
Repeat Table Header on Each page in SSRS1
Repeat Headers each page
Format Numbers in SSRS
Format Fonts and Background Color of a Textbox in SSRSSet an alternative color in Report
Display a fixed number of rows per page for an SSRS reportCreate a parameterized report in SSRS
Create a report using Expressions in SSRS
SSRS - How to add input parameters in the report
Creating a multi-option parameter report for SQL Server Reporting Services
SQL Server Reporting Services Text Box Orientation
Calendar Date Picker for MDX based Reports in SSRS



Email Configuration in SSRS with SMTP in Windows Server 2008R2
Posted by at
Labels:

SSAS Concepts

SSAS (SQL Server Analysis Services)OLAP (Online Analysis Processing)
UDM (Unified Defined Model)
BISM (BI Semantic Model)
Data Source
       Impersonation Information
Data Source View
         Named Query
         Named Calculation
          Logical Keys
          Add or Remove Tables
          Refresh
Dimension
          Hierarchy
          Attribute Relationships
         AttributeAllMemberName
         Unknown Member
         UnKnownMemberName
         AttributeHierarchyEnabled
         AttributeHierarchyVisible
         DefaultMember
         IsAggregatable (Property)
         Type (Property)
         Usage (Property)
         Name Column
         Value Column
         Key Column
         Order By
         OrderByAttribute
         FormatString
Cube
Measure Groups
       IgnoreUnrelatedDimensions
       ProcessingMode
Proactive Caching
Storage Modes
          MOLAP
          ROLAP
          HOLAP
Tabs:
    Cube Structure
    Dimension Usage
             Relationships
   Calculations
            Calculated Measure
            Named Set
  KPI
 Actions

    Custom Drill Through Action

 Partitions
 Aggregations
 Perspectives
 Translations
 Browser
Processing Options:
Deployment:  

      Transaction Deployment
Roles:
Assemblies


Scenarios:

Creation of cube top-down
Message group has zero dimensional overlap
Posted by at
Labels:

Dtabase Overview

Database overview

A database is an organized collection of data.

DBMS:

DBMS refers to the Database Management System. It is a set of programs that enables you to store, modify, and retrieve the data from a database.

RDBMS:

RDBMS refers to the Relational Database Management System. It is a database management system that is based on the relational model as introduced by E. F. Codd. All modern database systems like MS SQL Server, Oracle, IBM DB2, MySQL, and Microsoft Access are based on RDBMS.

Difference between DBMS and RDBMS:

                              DBMS                           RDBMS
  1. 1. DBMS does not define any constraints or security to ensure the ACID PROPERTY.
  2. 2. Normalization concept is not present.
  3. 3. In DBMS data is treated as files internally.
  4. 4. DBMS does not support distributed databases.
  5. 5. DBMS supports single user.
  1. 1. RDBMS define the integrity constraint to ensure the ACID PROPERTY.
  2. 2. Normalization concept is present.
  3. 3. In RDBMS data is treated as tables internally.
  4. 4. RDBMS support distributed databases.
  5. 5. RDBMS supports multiple users.

- See more at: http://www.beginnerstutorialexamples.com/database-overview/#sthash.MQpn8kHd.dpuf
Posted by at
Subscribe to: Posts (Atom)