7/26
Marcin Policht demonstrates how to leverage SQL Server Integration Services (SSIS) package variables in order to modify SSIS properties without directly editing package content. 7/12
A database administrator can create ad-hoc packages to implement ETL via SSIS or use methods based on software programming principles. Ad-hoc packages may seem advantageous but can lead to duplication of effort. Learn how to implement the second of these options by taking advantage of package variables.
7/02
SQL Server Management Studio has some neat tools for keeping database objects in source control, but they only work if everyone is on board. Red Gate SQL Source Control is a simple and elegant solution that doesn't depend on other developers using the snap-in... and it works.
7/01
Arshad Ali discusses the SQL Server Service Broker Components (SSBS), Conversation, Conversation group, SEND and RECEIVE commands, Route and how these components relate to each other.
6/29
Microsoft has provided a method to programmatically manage your SQL Server Reporting Services environment using the "rs" utility. Greg Larsen shows you how to use this utility to import a report into Reporting Services, as well as how to move reports from one Reporting Services folder to another.
6/28
SQL Server 2008 Integration Services primarily serve as a development platform for automating Export, Transformation, and Loading (ETL) tasks. The benefits of using variables to promote code reusability can be extended by taking advantage of package configurations. In this article, we will introduce package configuration characteristics.
6/18
Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using
the object, when, and how. This gives the SQL developer or database administrator much needed
information for impact analysis prior to a change or the decommissioning of a SQL Server object.
6/14
SQL Server Integration Services' primary purpose is to serve as a database development platform. As such, it is subject to standard best practices of software programming, which among other recommendations, advocate reusability. Realizing this objective in SSIS frequently involves the use of variables. Their characteristics and most common usage scenarios will be the primary subject of our presentation.
6/09
Learn one database developer's top reasons for attending developer conferences, if they're worth the money and will he attend again. This particular article offers the authors opinions on the recent Developer Connection Visual Studio 2010 Launch Event.
6/04
XML has become a common form of representing and exchanging data in today's information age. SQL Server introduced XML-centric capabilities in SQL Server 2000. That functionality has been expanded in later releases. One aspect of working with XML is creating XML from relational data, which is accomplished utilizing the FOR XML clause in SQL Server.
6/03
Arshad Ali discusses the Initiator, Target, Message Types, Contract and Queue--all components of SQL Server Service Broker (SSBS).
6/01
As a database developer or DBA there is not a lot you can do about a legitimate user sharing confidential data. However, you can minimize the risks of someone breaking into your database and browsing around to find confidential information. This article explores how you can use SQL Server features to encrypt your confidential data.
5/25
Tapas Pal shows you how to encrypt your SQL Server database for a pre-existing, business critical web application using Transparent Data Encryption (TDE), a new full database encryption technique introduced in SQL Server 2008.
5/24
Marcin Policht examines SQL Server Integration Services' component, Derived Column Transformation,and how its usefulness is enhanced by its ability to implement fairly elaborate mathematical, logical, and string operations.
5/21
The introduction of the xml data type, with its own set of methods for processing xml data, made it possible for SQL Server developers to create columns and variables of the type xml. Deanna Dicken examines the modify() method, which provides for data manipulation of the XML data stored in the xml data type via XML DML statements.