People are capable of all kinds of good thinking, but some just don't see what's right in front of their noses.


SQL Server 2014 Data Tools for Business Intelligence

The Google Chrome browser is now supported platform for MS. SQL Server 2014 release of Reporting Services. The BIDS is no longer provided with the SQL Server 2014, and you’ll need to download it manually at Microsoft Download Center. SQL Server Data Tools for Business Intelligence (SSDT-BI), previously known as Business Intelligence Development Studio (BIDS), …Continue reading

RS.exe Utility (SSRS)

RS.exe Utility (SSRS) Rs.exe is a command line utility included with SQL Server Reporting Services. This rss script supports copying content such as reports and data sources from one report server to another. The script supports both native mode report servers and SharePoint mode report servers. For example, you can use the script to copy …Continue reading

Rename SQL Report Server

  In order to rename computer that runs a SQL 2012 report server, do the following: Open RSReportServer.config in a text editor and modify the UrlRoot setting to reflect the new server name. The UrlRoot setting is used by delivery extensions to compose the URL used to access items stored on the report server. Changing …Continue reading

Scripting Deployment and Administrative Tasks

Reporting Services comes with a command line utility, rs.exe, that allows us to administer Report Server via scripts that run Web Service operations.  These scripts must be written in VB.NET and a suggested extension for them is rss (Reporting Services script file). For more information, see We can use rs.exe to publish the …Continue reading

Connect to SQL Server When System Administrators Are Locked Out

A system administrator can lose access to an instance of SQL Server due to following reasons: All logins that are members of the sysadmin fixed server role have been removed by mistake. All Windows Groups that are members of the sysadmin fixed server role have been removed by mistake. The logins that are members of …Continue reading

SQL Server 2014 CTP1 is now available for download

Finally the wait is over to get your hands dirty on SQL Server 2014 as the first Community Test Preview (CTP1) is released and is available for download form the Microsoft Official Site. –> Download the SQL Server 2014 CTP1 [Click here]. You will need to login with your Windows Live ID to go to …Continue reading


They both return distinct values by comparing the results of two queries. EXCEPT returns any distinct values from the left query that are not also found on the right query. INTERSECT returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operand. The basic rules …Continue reading

NTILE() in Transact-SQL

This function is used to distribute the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at one. For each row, NTILE returns the number of the group to which the row belongs. Syntax NTILE (integer_expression) OVER ( [ <partition_by_clause> ] < order_by_clause > ) Arguments integer_expression Is …Continue reading

Details of features supported by the different editions of SQL Server 2012

There are myriad numbers of Microsoft SQL Server 2012 comparison among its editions. In my opinion, the best source is on below MSDN url. Features Supported by the Editions of SQL Server 2012

SQL Filegroups for performance, management and DR

As far as I am concerned, we need to break up our big database (more than 500 GB) into a series of filegroups for better performance, easier management and faster disaster recovery. – Filegroup with current active data – Filegroup with old and obselete data First of all, create a series of filegroup, and then …Continue reading

1 2