Archive for the 'SQL server' Category
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 commentUsing Data Profiling Task in SSIS
| Data Profiling is important in data quality processing and transformation. It provides a way to investigate large datasets and to identify incorrectly formatted data. This post explains doing data analysis using Data Profiling task. | |
Data Profiling task helps you to
- Identify the problems with your data. Example: Finding the products in your data which are not following the naming pattern.
- Identify the missing functional dependencies between columns. Example: State and Zip code columns. It helps you identify wrong ZIP code that has been entered for a state or city.
Setting up Data Profile Task
Related Posts:
2 commentsSQL Azure vs SQL Server
This post discusses the differences between SQL Azure and SQL Server in the context of security
 |
 |
| Supports SQL(native) and Windows authentication. | Supports SQL(native) only, no windows authentication. |
| Authorization is based on database users and roles. | Authorization is based on database users and roles. |
| SQL Server has fixed server roles such as serveradmin, securityadmin and dbcreator. | There are no fixed server roles such as in sql server but it has loginmanager and dbmanager roles in Master DB to simulate relevant server roles. |
| Accessing SQL Server over wire is via Tabular Data Stream (TDS) plus SSL on port TCP 1433. Using SSL is optional. | Accessing SQL Azure over wire is same as SQL server using TDS but SSL is mandatory |
| Firewall and IP blocking is using hosted firewall. | SQL Azure has built-in firewall which blocks all external IP’s until you specify to allow. |
| SQL Server supports native encryption at page level using transparent data current. TDC | SQL Azure does not supports the native encryption. |
More detailed comparison can be found here
Share this post :
Related Posts:
No commentsCreating Firewall rules using SQL Azure
| The firewall feature in Windows Azure portal allows you to store your data securely on cloud which deny all connections by default. The new firewall feature allows you to specify list of IP addresses which can access your SQL Azure Server.You can also programmatically add connections and retrieve information for SQL Azure database. This post discusses about creating the firewall rule using the Azure portal. |  |
1. Browse the website https://windows.azure.com/ and enter your live account credentials
Related Posts:
No commentsRunning SQL Server JOBS with different user accounts in SQL 2008
| This post discusses about configuring different user account to JOB running in SQL Server 2008. By default SQL JOBs runs under service account that you have configured while installing the SQL Server. You can follow the below steps to change the user account that running under JOB | |
1. Open SQL Server Management Studio and expand the SQL Server Agent node and Select the JOB that you want to change the running account.
Related Posts:
No commentsCreating a database in SQL Azure
|
This post discusses about setting up a windows Azure and creating a SQL Azure database. There 3 main steps to create a main database |
 |
Step1: Visit the Windows Azure website and select the suitable offer. For testing and knowing the features there is a introductory offer which is free to use as long as you do not exceed the monthly usage hours. visit here for offer
Related Posts:
No commentsCreating a Database Unit Test using Visual Studio 2010
| This post discusses about creating a database unit test case in Visual Studio 2010 which verifies the functionality of a stored procedure. Creating Database Test cases helps you to identify the code defects which in-directly effects the application behavior. In order to create a database unit test, you need to VS studio 2010 test suite or ultimate version. |  |
Before writing a unit test case , define a schema file and create a database project and deploy to the database as shown below.
Related Posts:
1 commentUsing Memory Beyond 4GB in SQL Server
|
Physical Address Extension (PAE) allows you to use up to 64 GB of physical memory depending on operating system you use. All existing 32 bit processors supports this extension of memory. PAE mode requires an Intel Architecture processor and more than 4GB of RAM. |
|
You can configure at two levels to use Memory Beyond 4GB in a 32 bit windows server operating system.
- Operating System Level
- Application Level
To enable operating system to access more than 4GB of physical memory , add a /PAE switch in boot.ini file as below
