Tuesday, May 31, 2011

Black Clouds on the horizon

Last month’s outage of Amazon may have serious repercussions on the future of Cloud-based services and storage, and even business intelligence offerings in the cloud.

Like rolling blackouts, a disconnect from the cloud can kill business.  Uptime, especially for a large cloud provider, has to be seamless.  Like a hydro plant, it just has to work.

Although downtime for BI tools usually doesn’t equal the urgency of downtime for mail or web hosts, more than a day could be a killer for some apps.

Amazon outage sparks frustration, doubts about cloud - Computerworld

Lars Bjork of QlikTech, on Order vs. Bureaucracy - NYTimes.com

“Order is where you put a process into place because you want to scale the business to a different level.  Bureaucracy is where nobody understands why you do it. “

Lars Bjork of QlikTech, on Order vs. Bureaucracy - NYTimes.com

I would add, bureaucracy is where you put approvals for daily processes in place that exceed a single level of the company organization structure, and the company structure looks more like a family tree than a nicely trimmed hedge.

Friday, May 27, 2011

SQL Server Destination Vs OLE DB Destination and 64-bit Oracle Drivers

For some reason, SSIS team dropped the ball when dealing with 64-bit and SQL 2005.  Cryptic errors and non-working packages, and command-line workarounds were everywhere.  SQL 2008 has a “use 64-bit” option when scheduling the package.  However, there are still challenges with 3rd-party drivers.

Here’s a workaround to get Oracle 64-bit drivers going.

* Install Oracle 32 and 64 bit drivers, 11g i think, maybe first install 64 bit then 32 bit
* Install Attunity Oracle provider 64 bit
* Copy Visual Studio directory to new dir: C:\ProgFilesX86\

Should work now both in designtime (BIDS) and runtime (SSIS). Oracle is sensitive to () in the path of the calling app so everything under Program Files (x86) will fail. After normal installation of SQL Server, simply copy VS dir and start devenv.exe from there.

Use Attunity:s .NET provider in SSIS. Really fast and stable.

SQL Server Destination Vs OLE DB Destination

Monday, May 23, 2011

Glenn Berry's SQL Server Performance | Semi-random musings about SQL Server performance

Microsoft has always put limitations for licensing purposes on SQL Server.  Express edition could only use 2GB of RAM.  Standard edition was a laggard in terms of features in Analysis Services.  Most of the time this required our customers to purchase Enterprise edition, and possibly sacrifice a scale-out architecture for scaling-up.

Scale-up might not let you get around these limitations with SQL 2008 R2.  Datacenter edition might be the only option for those customers with > 8 CPUs.

What is new for SQL Server 2008 R2 Standard Edition and SQL Server 2008 R2 Enterprise Edition, are more restrictive hardware license limits compared to the SQL Server 2008 versions of both of those editions.

SQL Server 2008 Enterprise Edition had no limit for the number of processor sockets, but was limited to 64 logical processors. SQL Server 2008 R2 Enterprise Edition imposes a new limit of eight physical processor sockets, but will theoretically let you use up to 256 logical processors (as long as you are running on Windows Server 2008 R2). However, this is not possible, currently, since it would require a processor with 32 logical cores. As of April 2011, the highest logical core count you can get in a single processor socket is 20 (if you are using the new Intel Xeon E7 series). Also, the RAM limit for R2 has changed from “operating system limit”, as it was in the 2008 release, to a hard limit of 2TB.

SQL Server 2008 R2 Standard Edition  has a new RAM limit of 64GB. This lowered limit may catch many people by surprise, since it is very easy to have much more than 64GB of RAM, even in a two-socket server. You should keep this RAM limit in mind if you are buying a new server and you know that you will be using Standard Edition. One possible workaround for this limit would be to have a second or third instance of SQL Server 2008 R2 Standard Edition installed on the same machine, so you could use more than the 64GB limit for a single instance. The physical socket limit for SQL Server 2008 R2 Standard Edition is still four processor sockets.

