Archive

Archive for May, 2012

Change the Look & Feel of the Report Manager.

Why we need to change the Look & Feel of the Report Manager?

Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can get the more idea once open the Report Manager. Read more…

Introduction and Installation of Data Quality Services for Denali

May 24, 2012 2 comments

Data Quality Services (DQS)  enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling

DQS is not installed automatically with Microsoft SQL Server Denali CTP3.  You must perform additional following steps to complete your Data Quality Server installation, configure it, and then use it. Read more…

SQL Azure Database Take Offline

As everyone knows that database administrator can take SQL Server Database offline for maintenance purpose with following command Read more…

SQL+MDX in one Apartment (Hybrid Query).

While replying on the MSDN Forums Most of the time people ask on how to write SQL+MDX both in single place means. Read more…

Powershell – Powershell Script to backup all user DBs in SQL Server

Powershell is Microsoft’s task automation framework.

The following is a simple powershell script to take full backup of all users database of MS SQL Server, this script is tested on MS SQL Server 2008R2 and MS SQL Server 2012(Denali). Read more…

Small Defination of Big Data?

May 22, 2012 2 comments

Big data is BIG NEWS in Industry today. Big data is nothing but characteristics of data then bigness of data. Big data really implies different analytics, different data structures and different diversity to the analytics.

And diversity of application was never exists before which is driven by different variety of applications. Currently applications are dealing with this kind of data and ready to present analytics with it. Read more…

User Account Control (UAC) and SSRS

May 21, 2012 3 comments

In SQL Server 2008 R2 Reporting Services people are facing error as “User ‘DomainName\UserName’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed”. I have seen people struggling with this Issue. Here is more light on how to fix this & get your SQL Reporting Services Report Server URL working. Read more…

Table Attributes Dependencies in Store Procedures with SQL Server 2012

May 21, 2012 2 comments

Couple of days back I got an opportunity to migrate the existing Sybase ASE database (Adaptive Server Enterprise/15.0.2) to my favorite MS SQL Server 2012, to find out the feasibility of migration activity in near future.

Our team consists of Project Manager, Database architect and few of the senior guys we all concluded to just migrate the database objects from Sybase to SQL Server 2012, and along with the migration we need to find out dead objects in the existing database which is being carried so far. Here the dead objects means such tables, columns and views which are no more in use. Read more…

BIDS No More Exist in SQL Server 2012.

Once you will installed SQL Server 2012 you could not find the BIDS to develop SSAS/SSIS/SSRS application. BIDS will replace with SSDT i.e. SQL Server Data Tools.

Comparison of SQL Server 2012 Vs SQL Server 2008 R2. Read more…

Convert Number Value Into Words using SSRS

May 21, 2012 1 comment

For Display Amount Value into Words with SQL Reporting Services 2008, we can implement the same with following two ways.

· Database Function

· Custom Assembly Read more…

%d bloggers like this: