Advertisements

Archive

Archive for the ‘SQL Server 2008 R2’ Category

SELECT * Vs SELECT Column Name in SQL Server Query

September 2, 2012 4 comments

People always keep saying do not use SELECT * exercise SELECT <column names> instead. But no one put more light on this and this becoming myth in SQL Server and other database management systems. Here are couple of reasons why should we avoid SELECT * and go with SELECT <column names>

Read more…

Advertisements

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…

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…

User Account Control (UAC) and SSRS

May 21, 2012 2 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…

How to achieve Parallelism in SSIS

May 20, 2012 Leave a comment

SQL Server Integration Services (SSIS) allows parallel execution in two different ways

1) MaxConcurrentExecutables : It defines how many tasks (executables) can run simultaneously. It defaults to -1 which is translated to the number of processors plus 2. Please note that if your box has hyperthreading turned on, it is the logical processor rather than the physically present processor that is counted. Read more…

%d bloggers like this: