Microsoft Technology

DMV Queries: To Get All Attributes in a cube

noreply@blogger.com (Babu Akkandi) — Mon, 27 Jun 2016 08:14:00 +0000

Use below Dynamic Management View (DMV) queries to get all the dimension and attributes of your cube

SELECT

[CATALOG_NAME] as [Database],

CUBE_NAME AS [Cube],

[DIMENSION_UNIQUE_NAME] AS [Dimension],

HIERARCHY_DISPLAY_FOLDER AS [FOLDER],

HIERARCHY_CAPTION AS [DIMENSION ATTRIBUTE],

HIERARCHY_IS_VISIBLE AS [VISIBLE]

FROM

$system.MDSchema_hierarchies

WHERE

CUBE_NAME ='My Cube Name' AND

HIERARCHY_ORIGIN=2

ORDER BY

[DIMENSION_UNIQUE_NAME]

Note: Replace 'My Cube Name' with your cube name

Fix: Unable to create the type with the name 'SPCRED'

noreply@blogger.com (Babu Akkandi) — Wed, 22 Jun 2016 13:48:00 +0000

Problem:

I tried to export one of the SSIS packages from Integration Services catalog. I got the below error

"Unable to create the type with the name 'SPCRED'. (Microsoft.SqlServer.ManagedDTS)"

Solution:

When I explore this issue, found that the package extracts data from SharePoint list. but we don't have inbuilt component in SSIS to fetch the data from SharePoint. So We need to use third party connecter which is exists in CodePlex "SharePoint List Source and Destination"

after Install this connector, I can export the SSIS packages from Integration Services catalog without any issues.

Also, you can see this connector added in SSIS connection Manger

Note:

If it is not appeared in connection manager then you've to restart your Visual studio if it opened
If not appeared in connection Manager after restart your VS, then the version you installed is not compatible with your VS, so choose the Proper version and install it.

Introducing JSON for SQL Server 2016

noreply@blogger.com (Babu Akkandi) — Tue, 08 Sep 2015 07:31:00 +0000

Problem

On my current project, there is a requirement to extract data, which is stored in one database (D1) and load it into another database (D2). That should be simple, right? But, the client is not ready to give access to the D2 database due to confidential data. We have to push data to the D2 database via the REST API which accepts JSON as an input. We are trying to find an option to convert the data into JSON format at the database level. Unfortunately, SQL Server does not support converting data into JSON format. To resolve this issue, we developed a .NET utility to convert the data to JSON format with the help of the “JavaScriptSerializer” class then pushed the data to the D2 database via REST API I see SQL Server 2016 now supports JSON. Is it possible to replace our .NET utility? In this tip, we will demonstrate how use JSON in SQL Server 2016.

Solution

JSON support in SQL Server is one of the highly ranked requests in Connect #673824, which received 1000+ votes.

What is JSON?

To Continue Reading >> Please Refer My Articles at MsSQLTips.com

SQL 2016 - Skip Prompting Save

noreply@blogger.com (Babu Akkandi) — Wed, 29 Jul 2015 13:21:00 +0000

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 opens "N" number of Query windows and continue our activities in SSMS. We may not required to keep/save the scripts, but when we close the windows we will get as many number of prompts for save/cancel the changes. also you will be forced to click each and every annoying save prompts.

Solution:

This Problem is resolved in SSMS 2016 release.

Microsoft has provided a new option to avoid prompting for saving unsaved files.

To use this feature, Go to "Tools" Menu > Options > Query Execution > SQL Server > General > Un-check "Prompt to save unsaved T-SQL query windows on close"

Note:

You have to disable this option before open any query window, otherwise SSMS will prompt the save changes window at the time of closing

Warning:

Do not disable this option, if you do, you may lose valid scripts one day if you forget to save the changes when you close any script accidentally. so don't forget to enable this option after use.

Requested By:

A connect item was raised to add this feature by Erland Sommarskog, Refer

Connect #308372, which replaced Connect #124686. It was denied by Microsoft earlier and closed the ticket stating as "Won't Fix", But due to Many People requests, Now Microsoft has introduced this feature in SQL 2016

