.NET Resources - Articles, Blogs, Tools, Book Reviews and more...

You can find valuable .NET resources including Articles, Software tools, book reviews, blogs, links to good articles and much more.



You can make money from this site by posting original and quality articles that comply with Google AdSense policies.. Also, we offer several other reward programs including monthly profit sharing, cash rewards per post, contests & prizes etc to contributing members.

Submit Your Article

Articles

How to create table in SQL

SQL stands for Structured Query Language. It is an ANSI standard language to communicate for relational database management system. SQL is used to store, manipulate and maintain the data in SQL server database.

Slowly Changing Dimension transformation in SSIS

In this article, I create a simple ETL package that inserting and updating the records from Source database to data warehouse dimension database/tables using Slowly Changing Dimension transformation.I am going to provide you the steps and guidance needed to manage Slowly Changing Dimension with Slowly Changing Dimension Transformation in data flow task with an example.

SSIS - Using a temp table in a data flow source

Create a stored procedure that will populate the few records. The sample SSIS package will first call the stored procedure and then will insert the records into physical table and then populate the records into flat file.

Conditional Split Data Transformation in SSIS

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from SQL Server database table to multiple flat files. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Merge Join Transmission in SSIS

In this article, I create a simple ETL package that join the data from two SQL tables using merge join transmission and finally loads the result into a SQL table.Merge Join is same as JOIN in t-sql, you can choose between different types of Inner join, Left outer join and Full outer join.

Cascading Parameter in SSRS

Cascading parameter is basically a parameter that depends on another parameter so that the list of available values for a parameter are filtered based on another parameter selection. Cascading parameter provide a way of managing large amounts of report data

Back Up of SSRS Reports

By using the "SQL Server Reporting Services RS.EXE", we can take the Back Up of SSRS Report folder and move the reports from one server to another server. The SQL Server Reporting Services RS.EXE utility is a command line utility that can perform many scripted operation related to SQL Server Reporting Services (SSRS).

Back Up Database Task

By using the Backup Database task, a package can back up a single database or multiple databases. If the task backs up only a single database, you can choose the backup component: the database, or its files and file groups.

Aggregate Transformation in SSIS

Aggregate transformation is an active transformation used to perform calculations such as sums, averages, counts on groups of data. The integration service stores the data group and row data in aggregate cache. The Aggregate Transformation provides more advantages than the SQL, you can use conditional clauses to filter rows.

Group by – grouping sets, roll up & cube

This article discusses Grouping Sets in T-SQL. Grouping Sets is a new feature in T-SQL in SQL Server 2008.The ROLLUP, CUBE, and GROUPING SETS operators are extensions of the GROUP BY clause.By using GROUPING SETS() we can specify multiple groupings in a single query. GROUPING SETS() generates the result by producing a UNION ALL set of the result sets generated by specified grouping sets.

Grouping in SSRS Reports

In this article, I have explained how to create a grouped reports in SSRS. Groups are created to organize data on the report or to calculate aggregate summaries. An understanding how to define groups and use group features helps you design reports that are more concise and communicate summarized data in a more compact format.

Views In SQL Server with examples

This article discusses one of the objects in SQL server – "Views" A view is a virtual table based on the result-set of an SQL statement.A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

SQL Server Set operators

SQL set operators allows combine results from two or more SELECT statements. At first sight this looks similar to SQL joins although there is big difference. SQL joins tends to combine columns i.e. with each additionally joined table it is possible to select more and more columns. SQL set operators on the other hand combine rows from different queries with strong preconditions

SQL Server - Sub Queries

Subquery or Inner query or Nested query is a query in a query. SQL subquery is usually added in the WHERE Clause of the SQL statement. Most of the time, a subquery is used when you know how to search for a value using a SELECT statement, but do not know the exact value in the database.

SQL Server Ranking Functions

SQL Server introduced four new ranking functions either to rank records in a result-set or to rank records within groups of records of a result-set. 1.ROW_NUMBER () 2.RANK () 3.DENSE_RANK () 4.NTILE ()

Submit Your Article