Microsoft Technology

Isolation Level Of Current Database

noreply@blogger.com (Babu) — Tue, 22 May 2012 05:38:00 +0000

Following SQL Code-snippet will helps to find out What is the Isolation Level is configured for Current Database,

SELECT CASE transaction_isolation_level

WHEN 0 THEN 'Unspecified'

WHEN 1 THEN 'ReadUncomitted'

WHEN 2 THEN 'Readcomitted'

WHEN 3 THEN 'Repeatable'

WHEN 4 THEN 'Serializable'

WHEN 5 THEN 'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL

FROM

sys.dm_exec_sessions

where session_id = @@SPID

The above query will return the Isolation of of current DB. There are many ways to find out this settings.

You can find it out by using DBCC command as well,

DBCC USEROPTIONS

After execute the given DBCC Command, look at the value of "isolation level" in the result, refer the exhibit given below:-

Difference Between SQL Vs. T-SQL?

noreply@blogger.com (Babu) — Mon, 09 Apr 2012 09:53:00 +0000

SQL and T-SQL are Query languages, both helps to extract, Manipulate data with database system.

SQL – Structured Query Language:-

It is pronounced as SEQUEL, stands for… Structured English QUEry Languages.

SQL Language has several language elements called clauses, phrases, predicates, queries and statements.
SQL Supports to insert/update/read/delete the data from/to the database, define the new structure, etc.,
SQL supports different data types like image, text, varchar, datetime,xml, etc., SQL supports only single line transactions

T-SQL – Transact-SQL:-

T-SQL is advanced/addition to the SQL developed by Microsoft. It has new features like, variable, temp tables, set of transactions, store procedures, functions, cursors etc.., T-SQL supports control flow capabilities by using the following commands: START and TERMINATE, break, CONTINUE, GOTO, RETURN, IF, While and WAITFOR. T-SQL allows the ‘FROM’ clause to be added to DELETE and UPDATE statements. T-SQL allows inserting multiple rows using single statement BULK INSERT.

Introducing Microsoft SQL Server 2012 - EBook Download

noreply@blogger.com (Babu) — Fri, 16 Mar 2012 09:14:00 +0000

The full version of "Introducing Microsoft SQL Server 2012" by "Ross Mistry” and “Stacia Misner” is now available for free download,

Download Introducing Microsoft SQL Server 2012

"Introducing Microsoft SQL Server 2012" includes 10 chapters:

PART I - DATABASE ADMINISTRATION (by Ross Mistry)
1. SQL Server 2012 Editions and Engine Enhancements
2. High-Availability and Disaster-Recovery Enhancements
3. Performance and Scalability
4. Security Enhancements
5. Programmability and Beyond-Relational Enhancements

PART II - BUSINESS INTELLIGENCE DEVELOPMENT(by Stacia Misner)
6. Integration Services
7. Data Quality Services
8. Master Data Services
9. Analysis Services and PowerPivot
10.Reporting Services

Download Introducing Microsoft SQL Server 2012

Find Nth Highest Value – With Using Only Aggregate Function

noreply@blogger.com (Babu) — Tue, 13 Mar 2012 06:33:00 +0000

Problem:

Today I came across a SQL Puzzle, “How to Find Nth Highest value without using any Built in ANSI Functions like Top, Rank() , Dense_Rank(), Row_number(), Etc., you can use only aggregate functions like Min, Max and Count ?”

Solution:

The following queries will help you to identify Nth highest value with using Only Aggregate Functions.

Note: I’ve used Sales.SalesOrderDetail Table from adventure Works Database in my script, you can replace the column and table name as per your table structure.

Use AdventureWorks

--- To Find Nth Highest Value, Replace N with Some Number in the given Query, For Example, if you want to find 12th Highest value, Use 12 Instead of "N"

SELECT distinct UnitPrice

FROM Sales.SalesOrderDetail E1

WHERE N =

(

SELECT COUNT(DISTINCT E2.UnitPrice)

FROM Sales.SalesOrderDetail E2

WHERE E2.UnitPrice >= E1.UnitPrice

)

