SQL: CONVERT vs. CAST By: Zack Turnbow Introduction When writing stored procedures or other SQL queries, too often there is a need to have data in a specific data type. The two common functions used to achieve this is the CONVERT and CAST functions. Need help with Windows Dedicated Hosting ? Try Server...
Categorized By Database
Articles in Category: 'Database'
SQL: NOT IN vs. NOT EQUAL
Category: Database / SQL Server
SQL: NOT IN vs. NOT EQUAL By: Zack Turnbow Introduction While writing SQL queries, have you ever strung several (not equals) together in the WHERE clause and just wondered if that was inefficient? Or have you used the NOT IN function, (both of which can be used to get the same result), and wondered...
SQL: COALESCE() Function
Category: Database / SQL Server
SQL: COALESCE() By: Zack Turnbow Introduction When developing queries in SQL Server, dealing with nulls can often be challenging. The COALESCE function was included in SQL 2005 to help deal with these issues. First let’s take a look at what COALESCE can offer. Generally, COALESCE function receives...
SQL Server Integrated Services Package Deployment
Category: Database / SQL Server
SQL 2005: SQL Server Integration Services Package Deployment By: Zack Turnbow Introduction A decent amount of material has been covered in this introductory series on SQL Server 2005 Integration Services. Many of the basic data flow tasks have been covered along with some database maintenance tasks....
SQL Server Integration Services: Calling SSIS Package in C#
Category: Database / SQL Server
SQL 2005: SQL Server Integration Services Calling SSIS Package from C# Code By: Zack Turnbow Introduction During this series about SQL Server Integration Services, the basics of importing, exporting, manipulating data, typical database maintenance and deployment of SSIS packages have been covered. In...
SQL Server Integration Services Transfer Logins
Category: Database / SQL Server
SQL 2005: SQL Server Integration Services Transfer Logins Task By: Zack Turnbow Introduction In the previous article, database maintenance tasks were introduced. The first maintenance task was the Transfer Database Task which is the most common maintenance task. The next task and last maintenance task...
SQL Server Integration Services Transfer DB Task
Category: Database / SQL Server
SQL 2005: SQL Server Integration Services Transfer Database Task By: Zack Turnbow Introduction Moving forward on the quick tour of SSIS, the next few items that are going to be covered are database maintenance tasks followed by deploying a package and finally calling a SSIS package from some C# code...
SQL Server Integration Services Dealing with Bad Data
Category: Database / SQL Server
SQL 2005: SQL Server Integration Services Dealing with Bad Data By: Zack Turnbow Introduction If you haven’t been following along this introductory series on SQL Server Integration Services (SSIS), I strongly encourage you to go back and take a look at what has been covered so far. Most of the...
SQL Server Integration Services Script
Category: Database / SQL Server
SQL 2005: SQL Server Integration Services The Script Component By: Zack Turnbow Introduction Continuing this introductory series about SSIS, we will start getting into some uncommon components. The Script component is often used for sanitizing the data when one of the existing components does not do...
SQL Server Integration Services Multicast
Category: Database / SQL Server
SQL 2005: SQL Server Integration Services Multicast By: Zack Turnbow Introduction This next introductory article on SSIS, the use of the Multicast component will be explored. This component is fairly straight forward in its use. It does exactly what it says. If you need to send data to two different...