(Cameron Crotty and Jeffrey Berger) With new technology like solid-state drives, can you eliminate the need for REORG with your DB2 for z/OS data? In this article, take a look at the pros and cons, and examine the reasons why you will probably need to still have a plan for regular reorganizations.
Other News
Perfmon Counters to Identify SQL Server Disk Bottlenecks
(Matteo Lorini) There are several articles about identifying I/O issues related to SQL Server. There are various methods for finding I/O bottlenecks, so which performance counters are needed for a quick evaluation of a possible disk bottleneck?
SQL Server Install Without OS Page File
SQL Server Install Without OS Page File What is the impact, advantage or disadvantage when installing SQL Server on a windows machine that does not have a swap file for virtual memory? When optimizing a SQL Server, one of the things you audit is the weight of paging, swapping memory to disk to make room for other work, to determine […]
SSWUG TV – Interview with Denny Cherry, SQL Server MVP and SSWUG.ORG Class Presenter
Pro-Center Video Programming for IT Professionals
Big Data IS a very big deal
(Willie Favero) And the DB2Night Show has been doing its best to get all the right information out to you.
Adding an XSLT Extension
If you want to execute some C# code from an XSLT functions, you can create an XSLT extension object.
Using MySQL prepared statements with PHP mysqli
(Ulf Wendel) Starting with PHP mysqli is easy, if one has some SQL and PHP skills. To get started one needs to know about the specifics of MySQL and a few code snippets. Using MySQL stored procedures with PHP mysqli has found enough readers to begin with a “quickstart” or “how-to” series. Take this
Stress Testing Oracle ADF BC Applications – Passivation and Activation
(Andrejus Baranovskis) When we are talking with customers about Oracle ADF performance, very often we can hear such question – “Hey, ADF works well when there are few concurrent users, how it behaves when there is more serious load?”. In order to answer this question I will publish series of posts,
SQL Server 2008 – Performance review of Grouping Sets vs Native method of Group By clause
(Paresh Prajapati) Previously i have posted for the overview and usage of the Grouping Sets as how can we get the aggregate data of different group sets with GROPING SETS vs Native method of group by.
Global Events vs. Entity-Bound Events In JavaScript Application Architecture
(Ben Nadel) The more I try to learn about JavaScript application development, the more I tend to think that absolute decoupling is a myth. I know I’m quite inexperienced when it comes to building non-trivial, thick-client applications; but, the idea of being able to simply “assemble” an app using re