Bugs of Performance Point Services 2013

Following are the major bugs and have been reported to product group :   1. Full Page view of Analytic Grid is not showing grid headers. 2. Full Page view of Analytic chart is cutting legends. 3. Legends are not showing if resolution is 1024×768(Ipad 2 resolution). 4. If there is gap for items in…

1

SQL Server 2012 T-SQL – Working with Sequence

One of the T-SQL enhancemtns in SQL Server 2012 addition of Sequence.  You can use sequence to generate a sequential number that can use utilized for various purpose. Here is simple example of using Sequence to populate sequential number to a table.    Create Table dbo.Employee ( EmployeeID Int, FirstName Varchar(30) ); Create Sequence dbo.EmpIDSeq As Int Start with…

0

Row Versioning based Isolation levels in Sql Server

Row Versioning based Isolation levels are very useful in reducing blocking. Which are.. • Read Committed (default) Isolation level  with READ_COMMITTED_SNAPSHOT database option is ON.• Snapshot Isolation level with the ALLOW_SNAPSHOT_ISOLATION database option is ON. Read committed isolation using row versioning provides statement-level read consistency however Snapshot isolation provides transaction-level read consistency. Statement-level read consistency Vs. Transaction-level read…


Conditionally Show/Hide SSRS items(textbox etc.) based on Rendering(PDF,EXCEL) or Printing

We can conditionally show/hide textboxs in SSRS based on rendering or Printing. If you have to hide something(textbox,label) while normal rendering of report ,but you want that item(textbox,label) in print or while exporting to PDF,Excel then below is the expression to control it. =iif(Globals!RenderFormat.IsInteractive=TRUE,TRUE,FALSE).

1

Installing DQS on a named instance of SQL Server 2012.

From my previos post http://blogs.technet.com/b/gdcomdbbi/archive/2012/04/03/installing-dqs-on-a-default-instance-with-different-instance-name-and-instance-id.aspx you can derive that DQSInstaller.exe is pretty limited in its functtionality. Here I will talk about installing the DQS component on a named instance of SQLServer and especially on the PowerPivot instance. Well the trick remains the same, you create an alias on the server where you are installing the DQS…

0

Installing DQS on a Default instance with different instance name and instance ID.

DQSInstaller.exe is pretty limited in its options and as such does not provide any option to redirect your DQS installation on a seperate instance of SQL server. Further it is hardcoded for now to install the DQS components on the default instance (MSSQLSERVER) of the SQL Server 2012 with the default Instance ID (MSSQLSERVER). What this…

3

Installing SQL Server 2012 : New in Data Quality Services (DQS)

With SQL Server 2012, the product launched the all new Data Quality Services aimed at providing a Knowledge based repository for managing the quality of large amount of data. This blog post talks about the installation steps and some of the tips and tricks for installing your DQS Component while performing SQL Server Install. When…

1

Publish SSDT project using command line

SqlPackage.exe is a command line utility that can be used to automate database deployment. You can read more about this utility at http://msdn.microsoft.com/en-us/library/hh550080(v=VS.103).aspx. SqlPackage.exe can be used along with publish profile to publish database in different environments. Here is how my publish database profile looks like. On execute the following command line, it will publish…

3

Convert Visual Studio 2010 Database Project to SSDT Project

You can convert your existing VS 2010 database project to SSDT project by a simple right click operations. Here I have VS 2010 database project (project version SQL Server 2008).  Let’s have a look at the property page in VS 2010.   When you open an existing VS 2010 database project you will be prompted to…

2

Publishing/Deploying database project using SSDT

In order to deploy a database using SQL Server Data Tools (SSDT) choose the publish option from Build Menu or right click on the project and select publish. On selecting Publish, it will bring up a dialog box where you can specify the Target Database Settings. In order to save these publish settings and add it to the current solution, check “Add…

1