(VidhyaSagar) In previously article I’ve covered what is DAC package and how it helps during deployment. In this article I’m going we are going to see how can we create a new data tier application (DAC) package for deployment. All SQL Server related objects can be included in this package for deploy
Other News
Using Parallel.Invoke
The seventh part of the Parallel Programming in .NET tutorial starts a look at the options that the Task Parallel Library provides for task decomposition. This article describes the Parallel.Invoke method, which can execute several delegates in parallel.
Simplifying Data Retrieval in the GridView
(Peter Vogel) Retrieving data from the GridView can involve passing integer values to the GridView’s Rows and Cells properties—resulting in code that’s not only hard to read but brittle: it will break as soon as you add, remove, or reorder the columns in the GridView. But there’s an easy way to pull
SQL Server – Stored Procedure Internal Activation in Service Broker
(Paresh Prajapati) As we have seen earlier posts for Service Broker for single database and Service Broker between databases, we have implemented it with examples. Hope you liked those posts.
Debugging Data Flow in SQL Server Integration Services
(Robert Sheldon) You can save a lot of time by using the SSIS Troubleshooting tools. These enable you to work with reduced data samples, monitor row counts, use data viewers, configure error-handling and monitoring package execution. Although you can develop SSIS packages without them, it is so much
Geometry Snapping using JTS in Oracle
(Simon Greener) In my exploration of the possibilities of using Java Topology Suite’s (JTS) robust algorithms with Oracle SDO_GEOMETRY I have moved to expose three methods within JTS’s GeometrySnapper (com.vividsolutions.jts.operation.overlay.snap) class:
What Do You Need to Know to Become DB2 9.7 Certified?
(Roger Sanders) Shortly before my book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide went into a second printing (which was in May 2009), IBM invited me to help develop the DB2 9.7 for Linux UNIX, and Windows Database Administration (DBA) certification exam (E
Yes, the answer is still RUNSTATS…. Sampling, DSA, zIIPS, and more…
(Willie Favero) Today’s topic started out as a discussion of a DB2 10 feature that I thought was pretty interesting… about a month or so ago. It’s taken this long to get around to completing it. Sometimes timeliness is not my strongest attribute. However, by waiting it has grown to include stuf
SQL SERVER – Denali – New Functions and Shorthand for CASE Statement
(Pinal Dave) This blog post is written in response to the T-SQL Tuesday post of Data Presentation. This is a very interesting subject. I recently started to write about Denali Logical and Comparison functions.
IBM Cognos Proven Practices: Auto Cascading Prompts without Page Refresh in IBM Cognos Report Studio
(Smit Modi and Amit Shivde) This document provides technique to implement auto-cascading of Value prompts without having to do a page refresh.