Microsoft Technology
Monday, June 27, 2016
DMV Queries: To Get All Attributes in a cube
›
Use below Dynamic Management View (DMV) queries to get all the dimension and attributes of your cube SELECT [CATALOG_NAME] a...
1 comment:
Wednesday, June 22, 2016
Fix: Unable to create the type with the name 'SPCRED'
›
Problem: I tried to export one of the SSIS packages from Integration Services catalog. I got the below error "Unable to creat...
Tuesday, September 8, 2015
Introducing JSON for SQL Server 2016
›
Problem On my current project, there is a requirement to extract data, which is stored in one database (D1) and load it into another d...
1 comment:
Wednesday, July 29, 2015
SQL 2016 - Skip Prompting Save
›
Problem Sometime we may write a SQL script to verify the data or monitor any activities or adhoc tasks in database. In that case, We open...
1 comment:
SQL 2016 - Automatic Check for Updates
›
SQL SERVER 2016 - Automatic Check for Updates (New Features in SSMS) Now you can upgrade your SQL server with latest updates via SSMS ...
›
Home
View web version
