TechBubbles Microsoft Technology BLOG

TagSQL Server 2008 R2

SSL Encryption in SQL Server

  This post discuss about security of SQL Server data and  steps required to configure SSL Encryption in SQL Server. There is a feature named Transparent Data Encryption in SQL server 2008 which provides security for static data, what about the data that flows over the network. SSL Encryption can answer this question. What is SSL Encryption? Secure Sockets Layer(SSL) encryption encrypts...

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...

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...

Using 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...

Analyzing 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...

Creating 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...

SQL 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...

Installing 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...

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud