-
Recent Posts
Contents
- Database Concepts
- Downloads
- Interview Questions for SQL DBA
- Sample Interview Questions and Answers
- SQL Concepts
- SQL Server 2012
- SQL Server Analysis Services
- SQL Server Interview Questions and Answers
- SSAS Interview questions
- SSIS Interview Questions and Answers
- SSIS Issues and Resolution
- SSIS Study Guide
- SSRS Interview Questions
- Uncategorized
- What is SQL Server
- What is SQL Server Analysis Service
Archives
Author Archives: randheerparmar
Analytics Function in SQL Server 2012
Analytics quite a buzzword these days in the market. There are few tools in market which do analytics such as SAS, SPSS, R language. My expertise is in SQL Server and trying to relate analytics with SQL Server and many … Continue reading
Posted in SQL Server 2012
Leave a comment
Aggregate Transformations
Aggregate Transformation: Aggregate transformation is used for basic aggregation as in SQL such as count distinct, group by. Advance Window Providing the number of distinct values, exact or approximate, optimizes performance, because the transformation can preallocate an appropriate amount of … Continue reading
Posted in SSIS Issues and Resolution
Leave a comment
What is SQL Server Analysis Service: Chapter 2 (Fact and Dimension?)
What is SQL Server Analysis Service: Chapter 2 (Fact and Dimension?) OLAP data warehouse works across the facts and dimension tables. These are the two parts of representation of data warehouse. FACT: Fact table is the table which calculates the … Continue reading
Posted in What is SQL Server Analysis Service
1 Comment
What is SQL Server Analysis Service: Chapter 1 (Data warehouse and OLAP?)
In OLTP systems, as the time passes the data increases in the OLTP database. Reports which need to be fetched works on same to database where the live transactions are running. I.e. this database is live database interacting with application … Continue reading
What is SQL Server Database?
There are different types of database available in the market which is developed by different companies such as oracle, Microsoft, IBM etc. Database designed by Microsoft is known as SQL Server Database. SQL Server Database server incudes 1. Database Engine. … Continue reading
Posted in What is SQL Server
Leave a comment
What is SQL Server Agent used for?
SQL Server Agent provides the database administrator provision of security by enabling the jobs by role wise. Roles of agent remains in MSDB.
Posted in What is SQL Server
1 Comment
What is SQL Server Browser? Browser Word Confuses me. Let see it in detail.
SQL Server Browser is the windows service which provides the information about the instance of SQL server running on the current computer. SQL Server Browser provides the list of available server and helps to connect to the correct instance of … Continue reading
Posted in What is SQL Server
1 Comment
What is SQL Azure?
SQL Azure is cloud base database platform provided by Microsoft. You can query database, access it. Your database will be hosted online and its DBA tasks will be taken care by Microsoft. I.e. you don’t need to bother about administration … Continue reading
Posted in What is SQL Server
Leave a comment
What is SQL Server Authentication?
As per the word Authentication, it’s the process of verification whether someone using the particular utility or thing is the actual user or not. This verification is called as authentication. There are different mechanism exists for authentication, for applications generally … Continue reading
Posted in What is SQL Server
Leave a comment
What is SQL Server Analysis Service?
Analysis service is Microsoft analytics tool which is used for OLAP and also popular as SSAS (SQL Server Analysis Service). Using Analysis services user can design multidimensional data structure which can be used for generating the reports. Analysis service takes … Continue reading
Posted in What is SQL Server
Leave a comment