Glenn Berry's SQL Server Performance | Semi-random musings about SQL Server performance

Monday, May 16, 2011

A Glimpse at Project Crescent - SQL Server Reporting Services Team Blog - Site Home - MSDN Blogs

Project Crescent seems to fall into the “shiny tool” space that Crystal Xcelsius occupies.  From a presentation standpoint, it pops.  Will it be a daily reporting workhorse?  Let’s see.

Click on the Crescent logo below to play the Project "Crescent" teaser video and experience Project “Crescent” from the Microsoft Company meeting where we originally showed over 70’000 people for the first time this unique ability to bring data to life:

clip_image002[6][4]

See the complete keynote at PASS Summit 2010 here: http://www.sqlpass.org/summit/na2010/

A Glimpse at Project Crescent - SQL Server Reporting Services Team Blog - Site Home - MSDN Blogs

Coming out of Microsoft there are a few tools that really made me turn my head a couple times and go “wow”.  Data Analyzer, an OLAP tool from early 2000 was one of those.

It had the ability to save as PowerPoint, which Reporting Services and even Excel couldn’t do.  It was discontinued after Office XP.  It took PerformancePoint to bring that “export to PPT” feature back to life.  And I didn’t know more than 2 people who actually knew what it was or used it more than twice.

Another tool I found innovative was Site Server 3.0’s Content Management link map.  It was decision tree style 3D interface that let you browse through your site like a spider’s web, with the capability of zooming into the web.

Looked something like this but in 3-D!

The Wikipedia article on Site Server just about sums up many Microsoft “Product as a Solution” offerings targeted at the gray area between technical and business users.

On this front, Site Server's main advantage was its low cost. Another feature that might have been a source of confusion was the taxonomy management system. The tools used to maintain item metadata were very basic and required a degree of technical familiarity foreign to most business users.

Site Server was discontinued after it’s 3.0 release in 1998.

Sounds a lot like PerformancePoint Planning.  Let’s rephrase that.

On this front, PerformancePoint Planning’s main advantage was its low cost. Another feature that might have been a source of confusion was the model management system. The tools used to integrate data were very complex and required a degree of technical familiarity foreign to most business users.

In the end, all things were absorbed by Sharepoint, except perhaps for that cool link visualization tool, and PerformancePoint Planning. 

Perhaps, in the next version of Sharepoint, Microsoft will have another cube model builder with integrated dimension data management and a powerful set of financial reporting tools.  Maybe even a cool 3D hyperlink visualizer too…

Wednesday, May 11, 2011

Canada Post - Householder Counts and Maps / Nombre de chefs de ménage et cartes

Building an application requiring map or postal code info for Canada?  Learn about the number of residences or businesses by postal code using this service by Canada Post.  Also includes PDF boundary maps.

http://www.canadapost.ca/cpc2/addrm/hh/current/indexp/cpALL-e.asp

Another service (paid) provides an updated database of postal codes with detailed address and lat/long information.

http://www.zipcodeworld.com/postalcodegold.htm

Canada Post - Householder Counts and Maps / Nombre de chefs de ménage et cartes

Monday, May 09, 2011

Insights (Business Intelligence) Demo 1 Version 3 - iwdemos - Site Home - MSDN Blogs

Sharepoint Insights demos for BI.

Overview

This SharePoint and Office 2010 demonstration Content Pack provides the content and scripts to support Insights Demo 1.  The goal of this demo is to demonstrate and communicate the value of Business Intelligence (BI) in SharePoint 2010. We highlight some of the “eye-candy” components that pop, and demonstrate some of the Enterprise Content Management (ECM), social media, and enhanced search capabilities of SharePoint 2010 along the way.  Please note that this demo is not designed to “sell” a particular feature, BI solution, or application. Rather, it seeks to demonstrate a sweep of Microsoft BI solutions (except SRS). We aim to show that BI is not merely a backward-looking set of data analysis tools to be used by executive management or financial analysts.  Providing flexible BI solutions with SharePoint makes key business data accessible to mid-tier employees in an organization, to be used in daily decision-making and planning.  It is intended for use with a specific Virtual Machine listed in the Installation & Setup section.

Insights (Business Intelligence) Demo 1 Version 3 - iwdemos - Site Home - MSDN Blogs

Friday, May 06, 2011

Resources for Learning about Microsoft Business Intelligence - SQL Server and the Data Platform in the Field - Site Home - MSDN Blogs

A verbatim repost of a great training linkfest from Clint Kunz.

Resources for Learning about Microsoft Business Intelligence - SQL Server and the Data Platform in the Field - Site Home - MSDN Blogs

Wednesday, May 04, 2011

WMIC - Windows Management

With 6000+ attributes available to monitor in Windows XP this command line tool is very underrated.

WMIC.exe

Windows Management Instrumentation Command.
Read a huge range of information about local or remote computers. Also provides a way to make configuration changes to multiple remote machines.

WMIC - Windows Management

Monday, May 02, 2011

Gartner Predicts the Future

I wonder what BI tool they’re using for that one… must be something in-house.

Four key BI predictions to help organizations plan for 2011 and beyond.

Gartner Business Intelligence Summit e-newsletter

Friday, April 29, 2011

Gartner Magic Quadrant for Business Intelligence Platforms- Microsoft is the leader - My Application Platform Quotes - Site Home - MSDN Blogs

Gartner is the leader in creating Magic Quadrants.  Microsoft is now the leader for Business intelligence, according to Gartner.

clip_image001

The niche market is becoming quite cluttered as the big players acquire and knock-out specialized tools in favour of mass markets and commoditization.  Panorama, a company I worked with in the past, seems to have fallen a bit out of favour.  Microstrategy is becoming a leader in the BI space and I think it’s a big potential acquisition target for one of the bigger vendors, if they decide to split their stock, and if the stock wasn’t as overvalued as it appears to be in my opinion.

With the stock on the way to $140/share, Microstrategy and it’s Ipad 2 strategy appears to be working.  MSTR has a market cap of under $2 billion.  Microsoft has $217 billion. IBM - $200 billion. Oracle - $172 billion. Apple - $317 billion(!)

There should be more consolidation in the future… but perhaps MSTR will be staying independent for awhile longer…

Gartner Magic Quadrant for Business Intelligence Platforms- Microsoft is the leader - My Application Platform Quotes - Site Home - MSDN Blogs

Monday, April 25, 2011

Data Warehouse versus Business Intelligence - Executing a business service with precision - Site Home - MSDN Blogs

Daniel Rubiolo blog about his view of Business Intelligence, with some great metrics on the components and percentage of resources dedicated to a BI solution.

The traditional definition of “data warehouse, or DW” from late ‘70s/early ‘80s involved the end-to-end solution for business users… from extracting data and aggregating it into special data models, the queries, all thru the applications/reports the users interacted with to consume that data.

According to Daniel, a BI project is 70% getting the data and 30% showing it off.  I would suggest it fits with the 80/20 rule in most cases.  80% of the time and effort in a BI project would be sourcing the data and gathering requirements, designing, developing, testing, and deploying a solution.  20% of the time would be adjusting and presenting reports.

This is probably why PowerPivot is such a favourite for power users, since they don’t necessarily require outside IT resources to build their models.  It becomes a 50/50 game with a faster ROI.  However, scalability and maintainability of a solution that resides on a user’s desktop remains in question.  The “hit by a bus” rule makes desktop-based custom models a potentially risky solution for a business

Data Warehouse versus Business Intelligence - Executing a business service with precision - Site Home - MSDN Blogs

Friday, April 22, 2011

Business Intelligence Recap of 2010 - Microsoft Business Intelligence - Site Home - MSDN Blogs

Emilie Bridon provides a BI recap of 2010 in the Microsoft space.

