T-SQL Programming – How to see Query execution time in milliseconds
1) Objective of the Article Many times, we need to work on small set of masked data in the projects…
Author: Team SQL Circuit
SQL Server – DTS to SSIS Migration
1. Need of DTS to SSIS Migration DTS was first released with SQL Server 7.0 with a objective of helping…
SQL Server 2012 Licensing and Pricing Guide.
1. Overview This Licensing Guide provides a way to understanding how Microsoft® SQL Server® 2012 database software is licensed through…
SQL Server – High Availability & Disaster Recovery solutions
Following is the difference between High Availability & Disaster Recovery solutions provided by SQL Server: High Availability and Disaster Recovery…
SQL Server Reporting Services Vs Performance Point Server (SSRS vs PPS)
Following are the difference between SQL Server Reporting Services (SSRS) and Performance Point Server (PPS) SSRS as well as PPS…
SQL Server – Database Architecture
Database is a place in the SQL Server where we store the data. It the collection of tables, views, stored…
What is Data Warehouse
Before starting learning Data Warehouse, we should be aware of the Father of Data Warehouse, So Ralph Kimball and Bill…
SQL Server – Why SSAS Cube is needed?
Following are the reasons for choosing the SSAS Cube High Performance Multi dimensional analysis Built-in advanced time-calculation Stores hierarchy data…
Process Improvement / Recommendations in Software Development Project(s)
Process: A process is no more than the steps and decisions involved in the way work is accomplished. Process Improvement:…
SSAS Multi-Dimensional Cube Storage Modes
Below is the SSAS cube storage table which is helpful in choosing the right storage mode for your application based…
SQL Server – Best Practices in SSIS 2012
Following are some of the best practices in SSIS which is helpful in performance optimization Hardware Infrastructure: Disks, RAM, CPU,…
SSAS 2012 – Multi-Dimensional Handout
Topics Dimensional Modeling Building a Cube Dimension Usage Namedset Calculated Member KPI Drill Through Partition Design Aggregation Perspective Translation Browsing…