(Michelle Gutzait) So, you’ve decided to upgrade your databases from SQL Server 2000 to SQL 2005. A lot has been said as to why upgrade: gaining scalability, reliability, up to 30% performance improvements and much more. (R)
Other News
Hands-Free Management
(David Baum) With the daily issues of running a round-the-clock data center, IT departments can lose sight of what makes their companies competitive and successful: greater agility, better service quality, and lower operational costs. System administrators manage increasing numbers of servers, stora
Restore your SQL Server database using transaction logs
(Tim Chapman) Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA’s skill set. I’ll walk you through the steps of how to restore a SQL Server databa
Replace all occurrences of a pattern in a string with VB.NET
(Irina Medvinskaya) When you need to find a certain pattern of a string and modify the text to hide the contents, you can utilize VB.NET’s Regex.Replace method. Regex.Replace is a very efficient way to replace values. It allows you to replace the string with a fixed string literal, and it provides a
SSAS: Exporting MDX and XMLA from SQL Server Profiler
(Darren Gosbell) I was not looking for this, I was looking for some way to easily extract event durations without having to get my hands dirty with angle brackets (XML) and I stumbled upon the menu below.
Handling Cookies and File Data with the Factory Pattern in PHP 5
(Alejandro Gervasio) Any PHP developer who has been using the object-oriented paradigm for a while for developing web applications knows that the factory design pattern can be really useful when it comes to creating multiple objects across a specific programming context. However, if you’re intereste
AJAX File Upload Progress for Java
(Frank Rios) Most of the browser-based applications created today seem to have one thing in common: AJAX. AJAX stands for Asynchronous JavaScript and XML. It does not matter what language the page is written in. It can be PHP, JSP, ASP, or simply straight HTML. Either way, AJAX will give your web pa
ASP.NET OOP and Unit Testing
(Brian Mains) ASP.NET is a very functional framework for developing web applications. Creating an object-oriented solution is harder to do so because of the coding effort involved with doing so. This coding effort means creating a custom page or user control class that drives the ASP.NET page.
WPF For The WinForms Developer
(Ged Mead) Here’s my personal take on WPF at this relatively early stage of the game: I remember that a few years ago when .NET first hit the streets I thought that getting to grips with VB.NET from Classic VB was a steep learning curve. Well let me put it this way: by comparison, learning WPF i
Data integration and composite business services, Part 1: Provide a single view of a customer
(Mary Taylor and Li (Tony) Wei) The ability for a company to integrate multiple repositories of customer data to provide a “single view of the customer” is critical for effective Service-Oriented Architecture (SOA) transformations. WebSphere Customer Center (WCC), a building block for solutions, pro