SQL
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), …
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 …
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 …
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 http://msdn.microsoft.com/en-us/library/ms162839.aspx http://msdn.microsoft.com/en-us/library/ms159720.aspx We can use rs.exe to publish the …
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 …
EXCEPT and INTERSECT (Transact-SQL)
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 …
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 …
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 …
