Friday, July 29, 2011

2014–The year a Cray supercomputer becomes self-aware, assumes control

Perhaps it will be sooner?  The new Cray’s achieve 50 petaflops, so all they need to do is get some biological computing interfaces hooked up to the processor to truly think for themselves as an organic being. 

Amazing that in 1984 we were using 4.77MHz machines to draw lines on the screen and 30 years later we’re looking at not only simulating life, but replicating it.

Engineer and inventor Ray Kurzweil believes that the human Brain is capable of a comparable processing power of about 10 PFlop/s. Of course, there are different opinions and a rather scientific experiment to estimate the computational ability of the human mind by IBM engineers concluded that our brain may be closer to about 38 PFlop/s and a memory of about 3584 TB. At the current speed of progress, we may be able to simulate a human brain as early as next year or, by IBM’s estimates, within 3 years.

Supercomputers Challenge Human Brain | ConceivablyTech

Thursday, July 28, 2011

Intel code guru: Many-core world requires radical rethink • The Register

The new 50 and 100-Core CPUs might actually slow down some programs?  Here’s how.

"We think 'Oh, there's something I'm computing. I'll compute it once and put it into a variable'. Well, if you put it in a variable, and then a hundred processors access that variable to get that data, you've got a bottleneck. But if all one hundred of them computed it, no bottleneck," he said.

"Boy, is that foreign to my brain," he confessed.

We suggested that our generation might have to wait for our kids to become programmers before this new way of thinking became the new standard. "I hope not," he chuckled, noting that although today's programmers may have to learn a new mindset, they do have one great advantage over the next generation of code monkeys: experience.

Intel code guru: Many-core world requires radical rethink • The Register

The GPU-processing mindset is quite similar.  Who would have thought that running applications in the GPU would dramatically increase processing power of otherwise standard hardware.  However, it requires programming specifically optimized for the GPU which many programmers wouldn’t pick up on.

Before you go optimizing for a GPU, watch for the FSA, a GPU+CPU architecture that is transparent to developers.

http://www.extremetech.com/computing/87326-amd-fusion-system-architecture-moves-to-unify-cpus-and-gpus

I wonder how fast email would come up with this one…

http://www.zdnet.co.uk/news/emerging-tech/2011/05/25/cray-taps-gpus-for-50-petaflop-supercomputer-40092887/

The XK6, announced on Tuesday, is made up of multiple supercomputer blade servers. Each blade includes up to four compute nodes containing AMD Opteron CPUs and Nvidia Tesla-architecture GPUs. It marks Cray's first attempt to blend dedicated GPUs and CPUs in a single high-performance computing (HPC) system.

Why does it look like they put in just enough blades to spell CRAY XK6?

The world’s most powerful computer currently runs at 2.5 petaflops.  The Cray beast will run at 50.

save attachments vba - Google Search

This script may be useful to automate the constant email task of saving attachments. It can be applied as an Outlook rule to automatically save attachments for mail messages with a certain subject or sender. It should only be used against trusted senders and with a uniquely identifiable subject so as not to download corrupt or damaging files.

It is saved into the “c:\attach\” directory, however this could be substituted for a network share or Sharepoint folder in the code below.

To setup this rule in Outlook:

1. Tools – Macro – Visual Basic Editor

2. Right-click on Project 1 – Insert Module

3. Paste code below

4. Close window

5. Send yourself a message with the subject and attachment you want, or select an existing message.

6. Right-click on the message – Create Rule

7. Check sender and subject contains and select a part of the subject line that could be used to uniquely identify the email.

8. Click Advanced Options, confirm options and click Next

9. Check 'run a script', click 'a script' select Project1.SaveToFolder

10. Click OK

To turn off the rule:

1. Tools – Rules and Alerts – Uncheck or Delete the rule.

‘<CODE >

Sub SaveToFolder(MyMail As MailItem)

Dim strID As String

Dim objNS As Outlook.NameSpace

Dim objMail As Outlook.MailItem

Dim objAtt As Outlook.Attachment

Dim c As Integer

Dim save_name As String

'Place path to sav to on next line. Note that you must include the

'final backslash