The one that has me interested is BISM.  Sounds like it might finally provide a central “one truth” version of your metadata.  However the limitation of requiring Visual Studio might kill any hopes of leveraging it from a pure business perspective.  Users that I work with need to be able to manage their data without an IT gatekeeper.

Can’t see anything else that excites me a whole lot with the BI space in 2010, except perhaps with Social media.  It was truly an acquisition and consolidation year…

Business Intelligence Recap of 2010 - Microsoft Business Intelligence - Site Home - MSDN Blogs

Monday, April 18, 2011

Michael J Swart - Database Whisperer

 

Michael posts his Study Plan for 70-433 exam and details on SQL 2005 support

Yesterday was April 12, 2011, and as far as I know mainstream support for SQL Server 2005 ended. See Aaron Bertrand’s A Quick Note About SQL Server 2005 Mainstream Support.

Michael J Swart - Database Whisperer

Upgrading to SQL 2008 R2

With SQL 2005 support expiring shortly, the move is on to switch to SQL 2008 R2 (why would you switch to just SQL 2008?)

Running upgrade advisor before the upgrade is a must.  However, some of the warnings could safely be ignored rather than changing a potentially large codebase.

I have seen many people asking how shall they move towards upgrading their SQL Server 2000 Database to SQL Server 2008. I thought of putting together an article based on my experience where I have migrated many servers from SQL Server 2000 to 2008. This particular Article is about analyzing incompatible code which is a MUST step in my view. At end of this article, I have compiled list of various errors/warning that you may come across after running analysis tool.

SQLVillage.com

Friday, April 15, 2011

Using Quest’s Spotlight?

Watch for the performance effects of running SQL Analysis on a production box.  It is running a firehose client-side trace from the Spotlight server to the SQL Server.

Based on your information, it would appear that someone in your group may be using SQL Analysis or session trace in the product. SQL Analysis is a schedulable utility that initiates a SQL Trace based on the criteria you specify - if it's enabled with the collection type default and only the options on the initial screen specified, you may be running a continuous client-side trace without any filtering to capture the various statement/procedure/RPC events. Session-level tracing initiated if someone clicks into a specific SPID (session_id) and then selects the trace tab, so it's a less likely option.

Spotlight on SQL Server Ent. 701 - ... | SQL Server | Database Management Community | Quest Software

Wednesday, April 13, 2011

Stored Procedure Recompiles and performance

Recompiles to a stored procedure can cause performance issues.  Other than WITH RECOMPILE, sp_configure, or a server restart, what else can cause a recompile?

We often use SET option in stored procedure without realizing if it can cause performance problem. I was working on Critical Database Performance issue recently arguing on SET option causing recompile without realizing which one causes or which one not. Moreover I came across in situation when some experts mentioned that "set isolation level read uncommitted" and "set nocount on" are causing recompilation. Whereas truth is these options DO NOT cause recompilation. So I thought of putting following list available handy for reference whenever we write code or optimize code or find stored procedure recompiling due to "set option changed".

SQLVillage.com

Friday, April 08, 2011

Brent Ozar - Too Much Information

Brent goes into detail about how important functional requirements are versus fuzzy requirements.

do you want it to be 10% faster, 100% faster, or 1,000% faster?

Brent Ozar - Too Much Information

1000% please….

Statistics in SQL and Finance

Correlation is important when dealing with risk management or forecasting calculations.  The closer to 1 you are, the closer the numbers are correlated.  Consider if you purchase GOOG and MSFT stock.  Since they are both in the tech sector, they could be part of a combined selloff, which means your risk is increased if you own both in your portfolio.

The Select Sector SPDRs Correlation Tracker identifies GOOG as being 0.46 correlated to MSFT, which appears low. 

You can use Correlation for forecasting results and determining trends in SQL.  Consider this query:

SELECT (COUNT(*)*SUM(x.Sales*y.Sales)-SUM(x.Sales)*SUM(y.Sales))/( SQRT(COUNT(*)*SUM(SQUARE(x.Sales))-SQUARE(SUM(x.Sales)))* SQRT(COUNT(*)*SUM(SQUARE(y.Sales))-SQUARE(SUM(y.Sales)))) correlation FROM BulbSales x JOIN BulbSales y ON x.month=y.month WHERE x.Year=1997 AND y.Year=1998

