(Valentino Vranken) This is a follow-up to my article on Loading Complex XML Using SSIS and XSLT. In that article I demonstrated how you can convert complex XML into simple CSV using XSLT in SSIS.
Other News
Advanced Oracle Troubleshooting Guide – Part 10: Index unique scan doing multiblock reads?!
(Tanel Poder) When you troubleshoot an Oracle (performance) problem you usually want to find out what are the problem sessions doing (wrong) and then why are they doing it.
Using BrowserID Authentication in ASP.NET Web Sites
(Bipin Joshi) Using a single user ID and password across multiple web sites is not a new idea. Software companies have played with this idea with varying success. Unfortunately developers often find it complicated to implement support for these systems in their ASP.NET web sites.
Bundling and Minification support in ASP.NET MVC 4
(Shravan Kumar Kasagoni) Most of the web developers today uses multiple JavaScript and CSS files for separation the concerns, for readability & maintainability of code. This is a very good practice from a development point of view, but it often causes degradation of the overall performance of the we
Overview of Oracle Restart commands
(Mike Dean) Oracle Restart is a new feature of Oracle 11 that will automatically restart certain Oracle processes in the event of a failure. A manual shutdown will not cause it to restart, as Oracle assumes you intend for it to be down. This is a great feature and can really help minimize downtime
An Extensible Appointment Scheduling Library
(Richard Carr) Scheduling software can be used to plan future appointments, including those appointments that repeat on a regular basis. This article describes a library with four types of scheduling rule and the potential for additional rules to be incorporated.
Episode #Z21: DB2 10 Data Sharing: New Features and Member Consolidation
(Klaas) In episode Z21, our special guest, Susan Lawson, presented what is new in Data Sharing in the DB2 10 release. Her second part is all about member consolidation.
Drop and Create Databases ~ SQLCMD Style
(Chris Yates) Sometimes there are instances when I need to drop 6 or 7 databases on my local instance. Currently, I run 3 instances locally, two are for OLTP duties and one is for reporting. One method for dropping the databases that I like is based on just a couple of SQL files and a .bat file.
Parameter Wednesday – DB CFG – HADR_PEER_WINDOW
(Ember Crooks) Specifies the time (in seconds) that the HADR database peer continues to act as though it is in sync after the two databases loose communication with each other.
How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues
SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. As DBAs, we need to monitor our environments proactively and create sol