Deploying SSIS packages into SQL Server vs Deploying as a File
In earlier days we have the options to save the DTS packages to SQL Server or to File System. Many of you trying to understand the trade offs between them. This post list out the advantages of both options.
Advantages of Saving and Deploying SSIS packages to File System
- We can use Source control system manage the versions.
- More secure when using the encrypt with user key encryption.
- Packages are available when you save locally. not subject network downtime problems.
Related Posts:
1 commentDeploying SSIS packages into SQL Server vs Deploying as a File
In earlier days we have the options to save the DTS packages to SQL Server or to File System. Many of you trying to understand the trade offs between them. This post list out the advantages of both options.
Advantages of Saving and Deploying SSIS packages to File System
- We can use Source control system manage the versions.
- More secure when using the encrypt with user key encryption.
- Packages are available when you save locally. not subject network downtime problems.
Related Posts:
No commentsUsing For Loop and Foreach Loop Containers in SSIS
| SQL Server Integration Services supports two container tasks name For Loop and Foreach loop. These containers supports to execute the repetitive workflows in controlled way. The For Loop has three expressions that control it’s execution and termination. This post also discuss about Foreach loop container in SSIS. |  |
The three expressions are
InitExpression The For Loop evaluates the InitExpression exactly once at the start of the loop execution. The initialized variables are used later in other expressions.
EvalExpression The For Loop evaluates the EvalExpression once for every iteration of the For Loop.For Example The InitExpression would be @Index = 1 and EvalExpression would be @Index > 1. EvalExpression must use boolean operators.
Related Posts:
1 commentAnalyzing SQL Server Performance using Performance Monitor Counters
|
This post discusses about using Performance Monitor tool to create a base-line using different performance counters. It also discusses analyzing hardware resource bottlenecks and retrieving performance monitor data in sql server using views. Performance Monitor Tool collects the detailed information of system resources including memory, processor , disk and network.SQL Server 2008 provides extensions to Performance Tool to analyze various areas in SQL Server. |
 |
Performance Monitor tool provides performance counters to represent the specific aspects of a resource.
What is Performance Counter?
Related Posts:
No commentsWhat is new in SQL Server Code-Named “Denali”?
|
This post just re-caps the T-SQL features that introduced in SQL Server 2008 and discusses the new T-SQL features in Microsoft SQL Server next version code name “Denali”. Actually there are not any T-SQL features in SQL Server 2008 R2 as it is purely a BI release. You can download the Denali CTP version from here |
 |
Related Posts:
2 commentsCreating SQL Server Database Objects Backup using SMO
|
This post explains taking the SQL Server Database Objects backup only schema not data in SQL Server 2008 R2. In an ETL server you may come across the situation where you need to change the database objects schema quite frequently especially when data source changes. In this case we may need maintain our schema or take the backup our database objects script some place where we can restore them back to the server. |
|
What is SMO?
This can be achieved in earlier versions of SQL Server using Distributed Management Objects (DMO) but now it is no longer supported in SQL Server 2008 R2 and future versions. We can achieve the same using SQL Server Management Objects (SMO) in 2008 R2. SMO provides objects which are used to manage SQL Server.
Related Posts:
1 commentMonitoring running processes in SQL Server 2008 R2
|
You can view the current connections and processes that running on a sql server instance in two ways
|
|
Monitoring Process in Activity Monitor
To open the Activity Monitor in SQL Server Management Studio Right click the server then select the Activity Monitor option as shown below
Related Posts:
No commentsSQL Server Reporting with Analysis Services
| SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process. Technically CUBE is used in Analysis Services to build the aggregated data. Once it is build then you can easily navigate and produce reports for business analysis. This post discusses using analysis services in SQL Server Reporting with MDX query builder. | |
To download and configure the AW analysis services database read my previous post.
Create a Data Source
1. Create a data source for the AW20082 Analysis Services database in Report Builder 3.0 and select the SQL Server Analysis Services data provider from the drop down list.
Related Posts:
1 commentInstalling AdventureWorks Analysis Services Database
| This post discuss about configuring the AdventureWorks Analysis Services Database in SQL Server 2008 R2. You can download the sample databases from here. By default when you install the setup you would not see the analysis services database, you need to do some configurations to get it appear in analysis services database. | |
To deploy the analysis services database perform the following steps:
1. Ensure that Analysis Services service account has got the access to the AdentureWorksDW2008R2 database.
2. Start the Business Intelligence Development Studio
Related Posts:
3 comments
