SQL Script to get list of linked server on SQL Server

Reference: This is awesome script to get list of linked server on SQL server.

SELECT ss.server_id 
          ,'Server ' = Case ss.Server_id 
                            when 0 then 'Current Server' 
                            else 'Remote Server' 
          ,'Local Login ' = case sl.uses_self_credential 
                            when 1 then 'Uses Self Credentials' 
                            else ssp.name 
           ,'Remote Login Name' = sl.remote_name 
           ,'RPC Out Enabled'    = case ss.is_rpc_out_enabled 
                                   when 1 then 'True' 
                                   else 'False' 
           ,'Data Access Enabled' = case ss.is_data_access_enabled 
                                    when 1 then 'True' 
                                    else 'False' 
      FROM sys.Servers ss 
 LEFT JOIN sys.linked_logins sl 
        ON ss.server_id = sl.server_id 
 LEFT JOIN sys.server_principals ssp 
        ON ssp.principal_id = sl.local_principal_id

SSAS Mining Structure Data Types

Microsoft Reference

When we create a mining model or a mining structure in Microsoft SQL Server Analysis Services, we must define the data types for each of the columns in the mining structure. The data type tells the analysis engine whether the data in the data source is numerical or text, and how the data should be processed. For example, if our source data contains numerical data, we can specify whether the numbers be treated as integers or by using decimal places.

Analysis Services supports the following data types for mining structure columns:

Data Type Supported Content Types
Text Cyclical, Discrete, Discretized, Key Sequence, Ordered, Sequence
Long Continuous, Cyclical, Discrete, Discretized, Key, Key Sequence, Key Time, Ordered, Sequence, Time


Boolean Cyclical, Discrete, Ordered
Double Continuous, Cyclical, Discrete, Discretized, Key, Key Sequence, Key Time, Ordered, Sequence, Time


Date Continuous, Cyclical, Discrete, Discretized, Key, Key Sequence, Key Time, Ordered

You can find details for discrete vs discretized here.

Power BI Report Server on premise version build release info

Microsoft Power BI Reference

  • Power BI Report Server
    • Version 1.1.6582.41691 (Build 14.0.600.442), Released: January 10, 2018
      • Security Updates
      • Bug Fixes
        • Fix for Model.GetParameters returning 400
        • Fix for setting shared data set to existing Paginated Reports (RDL)
        • Fix for ExecutionNotFoundException when exporting report with different parameter values to PDF
    • Version 1.1.6551.5155 (Build 14.0.600.438), Released: December 11, 2017
      • Bug Fixes
        • Failure to save data after refreshing for certain Power BI Desktop reports.
    • Version 1.1.6530.30789 (Build 14.0.600.437), Released: November 17, 2017
      • Bug Fixes
        • Fix for Basic Authentication Scenarios
        • Fix for weekdays were not selectable on schedule page for Subscriptions, Cache Refresh Plans and History Snapshots on Portal
        • For Paginated Reports (RDL), fix for having expressions in Textbox with CanGrow property set to false is resulting in values not showing colors and fonts not being proper
        • For Power BI Reports (PBIX), fix for adding Legends to line chart renders an empty visual
    • Version 1.1.6514.9163 (Build 14.0.600.434), Released: November 1, 2017
      • Bug Fixes
        • Fix for upload reliability problems for PBIX reports over 500MB
        • Fix for data loading issue for PBIX reports over 1GB
    • Version 1.1.6513.3500 (Build 14.0.600.433), Released: October 31, 2017
      • Features
        • Embedded Data Model Support
        • Excel Workbook Viewing (with Office Online Server integration enabled)
        • Scheduled Data Refresh (PBIX)
        • Direct Query Support
        • Large File Support (up to 2 GB)
        • Public REST API
        • Shared Dataset support in Power BI Desktop (via oData)
        • URL Parameter Support for PBIX files
        • Accessibility improvements
  • Power BI Desktop (optimized for Power BI Report Server)
    • Version: 2.51.4885.2501 (October 2017), Released: January 10, 2018
      • Security Updates
    • Version: 2.51.4885.1423 (October 2017), Released: November 17, 2017
      • Bug Fixes
        • Fix for 32-bit Power BI Desktop failing to run on x86 OS
        • For Power BI Reports (PBIX), fix to show x-axis gridlines
        • Other minor bug fixes
    • Version: 2.51.4885.1041 (October 2017), Released: October 31, 2017
      • Features
        • Contains changes required for connection with Power BI Report Server (October 2017)

PeopleSoft Campus Solutions 9.0 Understanding Academic Structure

PeopleSoft Campus Solutions 9.0 – Academic Structure

The academic structure and its elements are the building blocks for an academic institution. This diagram illustrates an institution’s academic structure at a high level:

To set up campuses, use the Campus Table component (CAMPUS_TABLE).

A campus is an entity, usually associated with a separate physical administrative unit, that belongs to a single academic institution, uses the same course catalog, and produces a common transcript for students within the same academic career. The PeopleSoft Campus Solution system enables you to define as many campuses within an academic institution as necessary to meet your business needs.

To set up academic careers, use the Academic Career Table component (ACAD_CAREER_TBL).

Academic career is a concept used in Campus Solutions to designate all course work undertaken by a student at an academic institution; you group this course work in a single student record. For example, a university that has an undergraduate school, a graduate school, and several professional schools can define an undergraduate career, graduate career, and a separate career for each professional school (for example, law, medical or dental). You might also make extended education or continuing education its own academic career, or make separate academic careers for every school or college at the undergraduate level.

Academic careers have these common characteristics:

  • All credit is granted under a common unit type, such as semester hours or quarter hours.
  • A single repeat scheme is used.


In SSRS Report How to hide or collapse detailed rows or sub-grouped rows

In SSRS Report how to show classic pivot like Excel report.

In other words how to hide or collapse detailed rows or sub-grouped rows.

Say we have report which shows Estimated Sales and Actual Sales by State, Region and Country.

We have report without any groups as:

Country  Region  State  Estimated-Sales  Actual-Sales.

In this report we need to create Groups as follows:

Country  => Region  => State.

NOTE: While creating groups you can select for Country Parent group and for remaining Child group.

When by default the SSRS report loads what we want is to hide entire row with Country is collapsed and will show when it is expanded.

Make sure it is Tablix.

Except parent’s group properties, navigate to each of the child’s group properties => Visibility section and DO AS FOLLOWS:

  1. select Hide option.
  2. Check on Display can be toggled by this report item. Please select the PREVIOUS ITEM.



SQL Server profile name is not valid [SQLSTATE 42000] Error 14607

Created first account and then profile for SQL Server Emailing.

I opened SQL management Studio and ran the test script:

EXEC msdb.dbo.sp_send_dbmail @recipients=’abc@xyz.com’, @profile_name = ‘ProfilenameABC’,    @subject = ‘test email ‘,    @body = ‘test email’,    @body_format = ‘HTML’ ;

It worked fine.

But the developer from my team came back saying the job has failed with error:

profile name is not valid [SQLSTATE 42000] Error 14607.

He too is getting the same error.

So then we realized we have to change it security and make it Public.

So in SQL management Studio, navigate to Database mail => Configure Database mail, and select option=> Manage Profile Security.

Making it public profile allows guest access too.