(Hilary Cotter) SANs (Storage Area Networks) are playing an increasingly important role in SQL Server environments for several reasons. They include: –The increasing size of the average database –The increasing prevalence of clustered environments –Performance advantages of SANs –Storag
Other News
Optimizing Storage Performance, Provisioning, and Manageability for Microsoft SQL Server
(Alex Osuna) Microsoft SQL Server has become very popular as a database environment driving a broad range of mid-level business applications, ranging from Customer Relationship Management (CRM) to eCommerce and from Enterprise Resource Planning (ERP) to supply chain integration. The combination of a
SQL Server Merge Replication, SQL Server 2008, DMVs and More
Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 3) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. Tweaking for High Transaction Loads When it comes to updating your storage subsystem for use with a high transaction load type implementation, you know that getting information can get pretty confusing. I know […]
Databases Tuned to Specific Functions? Where Would SQL Server Be?
Featured Article(s) Preparing to Install Failover Clusters Before you set up failover clustering it is important to verify whether you have the minimum hardware and software checks in place. In this article we shall examine what "minimum hardware and software" requirement means. In-Person, Outstanding Training Options Looking to get up to speed with in-person, instructor-led activities that will make sure […]
GUI Guidelines for Microsoft platform
(Sajad Deyargaroo) Graphical User Interfaces have become the most preferred user interfaces among the computer users. GUIs have made the work with computers much easier without any need to type all the commands on keyboard as in text-based user interface. Microsoft started experimenting with GUI sin
.NET Tip: Data Encapsulation: Using Properties Instead of Public Variables
(Jay Miller) I have run across some old code recently where some classes exposed public variables directly to the outside world. Even though the code works, it is very fragile. The code looked something like this: public class Person { public string Name; public int Age; }
Handling ASP.NET Errors at the Page and Application Level
(John Peterson) When people talk about error handling in ASP.NET, they’re almost always referring to either the Try…Catch…Finally syntax or the use of ASP.NET custom error pages. While both of these technologies are godsends, they’re not your only options. You can also handle errors programmatic
Defaulting Rules using PLSQL APIs
Order Management provides the ability to default a number of attributes onto the Sales Order Header and Lines based upon user-definable rules. For example, it is possible to default a Shipping Method onto the Order Header using the value assigned to the Order Type. As another example, it is possible
Oracle 11g’s Query Result Cache: Introduce Yourself to RC Latches
(Alex Fatkulin) In the previous article, I described my observations of RC Enqueue. Now it is time to take a look at the RC latches.
We are NOT Killbit-ing MSXML4!
(Nithya Sampathkumar) In March, we posted our intention to killbit MSXML4 and encouraged users to move to MSXML6 and asked for feedback – And we received lots and lots of it. The summary is MSXML4 is still being used extensively and the suggested timeframe for killbit seemed aggressive for most cus
