(Tim Chapman) Converting data and splitting data are at the core of almost any type of data application. This tutorial presents an example that details how to perform data conversion and conditional data splitting using SQL Server 2005 Integration Services (SSIS).
Other News
Creating SQL Server tables and columns: Quick tips to know
(Baya Pavliashvili) Creating and maintaining SQL Server tables isn’t a rocket science, or is it? Anyone can use SQL Server Management Studio or the CREATE TABLE statement to put together a collection of columns. How well the tables perform depends largely on choices you make when defining data types
Business Intelligence with Microsoft SQL Server 2005
(Rajdeep Mukherjee) Microsoft SQL Server 2005 (sometimes known as Yukon) provides a great platform that presents the features and functionalities to build any complex analytical solutions. Today’s software applications aim at extracting useful information from a collection of data. Microsoft SQL Ser
SYS.DM_EXEC_TEXT_QUERY_PLAN
In our previous blog posts, we have covered about some of the new features introduced in service pack 2 (SP2) of MS SQLServer 2005, namely VARDECIMAL (new data type) and log-on trigger. In this blog post, we will cover yet another enhancement available in SP2.
From DevConnections… Day 1
Featured Article(s) Understanding Software Testing (Part II) This is the second part in the series of three part articles on Software Testing. In this part we will explore the common types of software testing. Software Testing can be classified into several types based on treating the subject from various angles. Let us look into some common classifications for Software Testing. […]
Headed to DevConnections/SQL Connections
Featured Article(s) Find all tables and schemas without a primary key constraint The following procedure generates a list of all tables in all schemas and in all server’s user databases that a PK constraint is NOT defined on them. Read: Integration Studio Review Friday we published a review of Relational Solutions BlueSky Integration Studio – if you’re building SSIS projects, […]
Column-level encryption in IDS
(Manoj Mohan and Lynette D. Adayilamuriyil) Database security is of paramount importance to customers in today’s e-commerce world. Enterprises around the world are facing bigger challenges to protect their sensitive data from hackers. Furthermore, a large number of state, federal, and corporate comp
Application Handling of Database Timeouts and Deadlocks
(Aleksey Shevchenko) Every application that utilizes a relational database can encounter situations where data is deadlocked or unavailable. These situations need to be handled programmatically within your code. This article is designed to introduce the concepts of retry logic related to database tr
Build Knowledge Through a Taxonomy of Classifications
(Kurt Cagle) The dilemma is common. Your web site starts out by design with a few pages of content—a front page, a products page, perhaps something about the company or person putting up the site—and you can generally manage the various links on the site by hand. However, as the site needs to do mor
The new cool MySQL patch has landed! Check your queries performance!
(Maciek Dobrzanski) Microslow patch is used by many DBAs and developers to accurately time their queries and to catch those which run less than a second as they can also be a performance killer for a busy application.