Calling Code from SSRS Report
Report File Code Section Note: Make sure you reference the dll in the report. DLL myapp.MyAppFacade.dll C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
Author
Stored Procedure Output Parameter
Example 1: Example 2:
Creating Unique Constraints
Unique constraint on a column to prevent duplicate entry on a column. Using SQL Server Management Studio In Object Explorer, right-click the table to which you want to add a unique constraint, and click Design. On the Table Designer menu, click Indexes/Keys. In the Indexes/Keys dialog box, click Add. In the grid under General, click Type and choose Unique Key from the drop-down list box to the right... » read more
Making Pageant run another program
Making Pageant run another program You can arrange for Pageant to start another program once it has initialised itself and loaded any keys specified on its command line. This program (perhaps a PuTTY, or a WinCVS making use of Plink, or whatever) will then be able to use the keys Pageant has loaded. You do... » read more
SVN: Comparing 2 Files From Different Branches
To compare 2 files in different branches, first select the first file and “Diff later”, then select the second file and “Diff with xxxxxxx”.
Google Firebase
Firebase is a mobile and web application development platform developed by Firebase, Inc. in 2011, then acquired by Google in 2014. As of October 2018, the Firebase platform has 18 products, which are used by 1.5 million apps. Firebase provides a realtime database and backend as a service. The service provides application developers an API that... » read more
Hadoop Hive
Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data query and analysis. Hive gives a SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop. 1) Hadoop is a framework to process/query the Big data while Hive is an SQL Based tool which builds... » read more
Hadoop
Apache Hadoop is a collection of open-source software utilities that facilitate using a network of many computers to solve problems involving massive amounts of data and computation. It provides a software framework for distributed storage and processing of big data using the MapReduce programming model. https://hadoop.apache.org/
Amazon Redshift
Amazon Redshift is an Internet hosting service and data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing data warehouse company ParAccel, to handle large scale data sets and database migrations. https://aws.amazon.com/redshift/
Massively Parallel Processing (MPP)
MPP database is a type of database or data warehouse where the data and processing power are split up among several different nodes (servers), with one leader node and one or many compute nodes. MPP databases can scale horizontally by adding more compute resources (nodes), rather than having to worry about upgrading to more and more... » read more