SQL 2016 - Automatic Check for Updates

noreply@blogger.com (Babu Akkandi) — Wed, 29 Jul 2015 12:13:00 +0000

SQL SERVER 2016 - Automatic Check for Updates (New Features in SSMS)

Now you can upgrade your SQL server with latest updates via SSMS 2016 as well, This feature is introduced in SQL 2016 CTP version.

If any updates are available for SQL Server 2016, you will be notified automatically via a Taskbar notification as shown below

If you click on the notification then you can see list of updates as below in SSMS Interface

Even you can manually check the updates in SSMS by click on Tools Menu, Select "Check For Updates..." to see if there are any updates available.

SQL 2016 - Rule "Oracle JRE 7 Update 51 (64-bit) or higher is required" failed.

noreply@blogger.com (Babu Akkandi) — Wed, 29 Jul 2015 11:15:00 +0000

Problem
Today I was trying to install SQL 2016 CTP2.2 in my system. After selected all the feature, I faced the below error while validating the feature rules.

Rule: Oracle JRE 7 Update 51 (64-bit) or higher is required
Error: I clicked on the Failed Link and got the detailed error as below

Rule Check Result

Rule "Oracle JRE 7 Update 51 (64-bit) or higher is required" failed.

This computer does not have the Oracle Java SE Runtime Environment Version 7 Update 51 (64-bit) or higher installed. The Oracle Java SE Runtime Environment is software provided by a third party. Microsoft grants you no rights for such third-party software. You are responsible for and must separately locate, read and accept applicable third-party license terms. To continue, download the Oracle SE Java Runtime Environment from http://go.microsoft.com/fwlink/?LinkId=526030.

Cause
I bit surprised why Microsoft product requires Oracle JRE!!

After little Analysis, Found that, To add the PolyBase functionality, we should have JRE version 7u51 or higher in our system

Solution 1:
If you do not require PolyBase then go back to previous page Un check the Polybase feature, then continue the installation

Solution 2:
If require Polybase then follow the below step to Download JRE

Step1:
Go to link "http://go.microsoft.com/fwlink/?LinkId=526030" given in error page which will redirect to ("http://www.oracle.com/technetwork/java/javase/downloads/index.html")

Step2: Click on "Download" button which is under JRE (Right Side)

Step3: To Download, you must accept the Oracle Binary Code License Agreement, So Click on "Accept License Agreement"

Step4: Download JRE based on OS Architecture

Step5: Install it

Post Installation of JRE 7u51 or higher version, re-run the feature Rule validation, you will see the rule status as "Passed", then you can continue the installation.

Hope This Helps!

SQL - Get Procedure/Function/Trigger Name

noreply@blogger.com (Babu Akkandi) — Tue, 14 Jul 2015 13:04:00 +0000

Problem:
When I write any procedure for UI functionality, I may require to throw the Procedure Name to UI if any error occurs, This will help people to identify/Isolate the bug if occured
Also I Dont want to hard code the procedure name in the SPs because sometime I/someone may change the SP Name in future.
How can I prevent such a basic mistake as well as use a consistent process?

Solution:
SQL Server has a function called @@PROCID, If you use this function inside of any procedure/function/trigger, then it will return the objectid that currently running. below snippets will help you how to use this function.

Sample SP:
Create Procedure Procedure1
As
DECLARE @ProcName sysname
SET @ProcName = QUOTENAME(OBJECT_SCHEMA_NAME(@@PROCID)) +'.'+QUOTENAME(OBJECT_NAME(@@PROCID))
SELECT @ProcName

Execute SP:

Exec Procedure1

Output:
[dbo].[Procedure1]
@@PROCID Function is available from SQL 2000 onwards. This Function return Object ID, use OBJECT_NAME Function to get the Name of the Object as mentioned in the script given above.

Next Steps:
Refer the below documentation to understand complete functionality of this function as well as how to use it in different ways

MSDN: @@PROCID (Transact-SQL)
TechNet: @@PROCID

SSIS Lookup Transformation - Handle Case Sensitive Issue

