(Baya Dewald) In part 1 of this series, I discussed Analysis Services trace events and columns, providing examples of when collecting each event and column would be useful. This article concludes our examination of how to monitor and tune your SSAS cubes.
Other News
On connections
(Domas Mituzas) MySQL is needlessly slow at accepting new connections. People usually work around that by having various sorts of connection pools, but there’s always a scale at which connection pools are not feasible.
Speed Test: String Concatenation
C# and the .NET framework provide several ways in which strings may be concatenated by appending the contents of one string to those of another. Some methods use immutable strings directly, others use mutable data to achieve faster performance.
Retrieving Table Data with the LIKE Operator
(Joel Murach) In this eighth part of a nine-part article series focusing on the SELECT statement and its usage in retrieving data from tables, you’ll learn how to use the LIKE operator and much more.
DB2 LUW Performance Analysis and Tuning Workshop at the DB2 Symposium
(Scott Hayes) The DB2 Symposium is returning to the US this September 21-23 in Chicago, IL. Based upon my very popular IDUG Ed Seminar “DB2 LUW Performance Analysis and Tuning Workshop”, I am pleased to offer an enhanced version of this seminar as a 2 Day class via the DB2 Symposium.
Getting MySQL Core file on Linux
(Peter Zaitsev) Core file can be quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which have security features to prevent core files to be dumped by setuid processes (and MySQL Server is most commonly ran changing user from “roo
Read/Write/Remove Create XML
(Dool_Cookies) This is a simple set of functions that will give the programmer the ability to read/write/remove and create element trees within an XML file.
Developing a Multi-Select ASP.NET GridView using JQuery
(Biswa Pujarini Mohapatra) GridView is a very common control used in all .net Web Application. Also selecting a single row or multiple rows is a very common task in GridView operation.
SQL Server Denali THROW statement to raise an exception
(Arshad Ali) Prior to SQL Server 2005, writing code for exception handling was painful for T-SQL developers. SQL Server 2005 introduced structured exception handling with BEGIN TRY…BEGIN CATCH blocks. Though this inclusion made managing exceptions in T-SQL programming quite easier, it has some lim
Usability
$$SWYNK$$ Usability Today, to finish up the week, I decided to take a topic that is as hard to nail down as Jello; usability. I am not a usability expert. But I do know when something doesn’t work. I’d like to pick on Facebook today because it is often held up as an example of modern usability. Frankly, I find […]