Skip to content
February 6, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Amit Karkhanis

SQL Server

SQL Server: Select Star From Cube

August 31, 2011August 28, 2014 - by Amit Karkhanis - 1 Comment

Select * from Cube (SQL? No, its MDX)            Everybody knows that to query the data from an OLTP database, we use SQL. Similarly, to query the data from an OLAP …

SQL Server: Select Star From Cube Read More
SQL Server

Implementing Calculations in SSAS using MDX – Part 3

June 29, 2011November 27, 2014 - by Amit Karkhanis - 8 Comments.

In this ending part of the tri series posts let’s check out the third option in the calculations tab which is “Script Commands”. Here, I am focusing on the SCOPE statement …

Implementing Calculations in SSAS using MDX – Part 3 Read More
SQL Server

SQL Server: Adding Custom Reports in SQL Server 2005 Performance Dashboard

June 21, 2011November 27, 2014 - by Amit Karkhanis - Leave a Comment

This article is an extension to the blog entry “SQL Server 2005 Performance Dashboard Reports” by Rakesh. In his blog, Rakesh introduces to you about an add-in which contains a set …

SQL Server: Adding Custom Reports in SQL Server 2005 Performance Dashboard Read More
SQL Server

Implementing Calculations in SSAS using MDX – Part 2

June 17, 2011November 17, 2014 - by Amit Karkhanis - Leave a Comment

In the Part I of this series we have seen how to create a calculated member using MDX expression. In this part, I am going to show the second option in …

Implementing Calculations in SSAS using MDX – Part 2 Read More
SQL Server

Implementing Calculations in SSAS using MDX – Part1

June 10, 2011November 17, 2014 - by Amit Karkhanis - 3 Comments.

Calculations in Analysis Services help to extend the cube capabilities to make the BI applications more powerful. A calculation is nothing but an MDX expression or script which is used to …

Implementing Calculations in SSAS using MDX – Part1 Read More
SQL Server

Using SQL Server Reporting Services to Manage Data

June 6, 2011December 18, 2014 - by Amit Karkhanis - 7 Comments.

As everyone knows, SQL Server Reporting Services (SSRS) is a reporting tool like Crystal reports, the use of which is to design and deploy various kinds of reports. If I ask …

Using SQL Server Reporting Services to Manage Data Read More
SQL Server

How to handle dynamic column report in SSRS

May 27, 2011December 18, 2014 - by Amit Karkhanis - 6 Comments.

Problem I want to have a cross-tab report in SSRS whose columns may very depending upon the parameter values. We will check how this can be designed in SSRS. Solution Consider …

How to handle dynamic column report in SSRS Read More
SQL Server

SSAS Attribute Relationships Tab

May 6, 2011December 18, 2014 - by Amit Karkhanis - 3 Comments.

SSAS 2008 dimension designer has introduced one more tab called “AttributeRelationships” to simplify the process of setting relationships between the attributes. This tab is used to add, modify or delete attribute …

SSAS Attribute Relationships Tab Read More
SQL Server

Keyboard Shortcuts in SQL Server Management Studio

April 25, 2011December 18, 2014 - by Amit Karkhanis - 3 Comments.

Hi Friends, Reading Amit Bansal’s tips on SQL Server Management Studio, I also remembered the old days when we used to do such small tweaking to automate some of the tasks …

Keyboard Shortcuts in SQL Server Management Studio Read More
SQL Server

SQL Server – History of Business Intelligence (BI)

April 21, 2011December 18, 2014 - by Amit Karkhanis - 2 Comments.

Since the past few years the word “BI” gained lots of importance. Many products got evolved and started supporting the various features of BI. The term has been defined by many …

SQL Server – History of Business Intelligence (BI) Read More

Posts navigation

Previous 1 2 3 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.