noreply@blogger.com (Babu Akkandi) — Fri, 10 Jul 2015 18:56:00 +0000

Problem:
I have a lookup transformation in one of my SSIS packages, used it to get ID of an employee record in a dimension table. However my problem is that some of the source data has employee names in Different case, which is not matching with the Case that Stored in the Dimension Table.

For Example:
Source Table Employee Name is "KUmar", but in the Dimension table, It is Stored as "Kumar"

The Lookup is failing for this Scenario wherever the case of the Employee Name are not similar

So, How can I get rid of this issue, Is there a way to make a lookup transformation ignore case?

Solution:

There is No option to change the transformation be case-insensitive directly. But We can handle this issue in two ways:

Option 1: If the data need not to lookup based on the case Then Convert both in to similar (UPPER (Or) lower) case before do the Lookup. This will not omit any records, you will get matched records for all

Option 2: Set the CacheType property to Handle the case Issue.

Full Cache: This option is case sensitive by default.
Partial and No-cache: This option uses the Collation setting of the database (or table) to handle case.

Set the CacheType property as Partial or None, Now row by row comparisons will be taken care by SQL Server and not by the SSIS lookup component.

Hope This Helps!

SQL - Get Current, Previous & Next Quarter

noreply@blogger.com (Babu Akkandi) — Thu, 09 Jul 2015 12:25:00 +0000

The below SQL script will help you to find, First & Last Date of the Current/Previous/Next Quarter based on the current Date.

--To get the first day of the previous quarter

SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) - 1, 0) As Previous_Quarter_FirstDay

--To get the last day of the previous quarter:

SELECT DATEADD(dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()), 0)) As Previous_Quarter_LastDay

--To get the first day of the current quarter:

SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()), 0) As Current_Quarter_FirstDay

--To get the last day of the current quarter:

SELECT DATEADD (dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) +1, 0)) As Current_Quarter_LastDay

--To get the first day of the next quarter:

SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) + 1, 0) As Next_Quarter_FirstDay

--To get the last day of the next quarter:

SELECT DATEADD (dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) +2, 0)) As Next_Quarter_LastDay

If you need to find Quarter and previous quarter for any specific date, Then Replace GETDATE() with the date.
Hope This Helps!

CTRL + R Issue in SSMS

noreply@blogger.com (Babu Akkandi) — Wed, 08 Jul 2015 12:40:00 +0000

Problem

I often use CTRL+R key to hide/show the result window, also use F7 & F8 keys to view the Object Explorer Details, Recently it stopped working after Microsoft windows Updates.

Whenever I hit "CTRL+R", The status bar says..."(Ctrl+R) was pressed. Waiting for the second key of chord..." as shown in the exhibit below

After followed below steps, the Key Functionalities are re-enabled

Solution

In SQL Server Management Studio,

1. Open the Tools menu,Options...

2. Under the Environment node click on the Keyboard node

3. Click the Reset button

4. Click Yes on the dialog that pops up

This step will solve your issue. Hope This Help!

SQL Server Management Studio Query Designer Shortcuts

noreply@blogger.com (Babu Akkandi) — Wed, 24 Jun 2015 07:46:00 +0000

Problem

While writing and editing scripts, we often try to use the keyboard as much as possible. This should be the same for SQL Server scripts as well. When using the Query Designer in SSMS there are some shortcuts that will help you be more efficient and in this tip we will take a look at a few of these shortcuts.

Solution

As you know, shortcut keys play a vital role. A shortcut is a key or combination of keys assigned to perform an operation.

The best and familiar shortcut keys are:

Save (CTRL + S) or (ALT + F + S)
Copy (CTRL + C)
Paste (CTRL + V)
Cut (CTRL + X)
Undo (CTRL + Z)
Redo (CTRL + Y)

These are all familiar shortcuts keys which are common and standard across most of the modern operating systems and associated applications to perform the same activities.

In this tip, we will look at a couple of shortcut keys to work with the "Query Designer" editor in SSMS.

To Continue Reading >> Please Refer My Articles at MsSQLTips.com

Azure DB Backup/Restore Via SSMS 2014

