You can create a data alert to email notification in SQL Server 2012 reporting services. This data alert sends e-mail notification when only when specific conditions in the data are true at a schedule time. This Date Alerting feature is available only when reporting services runs in sharepoint integration mode. It works only with reports that are designed using Report Designer or Report...
Tabular Modeling in SQL Server 2012
Tabular model is a new database structure in SQL Server 2012 Analysis Services. When you create tabular model project, SQL Server Developer Tools creates a Model.bim file to the project and creates workspace database in Analysis Services instance. Workspace database acts as a temporary storage for data when you develop a model in SSDT. Workspace Database Workspace Database stores the data...
Analysis Services Server Modes in SQL Server 2012
SQL Server 2005 and 2008 supports only one mode that is multidimensional mode, Where as SQL Server 2008 R2 supports additional mode PowerPivot for SharePoint. In SQL Server 2012 you have an option to deploy an analysis services instance in tabular mode. This post discusses the Analysis server modes and enhancements in SQL Server 2012. Server Modes Each server mode in SQL Server 2012 has...
SSIS Logging in SQL Server 2012
Enabling SSIS logging is a tedious process in earlier versions. Integration Services Packages has the two options to log the information during the execution, one option is configure the log providers in each package and associate them to executables within the package. Second option is to use SQL statements or script components to implement a custom logging solution. With the introduction...
Enabling Contained Databases in SQL Server 2012
Authentication mechanism to login to SQL Server database engine is either Windows authentication or SQL Server account. Sometimes you will face authentication issues with database portability, example when you migrate a database from one SQL Server instance to another SQL Server instance, DBA has to ensure that all logins in Source SQL Server instance is existed on the target SQL Server...
Power View in SQL Server 2012
Power View is a new feature available in SQL Server 2012 reporting services, It is a browser based application which requires Reporting Services to run in SharePoint Integration mode. The datasource for Power View application is either a analysis services CUBE or Power Pivot work book that needs to deploy to SharePoint document library. This post explains about creating a Power View Report...
SSIS Deployment Models in SQL Server 2012
SQL Server 2012 supports two different SSIS deployment models one is Package Deployment model and another is Project Deployment model. This post describes the characteristics and compares the two different models. Package Deployment Model This model was used in previous versions of Integration Services, Unit of deployment in this model is package and it is stored as DTSX file...
Integration Services Catalog in SQL Server 2012
Integration Services Catalog is a new feature in SQL Server 2012 which supports the centralization of storage of packages and configuration files. You can host only one catalog for one SQL Server Instance. When you deploy your project using project deployment model all project components stored in catalog. This post describes how to create a catalog and set the properties.
Columnstore index in SQL Server 2012
Microsoft SQL Server 2012 introduces a new Index type called Columnstore and it offers great performance for data-warehousing loads and other similar queries. Columnstore indexes are designed for data-ware house workloads that are typically read based. This post discuss about how Columnstore index work, how the data is stored in it and what type of queries can benefit from a column store...
T-SQL features in SQL Server 2012
This post discuss about new T-SQL features in SQL Server 2012. The features which I am going to discuss here are Window Functions. Windowing and additional analytic functions are very cool and they are replacing cursors in T-SQL. Cursors are still available for use but windowing functions give better performance over cursors. What is window function? Window function is a function that...