Business Intelligence from a technical point of view involves identifying business data which help to answer decision related questions and then extracting, transforming and loading the data into useful for analysis format (data warehouse). Once data is inside the data warehouse (or/and OLAP cube) business people can answers to help them make the right decisions.
T-SQL Tutorial
Welcome to our T-SQL Tutorial for beginners and everyone else. Let me warn you at the beginning that this tutorial is different comparing to most T-SQL Tutorials. Most of the articles you will find here will be very short and describe specific query (question). So in here we won't be focusing on explaining T-SQL (at least not yet) but we will focus on giving you practical examples for common queries or things that you should commonly use
ssrs interview questions
SQL Server Reporting Services skills are required in more and more IT Developer Jobs so if you need to interview someone with SSRS skills and you do not know much about the tool itself than it is worth knowing what are good SSRS Interview questions and answers. Currently I just prepared not very structured questions but later on I will try to structure them so you can ask basic junior questions for junior positions and senior questions for senior positions. These are Developer related question and are not so much applicable for DBA roles and they are not necessarily commonly asked questions.
ssis interview questions
If you need to interview someone with SSIS skills and you do not know much about the tool itself than it is worth knowing what are good SSIS Interview questions and answers to ask. Currently I just put questions and answers but later on I will try to structure them so you can ask basic junior questions for junior positions and senior questions for senior positions.
SQL Server Denali Release Date
Microsoft SQL Server Denali official Release Date is currently (May 2011) not known but CTP1 (open beta testing v1) has been released in November 2010 and CTP2 is expected to be released soon (June 2011?). Therefore we might expect that the final version will be released before end of 2011. I will update this blog with true / final release date when it is made public by Microsoft.
Create ssis package
If you are new to SSIS and would like to create your first SSIS package then below is a simple example with step by step instructions which will show you how to create an SSIS package in bids. I will use SQL Server Integration Services 2008 R2 and Visual Studio 2008 (instructions should be very similar for 2008 and 2005). This tutorial is for beginners and will not be following best practise which includes using variables and package configuration. At the end of tutorial I will post extra materials (once I create them) which will include best practise and package deployment.
My forte are SQL Server Reporting Services enhanced with PROPER Data Visualization, Integration and Analysis Services enhanced with Kimball Data Warehouse Designs, T-SQL Querying/Programming and MDX querying.
Please click the following link for more information about Business Intelligence or SQL Server Business Intelligence
T-SQL Tutorial
Welcome to our T-SQL Tutorial for beginners and everyone else. Let me warn you at the beginning that this tutorial is different comparing to most T-SQL Tutorials. Most of the articles you will find here will be very short and describe specific query (question). So in here we won't be focusing on explaining T-SQL (at least not yet) but we will focus on giving you practical examples for common queries or things that you should commonly use
ssrs interview questions
SQL Server Reporting Services skills are required in more and more IT Developer Jobs so if you need to interview someone with SSRS skills and you do not know much about the tool itself than it is worth knowing what are good SSRS Interview questions and answers. Currently I just prepared not very structured questions but later on I will try to structure them so you can ask basic junior questions for junior positions and senior questions for senior positions. These are Developer related question and are not so much applicable for DBA roles and they are not necessarily commonly asked questions.
ssis interview questions
If you need to interview someone with SSIS skills and you do not know much about the tool itself than it is worth knowing what are good SSIS Interview questions and answers to ask. Currently I just put questions and answers but later on I will try to structure them so you can ask basic junior questions for junior positions and senior questions for senior positions.
SQL Server Denali Release Date
Microsoft SQL Server Denali official Release Date is currently (May 2011) not known but CTP1 (open beta testing v1) has been released in November 2010 and CTP2 is expected to be released soon (June 2011?). Therefore we might expect that the final version will be released before end of 2011. I will update this blog with true / final release date when it is made public by Microsoft.
Create ssis package
If you are new to SSIS and would like to create your first SSIS package then below is a simple example with step by step instructions which will show you how to create an SSIS package in bids. I will use SQL Server Integration Services 2008 R2 and Visual Studio 2008 (instructions should be very similar for 2008 and 2005). This tutorial is for beginners and will not be following best practise which includes using variables and package configuration. At the end of tutorial I will post extra materials (once I create them) which will include best practise and package deployment.
My forte are SQL Server Reporting Services enhanced with PROPER Data Visualization, Integration and Analysis Services enhanced with Kimball Data Warehouse Designs, T-SQL Querying/Programming and MDX querying.
Please click the following link for more information about Business Intelligence or SQL Server Business Intelligence
My aim is to be like SQL Server: reliable, efficent and affordable. Apart from behaving like computer software I enjoy analysing data, solving "problems" and efficiently visualize data based on the key factor...purpose. I decided to be SQL BI contractor because it fits me life style... It is dynamic, challenging and results focused; which is what I enjoy most. Check it out also for create ssis package and T-SQL Tutorial
Source: ArticleTrader.com
No comments:
Post a Comment