---- following Query will returns distinct values in Descending order, you can refer this Query’s output to verify Nth value of previous query output.

select distinct UnitPrice from Sales.SalesOrderDetail A

order by UnitPrice desc

Hope it Helps!

Download Visual Studio 11 Beta today!

noreply@blogger.com (Babu) — Tue, 13 Mar 2012 03:08:00 +0000

Microsoft Released the Visual Studio 11 Beta version, It Includes following new features:-

New HTML and CSS editors extend Visual Studio’s rich editing capabilities to make HTML 5 and CSS 3 development more productive, as well as enrich traditional HTML development.

Visual Studio 11 gives you the tools required to build and deploy Windows Azure applications, including project templates, a seamless debugging experience, and easy publishing.

New designers make building Windows 8 Metro and traditional Windows desktop applications easier and faster than ever.

Flexible agile planning tools (like capacity planning, task boards, and product backlog) allow teams to adopt incremental development techniques and agile methodologies, like SCRUM, at their own pace.

Get Visual Studio 11 Beta today and start preparing for the next generation of
development.

SQL Server 2012 RTM samples databases/samples

noreply@blogger.com (Babu) — Tue, 13 Mar 2012 02:53:00 +0000

Today Microsoft published the samples databases and samples projects for SQL Server 2012 RTM. You can find the downloads and descriptions on the following pages:

CodePlex:

Adventure Works for SQL Server 2012

TechNet Wiki:

SQL Server Samples Readme

Download Center:

Power View and PowerPivot HelloWorldPicnic Samples for SQL Server 2012

Image Files for HelloWorldPicnic Sample Model in PowerPivot and Power View

Adventure Works For SQL 2012

noreply@blogger.com (Babu) — Sun, 11 Mar 2012 02:43:00 +0000

The AdventureWorks2012 OLTP database name was updated in February for SQL Server 2012 RC0, based on customer feedback from its original RC0 release in December 2011. Basically, the database, filename, and logical files were renamed from AdventureWorks2008R2 to AdventureWorks2012, as indicated on the CodePlex page.

For the RTM release, AdventureWorks2012 will be published along with the RTM versions of AdventureWorksDW2012 and other sample projects by EOD Monday, 3/12.

AdventureWorks2012 will have two versions: AdventureWorks2012_Data.mdf for case-insensitive collation and AdventureWorks2012_CS_Data.mdf for case-sensitive. You will also be able to download a DDL script and .csv files to install the database from script. The dates in the database have remained circa 2008 dates.

SQL Server 2012 Launch Announcements‏

noreply@blogger.com (Babu) — Wed, 07 Mar 2012 05:55:00 +0000

Hi... Wanted to give you a quick heads-up on news today from Microsoft regarding SQL Server:

Microsoft announced that SQL Server 2012 has released to manufacturing (RTM). Customers and partners can download an evaluation of the product today and can expect general availability to begin on April 1.

Microsoft also disclosed that it will release a new, limited preview of an Apache Hadoop-based service for Microsoft Windows Azure in the first half of 2012. The Apache Hadoop-based service helps you to glean simple, actionable insights from complex data sets hosted in the cloud by optimizing connectivity with SQL Server 2012 and tools such as Excel, PowerPivot, and Power View. Customers interested in signing up for the latest preview should visit this page.

I also wanted remind you about Today’s SQL Server 2012 virtual launch event.

For more context and information on this news, check out Ted Kummert’s blog post and visit the SQL Server News Center page.

SQL Database File Extensions

noreply@blogger.com (Babu) — Mon, 05 Mar 2012 18:10:00 +0000

The database file extensions .mdf and .ldf are quite straightforward.

Data files are organized in logical groups called filegroups (FG). Filegroups are your way to control what will be the physical locations of your objects. A database must have at least one filegroup called PRIMARY, and optionally other user filegroups as well. The PRIMARY filegroup contains the primary data file (extension .mdf), and the database's system catalog.