noreply@blogger.com (Babu Akkandi) — Tue, 16 Jun 2015 10:04:00 +0000

This topic will provide details(on high level) of new features introduced in SQL Server 2014 Management Studio (SSMS) to Manage Azure Databases.

Enhanced Backup:SQL Server 2014 provides new Windows Azure integration to SQL Server's backup capabilities. You can specify a Windows Azure URL as the target for your SQL Server 2014 database backups. This new Windows Azure backup feature is fully integrated into SSMS.

In Backup Interface, you will see additional Option called "URL" as shown in the exhibit below,This option will backup the data on azure(cloud),

Select "URL" as "Back up to" and provide the azure connection and file details to backup the data on azure.

Enhanced Restore: Same with the restores, you can choose URL as your Source…and provide the details accordingly as shown below.

Select "URL" and Click on "Add" Button

This backup and restore functionality are same or similar to when using DISK or TAPE, with a few differences.

Hope This Helps!

Deprecated/Discontinued DBEngine Features in SQL Server 2014

noreply@blogger.com (Babu Akkandi) — Mon, 15 Jun 2015 10:54:00 +0000

As we all aware, each and every new release of any software, we might expect changes in the release like, new features, update/upgrade on the existing features, outdated features due to compatibilities or alternate options.

The below link provides the list of the features and functionality that Microsoft is dropping from SQL Server 2014,

Deprecated Database Engine Features in SQL Server 2014

Discontinued Database Engine Functionality in SQL Server 2014

SQL Server 2016 CTP 2

noreply@blogger.com (Babu Akkandi) — Wed, 10 Jun 2015 08:32:00 +0000

Microsoft has released the first public preview of SQL Server 2016 Community Technology Preview 2. This version delivered with faster transactions and queries, deeper insights on any device, advanced analytics, new security technology, and new hybrid cloud scenarios, etc., Also find the other benefits below,

Benefits:

Enhanced in-memory performance provide up to 30x faster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics
New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes
Built-in advanced analytics– provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database
Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android
Simplify management of relational and non-relational data with ability to query both through standard T-SQL using PolyBase technology
Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes
Faster hybrid backups, high availability and disaster recovery scenarios to backup and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure

Video:

SQL Server evolution: new innovations

Download SQL 2016 WhitePaper:

Mission Critical technical white paper

In-memory OLTP technical white paper

In-memory OLTP and Columnstore Feature Comparison

Deeper Insights Across Data technical white paper

Hyper-scale Cloud technical white paper

To Know More about it, Please check the link below

http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/

Visual Studio and Team Foundation Server 2015 - RC

noreply@blogger.com (Babu Akkandi) — Tue, 05 May 2015 06:37:00 +0000

Recently Microsoft released RC for VS2015 and TFS 2015, Refer the links below for more details:

Download Visual Studio and Team Foundation Server 2015 RC
VM of Visual Studio 2015 RC in Azure
Visual Studio 2015 RC Release notes
TFS 2015 RC Release notes
Visual Studio 2015 RC KB Article
TFS 2015 RC KB Article

To Lists all the Databases by SQL

noreply@blogger.com (Babu Akkandi) — Wed, 14 May 2014 19:49:00 +0000

How can I view the List of databases that available in a SQL server instance via query?

There are many ways to see all the databases, here i've listed 3 types

1. master..sysdatabases - system table added as view for backward compatabilty

2. sys.databases - view available in master & user databases. minimum permission is enough to view the output

3. sp_databases - Inbuilt stored Procedure, to fetch DB lists.
Requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY DEFINITION permission, and must have access permission to the database. Cannot be denied VIEW ANY DEFINITION permission. everyone can not access this SP, if you dont have permission, then you will see blank rows.

USE master;
GO

SELECT Name FROM master..sysdatabases  

SELECT * from sys.databases

EXEC sp_databases;

Sample Output:

SSRS: Deserialization failed: The 'DataType' attribute is not declared

noreply@blogger.com (Babu Akkandi) — Mon, 12 May 2014 06:22:00 +0000

Problem:
Today, We have downloaded a report from Report Manager, If try to open that in Visual Studio IDE, it throws error as "Deserialization failed: The 'DataType' attribute is not declared. Line 1279, position 20.". (refer the exhibit below)

Cause:
When I reviewed the code (By Click Edit code or View code), I found that DataType attribute was not recognized by report render engine. so I guess DataType was an attribute of report element and it has introduced by VS2008 IDE, this has not been corrected and performing some action in the report designer while add the DataType attribute which is not allowed in the schema.

Solution:
To fix this issue, I have replaced the DataType with blank as mentioned in the screenshot below

after replaced it, when I check the report via designer, it render the report content properly.

Note:
I faced this issues with float datatype, you may experience with anyother datatype like Integer, Strings, Date, etc., you can follow the same approach. Note that, before try this approach, backup your report to avoid any surprises and then try this. Hope this may helps you!

Table Modified/Updated Details

noreply@blogger.com (Babu Akkandi) — Tue, 11 Mar 2014 08:28:00 +0000

Scripts to find when Last transactions are done in a table:

SELECT
      last_user_update
FROM
      sys.dm_db_index_usage_stats
WHERE
      object_id=object_id('TableName')

Scripts to find when the table's Schema are changed last:

SELECT
      name as Table_Name,
      [modify_date]
FROM
      sys.tables

Cannot login to SSAS 2008 from SSMS?

noreply@blogger.com (Babu Akkandi) — Mon, 10 Mar 2014 07:10:00 +0000

Issue:
When I tried to connect to a named instance of SQL Server 2008 Analysis Services (SSAS) by using SQL Server Management Studio, I received the following error message intermittently:

The 'InstanceName' instance was not found on the 'ServerName' server. (Microsoft.AnalysisServices.AdomdClient)

Solution:
When I checked my services all the services was up & running, even I had restarted my SSAS services, but it didn't help me. but the issue was resolved after restart the SQL Server Browser service.

If you aware, how to to restart any windows services that related SQL server then Ignore the steps below:

Steps to Restart "SQL Server Browser" service:
1.On the Start menu, right-click My Computer, and then click Manage.
2.In Computer Management, expand Services and Applications, and then click Services.
3.In the list of services, double-click SQL Server Browser.
4.In the SQL Server Browser Properties window, click Start or Stop.
5.When the service starts or stops, click OK.

After restarting the "SQL Server Browser" service, I tried to connect SSAS via SSMS, it works. Hope it may help you.

SQL Server 2014 CTP1

noreply@blogger.com (Babu Akkandi) — Tue, 20 Aug 2013 10:03:00 +0000

Microsoft has released SQL Server 2014 CTP1 Product Guide. This product guide release represents a significant milestone for customers and partners who want to experience the extensive new value delivered by SQL Server 2014 CTP1.

Download the datasheets, white papers and technical presentations from,
http://www.microsoft.com/en-us/download/details.aspx?id=39269

This will help you evaluate Microsoft SQL Server 2014 CTP1.

How To: Lists Linked Server

noreply@blogger.com (Babu Akkandi) — Fri, 15 Feb 2013 12:37:00 +0000

The following Stored procedure will returns the list of linked servers defined in the server in which we are executing it.

sp_linkedservers

This procedure will return the following informations about the linked server

Column name	Data type	Description
SRV_NAME	sysname	Name of the linked server.
SRV_PROVIDERNAME	nvarchar(128)	Friendly name of the OLE DB provider managing access to the specified linked server.
SRV_PRODUCT	nvarchar(128)	Product name of the linked server.
SRV_DATASOURCE	nvarchar(4000)	OLE DB data source property corresponding to the specified linked server.
SRV_PROVIDERSTRING	nvarchar(4000)	OLE DB provider string property corresponding to the linked server.
SRV_LOCATION	nvarchar(4000)	OLE DB location property corresponding to the specified linked server.
SRV_CAT	sysname	OLE DB catalog property corresponding to the specified linked server.

Or... you can use following SQL Scripts to lists all linked servers

select * from master..sysservers

Hope this helps!

Lists All SSRS Reports & Datasources

noreply@blogger.com (Babu Akkandi) — Fri, 15 Feb 2013 11:48:00 +0000

The following SQL Scripts helps you to list out all the reports with associated Data-sources which are all deployed at Microsoft Reporting server(SSRS)

Use ReportServer

SELECT

Catalog.Name AS ReportName,

Catalog.path AS Report_Location,

DataSource.Name AS DataSourceName

FROM

[Catalog] INNER JOIN DataSource

ON Catalog.ItemID = DataSource.ItemID

order by Catalog.path

Hope this Helps!

SSIS Excel Connection Manager Error

noreply@blogger.com (Babu Akkandi) — Wed, 13 Feb 2013 11:27:00 +0000

Problem:

I've created a simple package to fetch the data from SQL Server to pupulate the Excel file using Excel Destination SSIS Component, when I tried to Execute, it throwed below error

Error: 0xC020801C at Data Flow Task, Excel Source [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Solution:

This issue is occurred because my system has 64 bit OS and Office Excel object. most of the office products does not have 64bit provider and hence the error above on Excel connection. This Issue can be fixed by setting Run64BitRunTime property as False at SSIS Project properties.

Go to properties page for the overall SSIS solution, simply set the Run64BitRunTime = False.

Refer the screenshot below for the further reference

SSIS: OLEDB.12.0 provider is not registered

noreply@blogger.com (Babu Akkandi) — Wed, 13 Feb 2013 09:40:00 +0000

Problem:

Today I tried to develop a simple SSIS package to populate the data to excel file using Excel Destination of SSIS components, but It throws the below error when I select excel sheet in Excel Destination Editor.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Solution:

This issue is resolved by installing 2007 Office System Driver: Data Connectivity Components

To install this download:

Download the file by clicking the "Data Connectivity Components" link (above) and saving the file to your hard disk.
Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
Follow the instructions on the screen to complete the installation.

Hope this helps!

E-Book Gallery for Microsoft Technologies

noreply@blogger.com (Babu Akkandi) — Mon, 23 Jul 2012 06:15:00 +0000

You can download existing and new content for ASP.NET, Office, SQL Server, Windows Azure, SharePoint Server and other Microsoft technologies in e-book formats. Reference, guide, and step-by-step information are all available. All the e-books are free

E-Books in English

ASP.NET	Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio Getting Started with ASP.NET 4.5 Web Forms (Beta) Intro to ASP.NET MVC 4 with Visual Studio (Beta)
Office	First Look: Microsoft Office 2010 Microsoft Office 365: Connect and Collaborate Virtually Anywhere, Anytime Security and Privacy for Microsoft Office 2010 Users
SharePoint	Configure Kerberos Authentication for SharePoint 2010 Products Get started with SharePoint Server 2010 Deployment guide for SharePoint Server 2010 Upgrading to SharePoint Server 2010 Profile synchronization guide for SharePoint Server 2010 Remote BLOB storage for Microsoft SharePoint Server 2010 Governance guide for Microsoft SharePoint Server 2010 Business continuity management for SharePoint Server 2010 Technical reference for Microsoft SharePoint Server 2010
SQL Server	Books Online: Transact-SQL Data Manipulation Language (DML) Reference Introducing Microsoft SQL Server 2008 R2 Introducing Microsoft SQL Server 2012 Master Data Services Capacity Guidelines Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide QuickStart: Learn DAX Basics in 30 Minutes SQL Server 2012 Tutorials: Analysis Services - Data Mining SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling
Visual Studio	Moving to Microsoft Visual Studio 2010
Windows	Deploying Windows 7: Essential Guidance Programming Windows 8 Apps with HTML, CSS, and JavaScript (First Preview)
Windows Azure	Windows Azure Prescriptive Guidance Windows Azure Service Bus Reference
Windows Phone	Programming Windows Phone 7
Windows Server	Introducing Windows Server 2008 R2 Introducing Windows Server 2012 (Based on Beta) Understanding Microsoft Virtualization Solutions: From the Desktop to the Datacenter, Second Edition
Career	Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft

Happy Learning J