(Siddharth Mehta) Distribution analysis is generally performed on quantitative data, by individually plotting data points on a graph. After plotting these points, visual clusters can be identified, which also helps in outliers analysis. This methodology is generally useful when data points are plott
Other News
Developer Tips: Making the SharePoint Transition
(Peter Vogel) If you’re an ASP.NET developer thinking about getting involved in SharePoint: Congratulations! You’ve picked an excellent time to get started — there’s been a tremendous evolution in the quality of the product and the tools available to you.
Example: Manipulating XML in Erlang
(Taylor Venable) I was playing around with xmerl, the XML application that comes with Erlang/OTP, and I found its user guide somewhat lacking in useful examples for manipulating XML as it is parsed.
XSLT security
In V5.3 it is possible to completely disable security for all descendants of WebControl (including XslFile). Simply set the property ‘DisableSecurity’ to ‘true’ on the control.
The ins and outs of MAXDOP
(Cindy Gross) One of the few sp_configure options that good DBAs regularly change is “max degree of parallelism” or MAXDOP. So of course everyone is looking for the one best value to use for that setting. As with most things in the database world, the answer is “it depends.”
Concurrent Statistics Gathering
(Ali Cakmak) Gathering optimizer statistics is one of life’s necessary evils even if it can take an extremely long time to complete. In this blog post, we discuss one remedy to improve the efficiency of statistics gathering.
Synchronising Recovery of two databases
(Hemant K Chitale) A recent forums question was about backup and recovery to be synchronised for two databases.
SQL Server Security: Encrypting Data
(Buck Woody) High security requirements exist in more places than you might think. The headlines are rife with examples of careless government and commercial employees that have left laptops unprotected, ruining the credit and privacy of hundreds of thousands of people that trusted them with their p
The DB2Night Show sets new records with TOP DB2 LUW Support Issues
(Scott Hayes) Episode #39 set a new record for studio audience attendee registrations. Attendees also rated this show very highly with comments like “all db2nightshows are great… and today’s one was no exception. thank you very much Scott&DBI” Our special guest was Julian Stuhler, Director Triton
Insert data in one table with data from other table(s)
This post is in response to this question from a reader: “Your post on updating data in one table with data from another table was very helpful. I need to also do an insert into a table (a summary table) with data from a bunch of other tables which are in the same database and also in database(s