(Jamie Thomson) As you may already have gleaned from earlier posts in the 30daysofSSIS series SSIS in Denali includes the new SSIS Catalog that is used for execution and administration of SSIS projects and their associated paraphernalia.
Other News
Linked Servers in SQL Server 2008
(Suthish Nair) This article helps you to understand the concept of Linked Servers in SQL Server 2008.
SQL Server Bit Data Type and how it Stores Values
(Madhivanan) SQL Server supports the bit datatype which can be used to store flag values like ‘true’ or ‘false’. However it should be noted how the values are stored in the bit column. This article gives you an overview of the same.
Internals of Dependency Property in WPF
(Abhishek Sur) WPF introduces new property system to us. Every WPF objects that is inherited from DependencyObject inherently supports Dependency property containers within it. That means you can define your own dependency property in your code which can take part in some of the interesting features
Archive logging revisited; Getting Started
(James Koopmann) It isn’t too much of a stretch to say that archive logging within Oracle is one of the very first areas a DBA learns to master. Without paying proper attention to the archive logging function an Oracle database could soon become crippled and unusable.
More on COUNT()s — 2
(Hemant K Chitale) Continuing with my previous posts “Running a COUNT(Column) versus COUNT(*)” and”More on COUNT()s”, I now go on to demonstrate some more “twists” :
Step by Step Approach to Differential Backup and Recovery
(Chris Burns and Iain Kick) Real-world databases on the SQL Server platform continue to get larger, often ranging into multiple terabytes in many production environments. There has also been a trend toward consolidating SQL Server environments to reduce costs and wasted resources.
SharePoint Server 2010 capacity management: Software boundaries and limits
This article describes software boundaries and limits of Microsoft SharePoint Server 2010. These include the following:
23:59:59 is not the end of the day. No, really!
(Shlomi Noach) How would you check whether some TIMESTAMP column falls within a given day, say July 26th, 2011?
Routing mechanisms in WebSphere Message Broker V7
(Ribu Rajan and Ritesh Srivastava) One of the core capabilities of WebSphere Message Broker is message routing, which enables messages to be routed from sender to receiver based on message content. This article describes the content-based routing mechanisms available in WebSphere Message Broker, inc