Transact-SQL Cookbook: Chapter 8: Statistics in SQL

If the correlation is closer to 1, the numbers are similar.  Comparing various years and months of sales or expenses can easily uncover correlations.  This could also work for tracking correlation dependencies between expenses and revenue.

SQL has a number of formulas that are useful for identifying patterns and trends in your data.

Thursday, April 07, 2011

Alerting for PerformancePoint and Excel

Bidoma is an email/desktop alerting engine that notifies of changes to Excel worksheets and PerformancePoint dashboards. Could be a good measure for spreadsheet controls, master data management and timely responses to KPI changes.

Our Products | Bidoma.com

Sunday, April 03, 2011

Dashboard Design - the definitive guide

Paul Turley has a list of books and articles to read around dashboard design.

I will begin by reviewing these books and discuss the pros, cons and the applicability to the subject of dashboard and KPI design using the Microsoft product stack.

https://sqlserverbiblog.wordpress.com/2010/12/16/dashboard-and-kpi-designthe-definitive-industry-standard-2/

Tuesday, March 29, 2011

PerformancePoint Planning limitations

For those of you (like me) with customers still using PerformancePoint 2007 Planning, there are some limitations to be aware of.

http://social.technet.microsoft.com/forums/en-us/ppsplanning/thread/12A9AD9D-BF5F-4A28-98CD-7827AC75C061

It has nothing to do with how many dimensions there are in a model.



It has everything to do with how many dimensions are in a model site, how many models are in a model site, and how many member sets are in a dimension. It seems that if you add all dimensions, all hierarchies, and all models in a model site they cannot exceed 128 or else you get this error.

The staging database contains a table which can assist to ensure that these limits aren't exceeded.

select * from fk_relationships where scope =

Saturday, March 19, 2011

SQL Execution Plan Tuning

Two ways to find what's going wrong with your queries.

Execution plans! Don’t you just love them? They’re the first thing you look at when tuning a query or a stored procedure. But what do you do if you have a gigantic query play with 10’s of nodes? how do you find the most complex one? Where do you start?


http://weblogs.sqlteam.com/mladenp/archive/2010/01/21/SQL-Server-ndash-Find-the-most-expensive-operations-in-Execution.aspx


SQL Sentry
http://www.sqlsentry.com/plan-explorer/sql-server-query-view.asp

My hammer approach is to just save the query plan and then reopen in full screen.

Wednesday, March 16, 2011

Saving time and money with BI Business Appliances

A black box appliance might be better in some cases than one where you can shoot yourself in the foot if you configure the drives incorrectly.

All I can say is the last couple of projects I have been on related to configuring and installing SQL could have been solved by just clicking the Buy button on this.  However, if you need 128GB of RAM instead of the default 96, or a special PCI card for your SAN you're out of luck.  It's not expandable.

The pros and cons and performance of the MS HP Business Decision Appliance from one reviewer.
http://www.sqlmag.com/article/business-intelligence/BI-Appliances-vs-Standard-Servers-and-Reference-Configurations.aspx

Monday, March 14, 2011

SQL Azure - Linked server from local Sql server

Here's one way to simplify accessing Azure.  Create a linked ODBC Server.

Not sure about performance on this one, and be aware there's a chance it could pull all your data down from the cloud, emptying your wallet in the process.

http://blogs.msdn.com/b/sqlcat/archive/2011/03/08/linked-servers-to-sql-azure.aspx

Wednesday, March 09, 2011

Fire more free SQL downloads

courtesy of Brent Ozark.  Cleartrace and SSMS Tools Pack are my daily use tools.

So you’re lazy and you’re company’s broke – what to do?  Here’s my favorite free downloads to help manage SQL Server:

