Archive
SELECT * Vs SELECT Column Name in SQL Server Query
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>
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
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
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…
BI Big Data Authors
Sandip Shinde
Manish Kaushik
Suhas Kudekar(MCC)
Umesh M Patil
YashwantOur Visitors
Big Data, Data Analytics and Data Science | BI-BIGDATA.com 