You can optionally add secondary data files (extension .ndf) to PRIMARY. User filegroups contain only secondary data files. You can determine which of the filegroups is marked as the default filegroup. An object is created on the default filegroup when the object creation statement does not explicitly specify the target filegroup.
For Example: Database Partition

.ldf stands for Log Data File. Although SQL Server can write to multiple data files in parallel, it can only write to one log file at a time, in a sequential manner. Therefore, unlike with data files, having multiple log files does not result in performance benefit. You might need to add log files if the disk drive where the log resides runs out of space.

Reference: Microsoft® SQL Server® 2008 T-SQL Fundamentals by Itzik Ben-Gan

ColumnStore Index - SQL 2012 New features

noreply@blogger.com (Babu) — Wed, 22 Feb 2012 19:33:00 +0000

Summary:

The SQL Server 11.0 release (code named “Denali”) introduces a new data warehouse query acceleration feature based on a new type of index called the columnstore. This new index, combined with enhanced query processing features, improves data warehouse query performance by hundreds to thousands of times in some cases, and can routinely give a tenfold speedup for a broad range of decision support queries. This can allow end users to get more business value from their data through fast, interactive exploration. IT workers can reduce development costs and ETL times since columnstore indexes limit or eliminate the need to rely on pre-built aggregates, including user-defined summary tables, and indexed (materialized) views. Furthermore, columnstore indexes can greatly improve ROLAP performance, making ROLAP more attractive.

Download "Column Store Index" white paper

Note: above content is copied from the White paper discussed in this post

How Reporting Services Works?

noreply@blogger.com (Babu) — Wed, 22 Feb 2012 19:10:00 +0000

Here I’ve explained briefly on how Reporting service requests are handled through the components of SSRS architecture.

As shown in the diagram: Firstly, request will be received by Reporting server’s OS through Http.sys Driver, the driver will route the communication to reporting service’s Web service. Http Listener will receive the request which will be re-routed by Http.sys.

Http Listener transfers the request to Security sub layer (SSL) for authentication. Requestor is identified using 4 different authentication mechanisms like Kerberos, NTLM, Negotiate and basic authentication.

Each mechanism supports different approach. Once user has been authorized by SSL, user communication will be redirected to either Report Manager or Report Server which is hosted in RS web services (refer the exhibit). These two components will read the report definition, report details like parameter, building report query, and some of the activities which are listed below, etc., will be done with the help of Core Processing unit.

Activities of Core Processing component are:-

Scheduling
Subscription Management
Report Processing

Upon completion of processing all SSRS components, Report output will be rendered on report viewer.

Hope this is helpful!

5 Tips for a Smooth SSIS Upgrade to SQL Server 2012 - White Paper

noreply@blogger.com (Babu) — Fri, 17 Feb 2012 19:44:00 +0000

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters, converting packages to the project deployment model, updating Execute Package tasks to use project references and parameterizing the PackageName property.

TIP #1: Edit Package Configuration and Data Source after upgrading
TIP #2: Convert to project deployment model using Project Conversion Wizard
TIP #3: Update Execute Package Task to use project reference and use parameter to pass data from parent package to child package
TIP #4: Parameterize PackageName property of Execute Package Task to dynamically configure which child package to run at execution time
TIP #5: Convert package configuration to parameter when possible

Download Whitepaper: 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

Reference:- MSDN Documentation

The History of SQL Server

noreply@blogger.com (Babu) — Fri, 17 Feb 2012 19:23:00 +0000

This history of SQL Server goes back to 1989 and this video covers each of the SQL Server releases up to the new SQL Server 2012

SSRS 2008 - Subscriptions Types

noreply@blogger.com (Babu) — Thu, 16 Feb 2012 20:00:00 +0000

Usually the term, Subscription is used for a fixed set of services, such as one copy of each issue of a magazines, newspaper for a certain period of time

SSRS subscriptions allow developer to help the users/clients by configuring the subscription, which will deliver the reports into the hands of your users/clients based on predefined schedule, or at specific event, such as data changes, updates., etc.,

SQL Server Reporting services support two types of subscription as classified below

1. Standard Subscriptions

2. Data Driven Subscriptions

Standard Subscriptions

· This subscription is created and managed by Individual users, it gives more freedom to its user

· It consists of default pre-defined parameter values which will not varied during subscription process

· In this subscription, a report is rendered in a specific format with default parameter, and delivered to a single, pre-set location

Data Driven Subscriptions

· This subscription is used to call as Dynamic Subscription.

· It is more flexible and better for managing delivery of reports to a larger number users with varying needs.

· To use data-driven subscriptions, you must have expertise in building queries and an understanding of how parameters are used. Report server administrators typically create and manage these subscriptions.

· You might use data-driven subscriptions if you have a very large recipient list or if you want to vary report output for each recipient.

By Default, Subscription delivery is limited to e-mail transmittal

SSRS 2008 Command Line Utilities

noreply@blogger.com (Babu) — Wed, 15 Feb 2012 20:43:00 +0000

Microsoft has provided following three utilities for managing the reporting server activities.

1. RS.exe

2. RSConfig.exe

3. RSKeyMgmt.exe

These tools are more useful for configuring SSRS scale-out deployment, sharing encryption keys, managing SSRS objects like reports, data Source, etc.,

RS.exe

This utility helps to execute the VB.NET Scripts for automating the reports deployment. This tool support only when “Reporting services” not running in SharePoint Integrated Mode

Here are the parameters for RS.exe, which is used for deploying reports:

Parameter	Description
/i	Input .rss file for execution
/s	URL to SSRS virtual directory
/u	Username
/p	Password
/l	Timeout in seconds; default is 60 seconds
/b	Batch command execution
/e	SOAP endpoint used; default is mgmt2005
/v	Global Variable mapping
/t	Trace log output goes to SSRS

Utility Location: <Drive:>\ Program Files\Microsoft SQL Server\100\Tools\Bin\rs.exe

RSConfig.exe

RSConfig utility helps to modify/manage the connection information of report services database

Here are the parameters for RSConfig.exe. Note that you will need to use quotation marks if any of the parameters e.g. database name contain a space:

Parameter	Description
/m	Remote server name; default is localhost
/i	Instance name, if a named instance is used
/c	Connection
/s	Database server name
/d	Database name
/a	Authentication method; either Windows or SQL authentication
/u	Username
/p	Password
/t	Trace log output goes to SSRS
/e	Unattended report execution; also needs /u and /p

Utility Location: <Drive:>\ Program Files\Microsoft SQL Server\100\Tools\Bin\rsconfig.exe

RsKeymgmt.exe

This utility helps to manage the encryption key as well as it shares the encryption key to share with other Reporting services installation or instance.

Here are the parameters for RSKeyMgmt.exe:

Parameter	Description
/a	Restored and overwritten
/d	Deletes the key and encrypted data
/e	Extract key for backup to a file
/f	Filepath parameter for /a or /e parameter
/i	Named instance
/p	Password
/t	Trace log output goes to SSRS
/j	Adds a remote SSRS instance to the local Report Server database. /m (report server) and /n (instance name) are used with this parameter; /i refers to the local named instance
/r	Removes an SSRS instance from the scale-out deployment; use the GUID Installation ID to specify the instance
/u	Account name of the remote SSRS instance (optional)
/v	Password for the local admin of the remote SSRS instance (optional)
/m	Remote server name for /j
/n	Remote instance name for /j

Utility Location: <Drive:>\ Program Files\Microsoft SQL Server\100\Tools\Bin\rskeymgmt.exe

Reporting Tools Vs. Reporting Life Cycle

noreply@blogger.com (Babu) — Wed, 15 Feb 2012 03:20:00 +0000

I have posted the stages of Reporting life cycle in my previous post. In this post, we will see, how SQL Server Reporting services is supporting full reporting life cycle?

Microsoft has provided collection of tools and services to implement/follow the Life cycle processes.

Refer the following tables which is classified in form of “Reporting Tools” Vs. “Reporting Life Cycle”

Hope it Helps!

Reporting Life Cycle:-

noreply@blogger.com (Babu) — Tue, 14 Feb 2012 19:35:00 +0000

Reporting life cycle is described as following three phases and listed sequential processes in each phase:-

1. Authoring:

a. Requirement Gathering

b. Design and Clarification

c. Data & Requirement validation/verfication

2. Management

a. Publishing reports

b. Report configuration for end user access

c. Enhancement

3. Delivery

a. End user consumption in terms of viewing reports

b. On demand request (Pull Methods)

c. Subscription on a predefined schedule (Push Methods)

Types of Hierarchies in Data Warehouse:

noreply@blogger.com (Babu) — Tue, 07 Feb 2012 20:11:00 +0000

Hierarchies are logical entities that an end user can use to analyze fact data. These entities can be made of one or multiple levels.

Hierarchies are classified as three ways:-
1. Balanced
2. Unbalanced
3. Ragged

Have a look at the exhibit given below, hope it will help you to understand about the types of hierarchies in better way

Balanced Hierarchies:-

Each level in a hierarchy has the same number of members above it as any other member at the same level

Un Balanced Hierarchies:-

Each level in a hierarchy may not the same number of members as the member which are at the same level, refer the hierarchy structure shown above.

Ragged Hierarchies:-

It is not like balanced Hierarchy, the logical parent member of at least one member is not in the level immediately above the member. It will skip the immediate parent.

For Example: In a company, all the divisions will be reporting to the VP thru hierarchical structure, but Finance department will directly reporting to VP without any middle level.

Architecture Changes Between SSRS 2005 Vs. 2008

noreply@blogger.com (Babu) — Tue, 07 Feb 2012 19:33:00 +0000

There are major changes between SSRS architecture 2005 and 2008. Have a look at the following exhibit first then go thru changes listed below: -

SQL Server Architecture 2005:-

SQL Server Architecture 2008:-

New Changes in SSRS 2008:-
1. Initially, all the SSRS related applications, services and utilities were running as an individual segment. In 2008, these components are merged as single windows service segment. It makes our jobs simple, easy to manage, deploy, configure the SSRS Objects

2. Report server no longer dependent on IIS. Instead, http.sys is used to handling authentication. Http.Sys is called as HTTP Server API. In general word, HTTP.sys is just a driver, which allow us to communicate the clients (browser) with Report Server without Microsoft Internet Information Server(IIS). Also SSRS 2008 has all IIS components which require functioning without having any dependency with IIS.

3.Moving away from IIS, two major actions to be taken care by SSRS components:

a. Disabling some of the functionalities IIS handles which there are no equivalent in SSRS 2008, such as anonymous, client certificate and ISAPI.

b. Enabling some of the functionalities that IIS used to handle for SSRS before. Things such as ability to add virtual directory, port, SSL certificate, logging mechanism and so on…

4. Report Server uses shared components from SQL Server, such as SQL CLR for ASP.NET management, network interfaces, and memory management capabilities. This implies that any advances in administration and logging in SQL Server can be leveraged in SSRS in future releases.

5. CLR Host – All the SSRS components are running under the control of CLR. So CLR is act as host.

6. the Report Manager application and the Report Server web service have been combined into a single Windows service

Store Query as Template Or Control in SSMS ToolBox

noreply@blogger.com (Babu) — Mon, 06 Feb 2012 19:47:00 +0000

Hope many people are aware of this feature, but I came to know about it on today while watching one of the SQL Server webcast. I just want to share the same in this blog. it will be helpful to new comers.

I used to store the query in a script file for future/reference/reusable purpose, Instead of keeping as separate file, you can store the Query in SSMS Toolbox window, which will act as a Template or control.

Following steps will help you to store a Query in Toolbox:-

1. Open SQL Server Management Studio, connect to Database server

2. Check whether Toolbox window is opened or not, if it is not opened then go to View Menu, select Toolbox Menu, or else open the menu using shortcut keyword (Ctrl + Alt + X)

3. If you see any control on toolbox, then you can skip the steps 4,5 and 6

