SQL Server PowerShell

SQL Server 2014 supports Windows PowerShell, which is a powerful scripting shell that lets administrators and developers automate server administration and application deployment.

This site covers articles such as SQLPS, SMO Assemblies and using PowerShell with SQL Server.

Click here to go to the site.



Keywords: powershell sqlserver sqlps smo

Product Documentation

Microsoft SQL Server online documentation can be found here. This facility covers the current and previous versions.


Oracle online documentation can be found here. This repository of information covers the Oracle Portfolio rather than just database systems. Areas covered for example, are Cloud, Big Data, Hardware and Java.




Keywords: sqlserver documentation oracle

Overview of the .NET Framework

The .NET Framework is a technology that supports building and running the next generation of applications and XML Web services. This article also gives an explanation of Common Language Runtime (CLR) and .NET Framework class library.

 

Click here to read the full article.

Basics of SSIS and Creating Packages

SQL Server Integration Services (SSIS) – Part 1: Basics of SSIS and Creating Packages

In this article, we will see what a SQL Server Integration Services (SSIS) is; basics on what SSIS is used for, how to create an SSIS Package and how to debug the same.

Cick here for the article.