Read more: http://www.brentozar.com/archive/2011/02/my-favorite-free-sql-server-downloads/#ixzz1FNZw8jt5

Sunday, March 06, 2011

5 (now) Free SQL Tools

Atlantis Interactive provide next-generation free SQL tools specifically tailored for performance and ease of use when architecting or administering large Microsoft SQL Server database systems.


Includes an SSMS app with additional features, SQL compare and data compare, table space analyzer, data visualization and analysis, and schema/metadata dependency and analysis tools.


http://www.atlantis-interactive.co.uk/blog/default.aspx

Definitely worth the download(s)

Thursday, March 03, 2011

Resmon - Resource Monitor for Analysis Services

Teo Lachev posts about a new resource monitor tool for Analysis Services.

Greg Galloway just published a ResMon cube sample on CodePlex that aggregates execution statistics (rolls up information about Analysis Services such as memory usage by object, perfmon counters, aggregation hits/misses, and current session stats) from Analysis Services dynamic management views (DMVs) and makes it easily available for slicing and dicing in a cube. I think this will be a very useful tool to analyze the runtime performance of an Analysis Services server or as a learning tool to understand how to work with DMVs. Kudos to Greg!


http://prologika.com/CS/blogs/blog/archive/2010/11/04/resmon-cube-sample.aspx

Tuesday, March 01, 2011

Feature pack for SQL 2008 R2

The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.


As with other releases, SQL 2008 R2 has a feature pack which is required for standalone installs of certain components, and adds additional functionality to the product.

Saturday, February 26, 2011

Sql-Rd addon for Reporting Services

For those looking for Report Bursting and other complex scheduling, exporting, and printing requirements, this tool fills in the blanks with Reporting Services.

SQL-RD is a dynamic, flexible, function-rich and intuitive automation tool for scheduling, exporting, distributing and delivering your Microsoft® SQL Server Reporting Services (SSRS) Reports.



SQL-RD contains powerful system, event and business process automation functions which will make an instant impact on the efficiency of your business.

A couple of the cool features I saw were bulk printing to multiple printers, SMS text messaging, Zipped/PGP'd reports, deferred delivery, even an export to DBase option...

Thursday, February 24, 2011

Two new tools for diagnosing performance bottlenecks with SQL

TraceTune is designed to read SQL Server traces and tell you which SQL statements or or stored procedures are consuming the most resources. TraceTune is the online version of ClearTrace and is maintained by scaleSQL Consulting.


http://www.tracetune.com/





Project Lucy analyzes performance data that you upload. It gives you deep analysis and leverages the collective intelligence of other Project Lucy users.


Nothing wrong with just using a few DMVs either.

Monday, February 21, 2011

On DESKI, Proclarity, and Executive Crystal (Ball) Decisions

Sometimes I wonder whether BI vendors actually use their own tools to look at their market.  If they do, then perhaps they are missing the "sentiment" KPI.

Microsoft lost a bunch of sentiment points by discontinuing BI tools like Proclarity and PerformancePoint planning.  Proclarity as a desktop and dashboard tool met quite a few needs for my clients that aren't filled anywhere else without jumping up price point notches and complexity.  I'm still supporting PerformancePoint, the discontinued flavour.

Now it appears that SAP has taken a similar approach, dropping their desktop client DESKI in favour of their web client WEBI.  Which, of course, has less functionality.  Web apps just don't feel as concrete, physical, or hardened as desktop apps.  Although the technologies are coming together more and more, desktop apps still have points over ease of use and functionality.

How come the BI vendors don't ask their clients how they can serve them better rather than analyzing the P and L for quick-hit cost savings?

