Top 10 Tips for Optimizing SQL Server Performance SQL Server performance management requires serious time and energy. In this new white paper by Kevin Kline, discover detailed guidance on the issues you can relate to—from cache trashing to bad T-SQL that can return to haunt your applications. See how to maximize database scalability and efficiency with ease. Read More Backups […]
Other News
Three Ideas to Maintain Database Availability and Performance
(Dave Beulke) Organizational demands for application database availability, reliability and performance for petabytes of big data and 100s of billions of rows of information continue to rise.
Configure WebLogic Resource Adapters with ANT
(Edwin Biemond) When you use a JCA adapter in Oracle SOA Suite or OSB then you know that you need to configure a plan of some WebLogic Resource Adapter. With this ANT script I tried to make this an easy task for you and which you can repeat on different WebLogic Domains.
Range Indexes and Empty Elements
(Dave Cassel) I’ve started a couple posts lately, only to find them more complex than expected. So to get myself back on the board, tonight you get a pretty simple one, based on an error one of my colleagues encountered recently. Suppose we have an int range element index set up on in our M
Classifying ADF Task Flow Navigation Choices
(Chris Muir) Having written the Angels in the Architecture: An ADF Application Architectural Blueprint presentation in 2011 it spawned a number of side projects which I had scribbled down but taken no further. Starting at Oracle has given me a little more time to rummage through my notebooks and tur
Recovering a SQL Server Database from Suspect Mode
(Satnam Singh) A couple of days back at I got a call from my support team informing me that one of our database located on the Production Server went into Suspect Mode. The version used was SQL Server 2005 Service Pack 3. Being a Production Database server, it was a Priority 1 incident and the expec
Enabling Automatic Documentation Comments
(Richard Carr) XML documentation comments allow code to be decorated with information about its usage. Visual Studio can assist in generating these comments by expanding a special comment symbol into a series of comment placeholders, which can be completed manually.
Configurable policy settings for user profile properties
(Reeza Ali) Each user profile in SharePoint Server 2010 contains 46 default user profile properties. These user profile properties store information about a user. An administrator can apply a policy to a user profile property to configure how personal information is used. Depending on the selected u
Two Partitioned Indexes with different HIGH_VALUEs
(Hemant K Chitale) Here is a quick demonstration to show how a Partitioned Table can have two different indexes seemingly on the same leading column but with different HIGH_VALUEs.
Creating Your First SSAS 2012 Tabular Project
(Sam Vanga) No matter how simple it is, new things come with some confusion; at least until you get used to it. Analysis Services 2012 Tabular is no different. This post will look at steps to create your first Tabular project.