T-SQL/MSBI Knowledge Share

Some important links and articles

Enabling Mixed Mode Authentication on SQL Server after installed with Windows Authenication Mode
http://www.dekho.com.au/enabling-mixed-mode-authentication-on-sql-server-after-installed-with-windows-authenication-mode/

How to Identify Currently Used SQL Server Authentication Mode
http://www.mytechmantra.com/LearnSQLServer/SQL_Server_Authentication_Mode_P1.html

Connecting to an XLSX using SSIS
http://dataintegrity.wordpress.com/2009/10/16/xlsx/

SQL SERVER – 2008 – Step By Step Installation Guide With Images
http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

SSAS Tutorial: SQL Server 2008 Analysis Services Tutorial
http://www.accelebrate.com/sql_training/ssas_2008_tutorial.htm

Five Basic Steps for Implementing an Analysis Services Database
https://www.simple-talk.com/sql/reporting-services/five-basic-steps-for-implementing-an-analysis-services-database/

Adding a KPI to an SQL Server Analysis Services Cube
https://www.simple-talk.com/sql/reporting-services/adding-a-kpi-to-an-sql-server-analysis-services-cube/

Katie and Emil - BI with Microsoft
http://www.katieandemil.com/

Learn Data Modelling with real time example
http://www.databaseanswers.org/downloads/Data_Modeling_by_Example_Vol_1.pdf
http://www.databaseanswers.org/downloads/Chapter_1_Data_Modelling_at_Windsor_Castle.pdf

Newer Post Older Post Home

Author

Sreehari Katageri
View my complete profile

Data Warehouse Topics

  • Understanding Data Warehouse
  • Basic Data Warehouse Concepts
  • Types of Dimensions

T-SQL Topics

  • Database Overview
  • Key Constraints
  • Normalization
  • Joins & SELECT Sequence
  • Examples on T-SQL Joins
  • Tricky Join Examples
  • Truncate and Delete
  • Group By/Distinct/Count
  • Incremental loads and updates
  • Delete duplicate records
  • Temp table,Table variable,CTE
  • Sub Query
  • Basic Ranking function
  • Indexed Views
  • Clustered/Non-Clustered Index (Key Lookup/ Book Mark Lookup and RID Lookup)
  • T-SQL Miscellaneous 1
  • T-SQL Miscellaneous 2
  • T- SQL Miscellaneous 3
  • T-SQL Miscellaneous 4
  • T-SQL Miscellaneous 5
  • Maximum value from the multiple columns
  • Table Valued Parameter (TVP)
  • Row level security implementation
  • TSQL/MSBI Youtube Links
  • Resume Format
  • SQL Reference link

Some important SQL/MSBI links and articles

  • MSBI Knowledge Share
  • Important SQL/MSBI links

Total Blog views

Followers

Google Search

Powered by Blogger.