Const save_path As String = "c:\attach\"

strID = MyMail.EntryID

Set objNS = Application.GetNamespace("MAPI")

Set objMail = objNS.GetItemFromID(strID)

If objMail.Attachments.Count > 0 Then

For c = 1 To objMail.Attachments.Count

Set objAtt = objMail.Attachments(c)

save_name = Left(objAtt.FileName, Len(objAtt.FileName) - 4)

'save_name = save_name & Format(objMail.ReceivedTime, "_mm-dd-yyyy_hhmm")

save_name = save_name & Right(objAtt.FileName, 4)

objAtt.SaveAsFile save_path & save_name

Next

End If

Set objAtt = Nothing

Set objMail = Nothing

Set objNS = Nothing

End Sub

Private Sub Application_Startup()

'MsgBox "Welcome, " & Application.GetNamespace("MAPI").CurrentUser

Application.ActiveExplorer.WindowState = olMaximized

End Sub

‘</CODE>

Excel Hacks book

save attachments vba - Google Search

Thursday, July 21, 2011

SqlASDoc

Document your Analysis Services databases.

Analysis Services Documenter (SqlASDoc for short) is a tool which creates documentation for your Analysis Services 2005 and Analysis Services 2008 databases. It connects to your live server, and queries the metadata for the name and description which the developers attached to every object (database, cube, dimension, hierarchy, attribute, translation, data source, data source view,...). It then produces an HTML file which contains the name and description of all these objects. But there is more: also other properties, such as last processing time, creation time, sizes of fact tables etc. are written to the HTML file.

SqlASDoc

Trust-building with Lync

Business Intelligence analysis doesn’t have to be just about the numbers.  Unstructured information contains perhaps more valuable insight into day-to-day activities than financial or KPI data.

Here’s one add-in for Lync which lets you analyze your relationships via messenger conversations.

Conversations Analyzer is an application that reviews your Microsoft Lync instant messaging (IM) conversation history and gives you scores for your use of trust-building language in day-to-day communications with business associates and friends. Conversations Analyzer applies trust rules to determine the occurrence of words and phrases that have a positive or negative effect on trust.

Chad McGreanor's Blog

Saturday, July 09, 2011

Updated Analysis Services Whitepaper

http://sqlcat.com/whitepapers/archive/2011/06/02/sql-server-2008r2-analysis-services-operations-guide.aspx\

Last month's release of an updated Analysis Services Operations guide.

Abstract: 
This white paper describes how operations engineers can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2.

Thursday, July 07, 2011

SQLBI - Marco Russo : Microsoft updates its BI Roadmap - #ssas #bism #teched #powerpivot

Curves, forks, and dead-ends in the roadmap of MS BI.  Avoiding MDX in favor of SQL may no longer be an option when the MS “Universe” data model layer is adopted.

I just hope MS provides some tools that an end-user could use to maintain these BISM schemas, without having to understand DAX and MDX.  And Visual Studio, or anything else over 500MB, is not a client tool that can be easily deployed.

Why not put this stuff into Sharepoint or Office?  Building BISMs in Excel seems to be a good idea to me.

Thus, we'll have a single unified model, called BI Semantic Model (BISM). BISM will have two technologies to model data: the Multidimensional one (formerly known as UDM) and the Tabular one (that will be an enhancement of the current PowerPivot data model experience). You will have two languages, MDX and DAX, to define business logic and to query the model. And you will have two engines, MOLAP and Vertipaq (with their corresponding counterpart for accessing data in passthrough mode, ROLAP and Direct Query). The great and wonderful big news is that in BISM it will be possible to combine these components as you need: DAX query over a multidimensional model, MDX Script over a Tabular, and any client able to access to any model.

SQLBI - Marco Russo : Microsoft updates its BI Roadmap - #ssas #bism #teched #powerpivot

Sunday, July 03, 2011

Fascinating concept - Using Processing for data visualization

Pointclouds and heatmaps are my favourite visualization tools.  Here is one example of how a city (in this case a video game city) could be mapped to show where the most accidents or other incidents occur.

http://www.vizworld.com/2011/05/heatmaps-point-clouds-big-data-processing/