(Caleb Sima) Once you’ve completed a security assessment as a part of your web application development, it’s time to go down the path of remediating all of the security problems you uncovered. At this point, your developers, quality assurance testers, auditors, and your security managers should all
Other News
Hello World: Hello World: Learn how to create business rules and business processes with WebSphere Integration Developer
(Jane Fung) This tutorial introduces you to WebSphere Integration Developer. It includes three hands-on exercises in which you’ll assemble existing services to create a BPEL business process. The Hello World tutorial for WebSphere Integration Developer V6.0.1 is still available. (R)
Sync Your Database to SharePoint Using SSIS
(Lee Richardson) Custom SharePoint lists are like tables in a traditional database; in some ways they’re even better. But as organizations adopt this new data store, they introduce additional complexities in integrating new list-based solutions with existing database applications. This article shows
ReaderWriterLock
(Jim Mischel) The Monitor lock that we’ve been discussing in previous sections is something of a blunt instrument. You can use it to coordinate exclusive access to a section of code or a data structure, but that’s it. It turns out, though, that often you’d like multiple readers to have access to an
Identify performance bottlenecks in SQL Server
(Hilary Cotter) A beer bottle has one bottleneck (or limiting constraint) that will slow down the flow of beer. In SQL Server, there are four physical factors, also referred to as bottlenecks, that can slow down your overall system throughput and degrade performance. These SQL Server bottlenecks are
FIX: The value of a cell is not updated correctly when you use multiple UPDATE CUBE statements inside a single transaction in SQL Server 2005 Analysis Services
Consider the following scenario. In Microsoft SQL Server 2005, you try to update the value of a cell. To do this, you use multiple UPDATE CUBE statements inside a single transaction. In this scenario, the value of the cell is not updated correctly.
Oracle RAC: How shared storage works on VMware – Part 2
(Tarry Singh) In this article, we will discuss creating clustered VMs on the VMware’s ESX 3 Server. There are several options for doing so. You can create a cluster on a single ESX host. This is generally the easiest way of doing things. However, you might want to test and spread your nodes out acro
Validating What is Stored in a Partition/Filegroup
(Sarah Henwood) How do you validate what is stored in a specific partition and the filegroup the partition resides on? I have found this handy when designing a partition strategy and to double check it is behaving as I expect and my data is stored correctly for the requirements. It also can help i
MySQL replication notes 1: replicating all databases
(Haidong Ji) A couple of weeks ago, a friend asked about replication on MySQL 4.1.7. I’ve worked with replication in the past, just a quick and dirty job on MySQL 5, and soon forgot about it. This time, I wanted to do it on MySQL 4, and make sure I take good notes for my own benefit. If it can […]
New SQL Server Weekly Show Posted
Watch the Latest Weekly SQL Server Show Here We’ve posted the latest edition of SelectViews, our weekly show on SQL Server and databases in general. This week’s show, number 75, is about DBA roles and how to apply those in a politically charged situation. We’ll also go into luggage and databases, upcoming events, the 60 second tip of the day […]