(Chris Webb) Here’s an issue that I’ve encountered many, many times over the years on the newsgroup and the SSAS MSDN Forum but which, for some reason, I’ve never blogged about until now. It happens from time to time that when people are developing a cube they find, mysteriously, that all the data h
Other News
SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution
(Pinal Dave) Earlier this year I wrote for a whole month on SQL Server Wait Stats and the series was one of the best reviewed I have ever written. The same series has been enhanced and compiled into a book as SQL Server Wait Stats [Amazon] | [Flipkart] | [Kindle]. The best part of this book is it is
Working with Records in FSharp
(Alok Pandey) Record is used to group different types of data into a single unit in structural format. Records are immutable by default. It is similar to structure in C language. Its values are separated by semicolons. A record definition starts with the type keyword then we simply define a series o
MYSQL GET DIAGNOSTICS
(Marc Alff) A new feature just got merged into mysql-trunk, the GET DIAGNOSTICS statement.
Integrating SPSS Model Scoring in InfoSphere Streams, Part 1: Calling Solution Publisher from an InfoSphere Streams operator
(Mike Koranda) Learn how to leverage the predictive power of SPSS in a real-time scoring environment. Part 1 of this “Integrating SPSS Model Scoring in InfoSphere Streams” series describes how to write and use an IBM InfoSphere Streams operator to execute an IBM SPSS Modeler predictive model in an I
Getting creative with Computed Columns in SQL Server
(Atif Shehzad) I have used computed columns in simple scenarios and these are working fine. However in some cases we are facing limitations while implementing business logic through computed columns. For example we are required to have different values based on a separate expression to determine the
Organic Computers
Organic Computers Dreaming about future technology is often rooted in current trends, failures, or fantasy. It wasn’t long ago the thought of nano-bots was mere science fiction. Today, there are so many things we can do. The primary question anymore is how do we pay for it? How can we make a living? How can we produce and package it […]
Some Dare to Predict
Some Dare to Predict I’ll be honest with you; I have no clue what is coming next. I foresee a lot of growth in distributed data and processing technologies. That is a bit of a wimpy prediction based on the current velocity. Agile SDLC will continue to grow. Even though it has not been shown to produce more successful software […]
Using the cost-based optimizer to improve Database 10g performance
(V.J. Jain) One of the many advantages of upgrading to Oracle 10g is that the cost-based optimizer (CBO) has been improved to allow for better performance by using a cost model that accounts for I/O and CPU. This cost model allows the optimizer to choose the best execution plans based on statistics
An XQuery Sequence question
(Dave Cassel) A while ago I was posed a question by a colleague: