About Brumedishetty

I work as a SQL Server DBA. Look at the About Me page for more info

How to assign Server Admin role for a user in SSAS

In this blog we shall look at the steps to add a user into the Server Administrators Role in SQL Server Analysis Services (SSAS). Let’s get started..

Connect to the SQL Server Analysis Services from Management Studio (SSMS), once connected, right click on Analysis Server (as shown below) and select Properties. ssas-1Once you click Properties, the Analysis Services Properties dialog box appears, then click Security page, to show the list of users who are currently Server administrators (shown below)..ssas-2 Click on Add button and type the name of the user and click OK button.ssas-3 The user is now part of the Server Administrator group on the Analysis Server now.. To cross check click on the Security page on the Server Properties.ssas-4Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

How to find the Table which has Maximum Columns in a database

If you are interested to know about the table (in a particular database) that has most number of columns and how many columns.. You can run the below script..

SELECT NAME AS Table_Name, max_column_id_used AS Total_Columns
From SYS.tables
WHERE max_column_id_used =
(SELECT MAX(max_column_id_used) FROM SYS.tables)

As shown in the below screen shot, it will list the table and the number of columns in that table..

Table_with_Max_Columns

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

Download SQL Server 2012 Service Pack 1

Last week Microsoft released Service Pack 1 for Microsoft SQL Server 2012. If you have been waiting for the Service Pack 1 to be released, to apply on your existing SQL Server 2012 installations, then go ahead and download the Service Pack 1 from Microsoft Download Center link http://www.microsoft.com/en-us/download/details.aspx?id=35575.

As with all Service Packs for SQL Server, this Service pack can also be applied to all the editions of SQL Server 2012.. If you would like to know more about what are the new features that this SP1 brings to SQL Server 2012, read them here in the following link http://msdn.microsoft.com/en-us/library/bb500435. Look for the section New or Enhanced features in SQL Server 2012 SP1..

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty