(Ged Mead) Continuing with our simple example from the first post in this series, when you view the Windows Form at design time, you can see the column headers, but not the actual data.
Author: SSWUG Research
Using Validation Groups Inside ASP.NET User Controls
(Bipin Joshi) Validation groups allow you to validate data entry controls in groups. Server controls such as validation controls, Button and TextBox have ValidationGroup property that takes a string value. All the server controls having the same ValidationGroup value act as one validation group. Val
T-SQL Command Line Options – Part 1
(Derik Hammer) Every SQL Server DBA is intimately familiar with SQL Server Management Studio (SSMS) and/or previous tools such as Query Analyzer. What some of us are less familiar with are the various options of executing T-SQL via command line or from script files.
SSIS: Removing Duplicates in a data flow
(Chris) Recently I came across a post online that was providing a solution to duplicates in a data flow. As I was reading it, in it there was something that makes me cringe: a Sort transform. Those of you who know me know that the Sort transform in a data flow gives me nightmares at night, almost as
Integrating and Using Github in Visual Studio 2012
(Rion Williams) With so many source control options out there, it can be a daunting task in choosing one, especially that you enjoy using and integrates well with your development environment. In recent years, the open-source-centric Github has taken over as a premier repository for allowing users t
XML Interoperability of Serialized Entities in Java and .NET
(Joel Holder) In order to exchange structured data directly between the platforms, we must be able to easily take the marshalled or serialized definition of the object and turn it into an object in memory. There are standard ways of marshalling of objects to XML in both Java and .NET.
Testing for Exceptions with tSQLt
(Dave Green) I’ve recently been looking at two relatively new pieces of functionality in tSQLt, the unit testing framework that underpins Red Gate software’s SQL Test.
Alter query to add column with default value in SQL Server
(powerful peraiah) In this article I will explain how to write Query to add new column with default value to existing datatable in SQL server.
Using the REPLAY feature within SQL Server Profiler
(Ben Snaidero) Have you ever had the need to reproduce a specific issue from production in another environment for debugging or wanted the ability to test the exact same data load on a different server configuration or hardware? Available since SQL Server 2005 is the trace replay functionality withi
Developing a distributed WS-AT transaction using an IBM BPM Advanced Integration Service, Part 5: Execution cases
(Carlo Randone and Marco Antonioni) Leveraging the capabilities of the Advanced Integration Services (AIS) in IBM Business Process Manager V8.0.1 Advanced, this series describes the implementation of a distributed WS-AT scenario involving two databases (Microsoft SQL Server and IBM DB2) installed on