4. When I opened the Toolbox window, it is Empty container as shown below

5. Right Click on Toolbox, select “Show All” Options

6. Toolbox is appeared with list of SSIS and DB Maintenance controls as shown below

7. Open Query Window; write Some Query/Query Template whichever you want to store it. Select the Query, Drag and drop on Toolbox, Or… else copy the query, Right click and paste on the Toolbox.

Look at the following screen, I have a written a Query on Query window, then dropped the same at Toolbox as well.

8. You can categorize the collection Queries by using Creating Tab in the toolbox. Right Click on the toolbox, select “Add Tab”, Enter the Group Name of the Queries.

9. To reuse the Query, right click on the Query, select copy; paste the same on Query window for use.

Note: In Toolbox, if the saved Query is Enabled Mode, then you can drag the Query Template and drop into query window like placing control on designer. By default it is disabled mode. So you need to follow as step 9 to use.

FASMI

noreply@blogger.com (Babu) — Sun, 05 Feb 2012 18:51:00 +0000

Today I Came across the Term Called “FASMI”, when I google about this term, I found following answers.

FASMI is an Alternative Term for OLAP, an Each Character of term holds definition which are listed below:

Fast Analysis (FA) – is defined in the OLAP scenario in five seconds or less.

Shared (S) – Must support access to data by many users in the factors of Sensitivity and Write Backs.

Multidimensional (M) – The data inside the OLAP Database must be multidimensional structure.

Information (I) – The OLAP database must support large volumes of data.

This term is invented by “Nigel Pendse” who is a BI and OLAP analyst and the editor of The BI Verdict (formerly The OLAP Report) and author of The BI Survey (previously known as The OLAP Survey).

“Derived Measure” Vs. “Calculated Measure”

noreply@blogger.com (Babu) — Sun, 05 Feb 2012 18:38:00 +0000

The Main difference between “Derived Measure” and “Calculated Measure” is when the calculation is performed. The following tables will help you understand about this.

Derived Measure	Calculated Measure
This is calculated before the aggregation are created	This is Calculated after aggregations are created
The values of this measure is stored in the Cube	This values aren’t stored in the Cube

You can choose any one the measure depends on your requirements. The main purpose for choosing between a derived measure and a calculated measure is not efficiency, but accuracy.

SQL: Create failed for Database

noreply@blogger.com (Babu) — Tue, 10 Jan 2012 17:54:00 +0000

Problem:-

Today, I’m trying to create a new database in SQL Server 2008 version, it throws the following issue

Create failed for Database 'Test'. (Microsoft.SqlServer.Smo)

The file "D:\Temp\Test\Test.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5118)

Solution:-

While creating the database using “New Database” wizard, it will be generating the filename in the grid based on the name which we are providing for “database name” textbox as well as available file name in the selected folder.

In my scenario, filename cells are blank in the grid. So I have typed filename with MDF and LDF extension in relevant rows of the grid then I clicked “OK” button to create the database, yes it’s been created.

But still I surprised, why the file name is getting populated the grid. Then I’ve gone thru many options/settings which are available for SQL Server/databases, I couldn’t find any settings.

Again created another database with specifying storage path in different drive, even now also it’s been created.

I verified the path in which I faced the issue in database creation. I found that the advanced property of the windows folder is enabled with the option “Compress Contents to save to disk space”. Due this “new database” wizard doesn’t have option to generate the filename in “New database” wizard

I unchecked the advanced property “Compress Contents to save to disk space” then I created the problem, it solves my issue.

Refer the below screenshot for further assistance to remove the option “Compress Contents to save to disk space”

1. Right Click on the folder you want to verify,

2. Click “Properties”

3. Click on Advanced Button

4. Uncheck the option “Compress Contents to save to disk space”

5. Click on ok button to uncompress the folder structure

Causes:

This is because a read/write database’s primary .mdf and .ldf files cannot be created on a compressed volumes.

· Also, if you try to restore a database backup (.bak) file of a read/write database with its .mdf or .ldf or both pointed on a compressed drive, you will again get a similar sort of issue