IBM (Cognos (formerly SAP (formerly BusinessObjects (formerly Crystal))) developers are an angry bunch!

Am I missing a bracket or two there?

Friday, February 18, 2011

BI in the Cloud or Head in the clouds?

Last week I went to a .NET user group presentation for Microsoft's Azure cloud computing platform.  The topic, though a bit dry, was interesting.  Cloud storage confuses me a bit since I'm a relational database kind of guy.  Azure Cloud Storage provides a basic API to store BLOBs (binary objects like images, music or video) in its massive redundant storage data centers.  It has 3 major types of semi-structured or unstructured storage:
  • Blobs
  • Queues
  • Tables
The coding examples actually offended my sense of good form with databases and coding, probably since the opposite design philosophies are true for Azure Storage apps versus relational database apps.  Or at least this is what I got from the presentation, which might be a bit off.
  • Keys are no longer supposed to be small, integer, incrementing for performance.  
  • Keys are long strings, sometimes with pipe delimiters.  
  • There is no concept of ATOMIC transactions - the app does the work.  
  • A table can hold two different types of object information (invoice/invoice details) with the key differentiating.   Duplicate data is replicated everywhere.  
  • Message Queues have a chance of dropping data which the app needs to handle.  
  • There are limits to the scalability of requests and storage size that the app needs to be aware of and design around.  
  • There's only 1 key on a table, so searching against a non-partition-key field causes table scans.
  • It's better to update / merge data than to append to the end.
The cloud will scale to terabytes, petabytes, exabytes of data depending on your budget, however good luck doing any complex searches against your metadata.  Seems rather painful right now.

Many of the stable, reliable, tried-and-true server and developer tools available outside the "cloud" provide a huge step up in terms of ease of development effort and data quality.  Why are we taking steps backwards in development to accommodate buzzwords and marketing stories?  Is there really a great benefit to moving your enterprise into the cloud?

Cloud in simple words is 'Pay as you use'. Cloud computing is analogous to the way we pay for our utilities like electricity or water based on the consumption. The underlying Infrastructure is owned  and managed by some third party and cost is billed to us in form of units consumed - BI In the Cloud


Driving around eastern Ontario a couple weekends ago, I was amazed by all the farms and houses having solar panels that weren't there last year.  I told my wife some salesperson was doing a good job.  This type of micropower distribution structure seems like the way of the future; not a huge smoke-belching power plant.  Why isn't it the same for the cloud?


The thing that bothered me the most though?  MS has Azure Cloud Data Centers around the world.  But no Azure Cloud Data Centres, eh?  I guess Canada is considered Northern US to the Redmond folks...  :)

Tuesday, February 15, 2011

SAP upgrades its BI tools to 4.0 release

"This release is huge," said Dave Weisbeck, senior vice president of BI and EIM solution management. "Every single tool has had some major upgrades. There's not a single place we haven't touched."

One of my clients I worked with in the past had 2 different versions of their BusinessObjects Universes, with 2 different versions of client and server toolsets running. This was due to the poor migration story BO had, with reports and client tools losing functionality and formatting, a parallel-server migration, and an angry user base (and double the administration) as a result. Hopefully this doesn't happen with the new SAP 4.0 BI tools and there is a clear upgrade path and roadmap.

SAP purchased Sybase last year. Sybase created the original Microsoft SQL product, and MS branched off with their own codebase in SQL 7, further in SQL 2000.  Interesting how many of the BI vendors with a long history (Cognos, Sybase) are being consolidated into the mega software conglomerates.

There may be more than five computers in the world, however it's slowly looking like there's only going to be 5 enterprise BI companies soon..

  • IBM
  • Oracle
  • Microsoft
  • SAP
  • The little guys

Saturday, February 05, 2011

Windows® API Code Pack for Microsoft® .NET Framework

Windows® API Code Pack for Microsoft® .NET Framework provides a source code library that can be used to access some features of Windows 7 and Windows Vista from managed code. These Windows features are not available to developers today in the .NET Framework.

http://code.msdn.microsoft.com/WindowsAPICodePack

Wednesday, February 02, 2011

Office Converters and HTML Viewers

In support of Microsoft’s ongoing efforts to increase the interoperability of its various technologies, we have partnered with Dialogika to create a translator that converts the Microsoft Office binary file formats (.DOC, .XLS, and .PPT) into the Office Open XML standard format (.DOCX, .XLSX, .PPTX).



Enables OpenXML documents to be viewed on any client system in any browser as HTML, and includes an add-ins for Internet Explorer, Firefox and Opera (Windows/Linux)


http://www.interoperabilitybridges.com/projects/openxml-document-viewer


Enables bi-directional interoperability between Microsoft Office (Open XML) and Open Office (ODF) file formats


http://www.interoperabilitybridges.com/projects/openxml-document-viewer


Friday, January 28, 2011

SQL Server - New Drives Use 4K Sector Size - CSS SQL Server Engineers - Site Home - MSDN Blogs

Bob Dorr talks about drive sectors, new standards, and implications on SQL Server.  Somehow this seems to me to be a conspiracy to sell SQL bundled with appliance hardware that is already configured for SQL. I can see why there is a move to a SQL operating system and dedicated appliances rather than dealing with all the intricacies of the o/s and 3rd-party hardware, firmware updates, drive arrays and configuration, memory settings, disk alignment, partitioning, raid configurations, etc.

The implications of incorrect drive sector settings?  Risk of losing data, slow performance and not being able to restore databases to upgraded hardware.

In a lengthy discussion this past week I was reminded that Jan 2011 is when the hard drive manufactures agreed to focus on drives with sector sizes of 4K.    I have read all the latest materials about this over the past week and you can too.  Just search for 512e or Advanced Format Sector sizes and you will find the same articles I read.  I concentrated on articles by Seagate, Western Digital and other manufactures.

Why am I talking about this on a SQL Server blog? - The change has impact to your SQL Servers.   There are two areas you need to be aware of.  PERFORMANCE and DATA INTEGRITY

SQL Server - New Drives Use 4K Sector Size - CSS SQL Server Engineers - Site Home - MSDN Blogs

TwInbox - Use Twitter directly from Outlook.

Twinbox + Access Linked Table to Outlook Folder = Quick and dirty Twitter mining.

If you want to archive your twitter posts, search posts offline, or just hack around with the data, Access allows you to link to Outlook folders, including your Twinbox folders.

If you are using Twitter and Outlook and haven’t tried Twinbox, you’re missing out.

http://msdn.microsoft.com/en-us/library/aa164914(v=office.10).aspx 

TwInbox - Use Twitter directly from Outlook.

Thursday, January 20, 2011

Programming Solution

Taking the U out of CRUD for performance reasons.

So, to conclude, we can say that if we have to do many updates in a very large table (table with several million rows), we can avoid update statement and use select and insert.

Programming Solution

Monday, January 10, 2011

Exists + Descendants function

Returns the set of members based on the member attribute in MDX.

EXISTS(DESCENDANTS([Account].[COA],,leaves),  [Account].[AccountType].[Revenue])

IBM Information Management Software for z/OS Solutions Information Center

Thursday, January 06, 2011

VBA Functions in MDX | Programming Solution

Left, Right and Contains in MDX.

There are some VBA functions that are implemented in MDX code base and so they are faster than using VBA functions. We can call them “internal VBA” as by Irina Gorbach. Here we will see some example of such “internal VBA” in MDX.

VBA Functions in MDX | Programming Solution

How to Use Excel's CUBESET Function | eHow.com

For Cube function reporting in Excel, one function that doesn’t get translated during a pivot table formula convert is CUBESET.

Here is a way to get the leaves (lowest levels) of a dimension using the cube set formula in Excel 2007/2010.

=CUBESET(connectionstring,filter([Account].[AcctHier].members,isleaf([Account].[AcctHier].currentmember))","Account Leaves")

To retrieve the members, create a list of numbers ending at the CUBESETCOUNT() of above, and use the following formula:

=CUBERANKEDMEMBER(connectionstring,

CUBESET(connectionstring,filter([Account].[AcctHier].members,isleaf([Account].[AcctHier].currentmember))","Account Leaves")

,1))

Retrieves the first member of the set.

How to Use Excel's CUBESET Function | eHow.com