The data flow element is a part of a SSIS package that contains different type of data flow components:
- Source components – make data from different types of data sources available to a data flow
- Transformational components – aggregate, merge, distribute, and modify the data inside the data stream, and
- Destination components – load the data from the data flow into different types of data sources or create an in-memory dataset
January 22, 2015
In the previous part of this series, we showed how to use SQL Server profiler to create a SQL trace that provides enough information to find expensive SQL queries. In this part, we will show how to create a SQL trace without SQL Profiler and how to analyze the information captured.
October 6, 2014
In the previous parts of this series, we described how to find the most expensive recent queries using SQL Server Management Studio native features and dynamic management views and functions. In this part, we will show how to do that using SQL Server Profiler.
October 1, 2014
In the previous part of this series, we described why tracking most expensive queries is important and how to use SQL Server Management Studio native solutions. In this part, we will focus on dynamic management views and functions.
September 30, 2014
Monitoring and diagnosing SQL Server performance requires monitoring performance metric values, but also understanding these metrics and their relation to other metrics, knowing metric normal values, monitoring resource-intensive processes and queries, etc.
September 16, 2014
Efficient SQL Server performance monitoring includes monitoring of operating system, SQL Server, and database performance. In How to monitor your SQL Server instances and databases, we presented tools for monitoring the latter two performance metrics, In this article, we will present tools that provide operating system performance monitoring.
July 16, 2014
When it comes to monitoring SQL Server performance, there are a few native SQL Server solutions that provide out of the box performance monitoring. We have written about some of them here: A DBA guide to SQL Server performance troubleshooting – Part 2 – Monitoring utilities.
June 27, 2014
Monitoring SQL Server instances and databases provide information necessary to diagnose and troubleshoot SQL Server performance issues, as well as to fine-tune SQL Server. Optimal performance is not easy to define and set, as there is usually a trade-off between multiple software and hardware factors. It also depends on your environment, business requirements, and company policy.
May 26, 2014
In this article, how to create a SQL database across multiple SQL Servers from multiple scripts will be described by using PowerShell, the SQLCMD utility, SQL Server Management Studio, and ApexSQL Propagate.
May 19, 2014
Sometimes, it is necessary to export or import large amounts of data into or out of a database. Those operations are called bulk export and import operations.
May 12, 2014
SQL Server logins are the credentials that enable users to connect to the Database Engine instance. SQL logins are distinguished based on the type of authentication method: Windows-authenticated, SQL Server–authenticated, Certificate, and Asymmetric key. One SQL login can be mapped to only one user in each database.
April 28, 2014
SQL Database refactoring becomes more complicated according to the degree of coupling in the database architecture; the more coupled things are coupled the greater the potential impact of any change. The simplest way to describe the concept of coupling is that if changing one module in one module of code or a program requires changes in another part of the same or external application, then coupling exists
April 4, 2014
One of the most important requirements in the process of SQL database refactoring is that any change made in a database schema requires all dependences to be updated and changed to reflect the changes which are made.
April 2, 2014
What is database refactoring?
Database refactoring is a change in a database schema with a goal to improve a database design and retain both informational and behavior semantics.
March 14, 2014
Splitting a table by moving set of columns into a new table is called vertical partitioning. Horizontal partitioning is having different tables with the same columns but contain different (distinct) sets of rows
March 10, 2014
Replacing a natural key with a surrogate key is structural refactoring method of replacing an existing natural key with a surrogate key.
February 20, 2014
There is a number of object types in SQL Server database system. Each has its own purpose and role in proper data management. However, sometimes it is required to check how some of them are used.
February 19, 2014
Rename table, Rename column, and Rename view are structural refactoring. The main purpose to apply Rename column, Rename table, and Rename view are increasing readability, adopting database naming conventions, or clarifying the meaning of an object. In the case of renaming objects, a cost of refactoring both database and external applications that access the database vs. an impact of the achieved readability, should be considered.
February 18, 2014
In this article we’ll make an introduction in a series of articles on SQL database refactoring and solutions using ApexSQL Refactor a SSMS and VS add-in with 11 SQL database refactors
February 14, 2014
In this article, some most common guidance in naming conventions will be given and shown how ApexSQL Refactor, SQL formatting Visual Studio and SSMS add-in with nearly 200 formatting options, can help in achieving capitalization consistency among team members.
February 13, 2014