· Log files should never be placed on compressed file systems. System database (master, msdb, model and tempdm) cannot be placed on compressed drives

Conclusion:-

Because of performance overhead and database recovery issues it is not a good idea to run SQL Server databases on compressed drives. So while you create/Restore the DB use the drive or folder which is not compressed

How To Create XMLA Script For Cube Process Using SSMS

noreply@blogger.com (Babu) — Thu, 08 Dec 2011 12:28:00 +0000

Following steps will explain “how to generate a XMLA Script for Cube process” using SQL Server Management Studio (SSMS).

1. Open SQL Server Management Studio by clicking on the SSMS shortcut icon which located in the Start --> All Programs --> Microsoft SQL Server 2008 R2 --> SQL Server Management Studio.

See the given exhibit for reference (select any version whichever you installed)

2. Click on the “Connect” button, which is available at Object Explorer, Choose “Analysis Services…” as shown Below

3. Enter the server detail/credential you want to connect

4. After you connected to the with proper server details, you can see the list of databases available on the server in Object Explorer Windows as shown below

5. In Object Explorer, Select the cube which you need to process --> Right Click on “Process”

6. Upon click on process, Following model dialog window will appear --> Click on Script link

7. Script link helps you create a script in 3 ways as listed in the exhibit

8. I’ve selected the option to generate the output script on “New Query Window”, so it generated the script on New XMLA Script window as mentioned below:

Sample XMLA Script:-

<DatabaseID>Analysis Services Tutorial</DatabaseID>

</Object>

<Type>ProcessFull</Type>

<WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</Process>

</Parallel>
</Batch>

Note: system will generate the script as per the input you provided on Process window in step 6

SQL Server 2012 RC0 Available for Download

noreply@blogger.com (Babu) — Fri, 25 Nov 2011 02:16:00 +0000

Microsoft SQL Server 2012 Release Candidate (RC0) is now available for Download.

There are many highlights and stunning BI features available in SQL Server 2012.
If you evaluated the previous release SQL Server 2012 Community Technology Preview 3 (CTP3), then you might aware that “PowerPivot” now supports the features like,

Hierarchies
Multiple relationships between tables
A measure grid to easily create, edits, and manages measures
Key Performance Indicators (KPIs)
New DAX functions (Time series, distinct count to name a few)
Importing of binary large objects (BLOB)
Etc.,

All the above listed features and more… in Analysis Services Database

Row-level security
Partitions and Direct Query mode
Direct access to source system
Etc.,

Other improvements:

Upgraded SharePoint Components
Separated setup and configuration strategy
Project "Crescent" (now called Power View)
And more…

Here are the highlights and product overview for SQL Server 2012 Release Candidate from Microsoft:

Microsoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence.

SQL Server 2012 RC0 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by capabilities for mission critical confidence:

Deliver required uptime and data protection with AlwaysOn
Gain breakthrough & predictable performance with ColumnStore Index
Help enable security and compliance with new User-defined Roles and Default Schema for Groups
Enable rapid data discovery for deeper insights across the organization with ColumnStore Index
Ensure more credible, consistent data with SSIS improvements, a Master Data Services add-in for Excel, and new Data Quality Services
Optimize IT and developer productivity across server and cloud with Data-tier Application Component (DAC) parity with SQL Azure and SQL Server Data Tools for a unified dev experience across database, BI, and cloud functions

Download (Registration Recommended)
http://www.microsoft.com/download/en/registration-suggested.aspx?id=28145

Note: Registration takes only a few moments and allows Microsoft to provide you with the latest resources relevant to your interests, including service packs, security notices, and training.

Other References:

Here is the link to the official SQL Server Team blog, on details of the release, http://blogs.technet.com/b/dataplatforminsider/archive/2011/11/17/sql-server-2012-release-candidate-is-now-available.aspx
You can learn about SQL Server 2012 and the latest editions that are coming. The big news is that Microsoft is releasing a NEW Business Intelligence Edition. Read More on SQL 2012 Editions here http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx