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...
SQL 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...
Deploying Database with ASP.NET Web application
Web applications can be deployed in two different ways one by using one-click publish or by using a Web deployment package. Usually we may want to deploy our database scripts that we used along with the application deployment. This post discusses the procedures to deploy the database along with web application in Visual Studio 2010. Assume there is no database exist in destination and...
Running 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...
Creating 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
Creating 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 ...
Using 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...
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...
What 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
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...