Khilit's Business Intelligence Blog

My experiences, views, learning, findings and amazing journey of Microsoft BI – SQL Server, SSAS, SSIS, SSRS, MDX, PowerPivot, C#.Net, Excel, SharePoint, VSTS and more.

• Home
• C Tree
• About Me

Fastest way to find-out/understand relationships between tables in MS SQL Database

Hi guys, For most of the BI developers, getting BI related tasks (SSAS, SSIS, SSRS etc.) from multiple teams in company is very common. So in this situation, developer completes a task(s) for one team and goes to another team for different task(s). Once you go to the team for their requirements … lets say [...]

February 3, 2012 · Khilitchandra Prajapati · 2 Comments
Tags: Database Diagram, SQL Server, Visio Â· Posted in: Database Diagram, SQL Server, SQLServerPedia, Tutorial, Visio

Demo Site is ready with full featured “SQL Server 2012 RC0″ to play with

Note: This site requires Windows 7, Windows Vista with SP1/SP2 or Windows XP wth SP3 to have the correct RDP client to use this site. Go to this site http://fs.mssalesdemos.com/, Login with your live ID. Select the “Catalog” tab. Select “New SQL Server 2012-RC0 fully integrated Demo“. The new SQL Server 2012-RC0 demo is fully [...]

February 2, 2012 · Khilitchandra Prajapati · No Comments
Tags: SQL Server 2012, SSAS, SSIS, SSRS, Visio Â· Posted in: Business Intelligence, Quick Tips, SSAS, SSIS, SSRS, Suggestion, Visio

• Blog Stats

  38310 hits

• Recent Posts

  • MDX and DAX Query Formatter …. is back :)
  • Recover Backed-up query files in SQL Server Management Studio
  • Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT
  • The Story of Precision, Scale, and Length in SQL Server
  • Tracking Down Ghost Characters: WHERE Clause Does Not Work Properly In T-SQL Query
  • MSSQL: Find total records of each Table in given Database
  • Microsoft SSAS Solution: Cube Design Considerations
  • User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
  • Quick Introduction – What is FileTable in SQL Server 2012 ?
  • Microsoft Business Intelligence at a Glance Poster – FREE

• Archives

  • May 2013 (2)
  • February 2013 (1)
  • January 2013 (5)
  • December 2012 (2)
  • September 2012 (3)
  • August 2012 (3)
  • June 2012 (5)
  • May 2012 (3)
  • April 2012 (7)
  • March 2012 (12)
  • February 2012 (30)
  • January 2012 (9)

• World Foot-prints

• SQL Server Pedia

  • Retrieving id of inserted record: What to use @@IDENTITY or SCOPE_IDENTITY() or OUTPUT
  • The Story of Precision, Scale, and Length in SQL Server
  • MSSQL: Find total records of each Table in given Database
  • Fastest way to find-out/understand relationships between tables in MS SQL Database

• Author’s Information

  Khilitchandra V. Prajapati
  bigatoron