These days making finances became very hard for most of the people. That is why the necessity occurred to know how to husband money in the best manner for living a normal and complete being. The essential question that any individual is interested in is how to manage my finances and not to face with bankruptcy cases in business or at home. In what way to secure a family and you from lack of money? It is difficult to answer this question, but the only thing you should definitely know is how to control finances professionally.

You can meet many people who can state that they know how to manage finances perfectly. Relying on the words of many specialists, their clients also claim that the investments they made are made in the right way and weighed. The states of clients may be so assured because they have the success in business today and get very interesting returns. But the fact you should remember is that times may change and sooner or later business deals face with mistakes. Business cannot remain successful all the time. So, when the crisis happens, most of the businessmen start to realize that the investments they define as being wealthy are the incorrect made choices.

In order to get rid of probable situations, you should work hard and try to learn in what way it is better to husband your cash and reach the success. Below you will find some tips that will be useful for you.

The first point is your understanding of that the money crisis does not notify when it is going to happen. That is why you should realize that it may occur at any time and it is impossible to predict it. Your task is to make wise investments so that if the financial crisis occurs they remain out of the crisis affect.

You should be aware of all ways and techniques of managing your cash. You should choose the money adviser who will be able to show you the correct track. If you have the correct direction you will not face with the problems of managing your money.

It is necessary to look through your credit card payments. Then, you will be able to realize whether you pay more than it is required. If you cannot give the answer to this question that means that you do not know when you waste your cash and whether you waste it wisely or not. So that to be assured in your correct wastes you may use personal finance software with the help of which you will be able to compute all your money and make a decision what opportunity of crisis you have. The best way of controlling your money is planning. As a serious businessman you should have your goals and money plan. You should be ensured in that you are ready and you want to make this or that investment. But your aims should be clear and easy for understanding. If you have many goals you will receive nothing.

You should talk to the members of your family and solve this question together with them. Explain them that leading the successful business is not an easy task; that is why they should wiser think about spending of your cash.

Something interesting to note regarding how scoped assignments behave with multiselect…

On the Adventure Works cube, add the following code to the MDX Script:

CREATE MEMBER CURRENTCUBE.MEASURES.TESTCALC AS 1;
 
SCOPE(MEASURES.TESTCALC, [Date].[Calendar Year].[Calendar Year].MEMBERS);
    THIS = 2;
END SCOPE;
 
SCOPE(MEASURES.TESTCALC, [Date].[Calendar Year].[All Periods]);
    THIS = 3;
END SCOPE;

Then run the following query:

SELECT [Measures].[TESTCALC] ON 0

FROM [Adventure Works]

WHERE([Date].[Calendar Year].[2001])

It returns the value 2 as you would expect. Now run the following query where there is a set in the Where clause, giving a multiselect on 2001 and 2002:

SELECT [Measures].[TESTCALC] ON 0

FROM [Adventure Works]

WHERE({[Date].[Calendar Year].[2001],[Date].[Calendar Year].[2002]})

It returns the value 1 – which, strangely, is the value of the original TESTCALC calculated measure before any of the scoped assignments were applied, even though it would seem that the two scoped assignments between them should cover the cells returned by this query.

Now delete the code you added to the MDX Script and add the following:

CREATE MEMBER CURRENTCUBE.MEASURES.TESTCALC AS 1;

 
SCOPE(MEASURES.TESTCALC, [Date].[Calendar Year].MEMBERS);

    THIS = 4;

END SCOPE;

When you try to run the two queries above you get the value 4 returned in both cases. When I first saw this I thought the results returned by two scenarios were inconsistent and that there was something buggy going on in the first one, but Jeffrey told me there is a specific rule in the engine that dictates this behaviour, so it’s how it’s intended to work – as a result, it’s something that needs to be understood and allowed for in any scoped assignments you write.

<!– Advertisement –>

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/AmoPtdR6T9E/

The majority ofwould love the opportunity to start a work at home business. Convenience, spending more time with family, eluding traffic jams, and economizing money on gas are just a few of the benefits of working at home. Just imagine being able to work in your pajamas and drink coffee while you sit at your computer. You should visit-x affiliate partner as it is a good alternative.

The Internet has created hundreds of opportunities to make easy money online by starting your own work at home business. Each day more and more people are making the decision to control their own destiny by starting an online business at home. The Internet is available 24 hours a day, so you can start your online business full time or part time. Try to visit-x affiliate partner. This is very helpful if you already have a regular day or night job. Once you become successful with your Internet business, you can opt to quit your regular job and work on your home business full time.

When broadly classified, pay-per-lead and pay-per-sale are the two sorts of affiliate business programs. Basically, you establish a relationship with another website. You can then expect web visitors to land up on your site, from the link provided in the other website, and buy your products or services. It is a reciprocal agreement. For help visit-x affiliate partner. If someone were to link to the other website from your website, you end up getting a commission from them. This way it is a win-win situation involved for the websites concerned and one of the best ways of promoting an online business. You can get lots of benefits if you visit-x affiliate partner.

One of the easiest and inexpensive ways to start your Internet business is with affiliate programs. There are many organizaions who sell products or services online and they will let you promote their products or services. You can get all you need if you visit-x affiliate partner. Once you join some of these money making programs, you will be provided with links and banners to place on your website. When someone visits your website and clicks on your links or banners, they will be taken to the company’s website. Start your own affiliate program but first visit-x affiliate partner. When people buy the products or services, you earn a commission. These commissions can be very large and can easily earn you hundreds or thousands of dollars each month.

You should visit-x affiliate partner. Some of these affiliate programs are free to join, or only costs around $20 a month. What other business can you start for such a low fee? Most businesses will cost you thousands of dollars just to get started. You do not need to have employees or keep stock of any products at your home. The organization will ship the products to your customers and take care of all billing transactions. You just focus on promoting your website so you can get more customers and earn more money. It is important for your new affiliate business to visit-x affiliate partner, that you can make your own independent cash flow.

Affiliate programs have become a very popular way to make money online, simply because you can get a money making website setup for you and let the power of the Internet help you make money 7 days a week. All of these reasons make affiliate programs the best work at home business opportunity. This way people can visit-x affiliate partner and get benefits from it.

If you still confused about the best affiliate programs, visit-x affiliate partner!

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 has disappeared from it; however, there is data present in the source database and there are no key errors while processing (see here for a recent example). What’s going on?

In almost all cases the cause is that the Calculate statement at the beginning of the cube’s MDX Script has been deleted or commented out by accident when editing other calculations. To simulate this problem, open up the Adventure Works project and check to see that you can browse the cube and see data in there. Assuming you can, then go to the Calculations tab in the Cube Editor, make sure you’re in Script View and you’ll see something like the following:

The first statement in the MDX Script of every cube should be the Calculate statement, shown above. It’s a bit of a hangover from functionality that I remember from beta versions of SSAS 2005 – you could do some interesting things with a Calculate statement back then but the functionality in question got dropped before RTM. It nonetheless still has to be present though, because when SSAS encounters it when the MDX Script is evaluated it triggers the aggregation of data in all the real measures of the cube up from the very lowest level of detail up to the highest.

If you delete it or comment it out, like so:

…then, when you deploy and browse the cube, no aggregation will take place for the measures in the cube. It will look as if there’s no data in the cube at all but that’s not true: if you browse down to the very lowest level of every dimension in a given measure group, you’ll find that there’s data present. For example in the Adventure Works cube the Exchange Rates measure group is dimensioned by the Date and Destination Currency dimensions and if you browse the cube after commenting out the Calculate statement and look at the Average Rate measure you’ll see no values at first (I’ve got the Show Empty Cells option turned on here):

…but if you make sure you’re looking at data from the Date hierarchy of the Date dimension, and the Destination Currency Code hierarchy of the Destination Currency dimension, the two key attributes of the dimensions, you’ll see values are in fact present:

So the moral of this tale is: be careful not to delete or comment out your Calculate statement! After all there’s a good reason why the following warning is put before it on every new cube:

/*
The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit this command only if you manually specify how the cube is aggregated.
*/

[Incidentally, I would argue that the last line here is dangerous – I’ve never found a good reason to edit or delete the Calculate statement or even put MDX Script statements before it]

<!– Advertisement –>

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/wvSPecTF9NA/

One of the most interesting things I saw last week at the PASS Summit was Data Explorer, the cloud-based data transformation and publishing tool that was demoed in the keynote on day 1. While it was roundly dismissed as ‘yet more Excel’ by the disgruntled DBA faction I thought it showed some potential (you can see a walkthrough of what was shown here) – even if the fact that it was a SQL Azure Labs project suggested it was not destined to be a real product.

Today, however, I came across this post on Tim Mallalieu’s blog with a 10 minute video demo of an Excel addin version of Data Explorer, made earlier this year. Tim notes in his blog that:

We still have both the client and the cloud service but we only showed the cloud bits at PASS last week.

I would urge you to go and watch the video, because what’s shown is a very substantial, capable tool: an Excel addin for doing self-service ETL. Tellingly the name of the tool in the demo is “PowerImport” – and although Tim suggests in his blog that “some names and concepts have evolved quite a bit since March”, the choice of name speaks volumes. It looks like this could be to SSIS what PowerPivot is to SSAS, and a big selling point for Microsoft’s self-service BI story if it does get released.

<!– Advertisement –>

Like this:

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/hGH-1sYcrIY/

The third and final keynote at the PASS Summit, and this morning I’ve been given a space on the official blogger table at the keynote! Actually this just means I’ve got a table to rest my laptop on and access to a power strip, but it’s an honour nonetheless.

There are several things that I saw yesterday that are worth mentioning. Probably the most interesting session was from Cathy Dumas about Tabular: among other things she demoed a DAX Editor plugin for BIDS SQL Server Data Tools that is going to make everyone’s life soooo much easier; it will give us something like an MDX Script editor, intellisense, colour coding and so on. She has blogged about it here and I can’t wait for it to be made available. Also I came across the Data Explorer team site and blog; if you are interested in getting to play with it when it’s ready then you get your email address added to the invite list.

Anyway, back to the keynote and today it’s PASS Summit favourite Dr David DeWitt covering Big Data. It’s not a standard marketing session, more of a lecture, and all the better for it; DeWitt is a very talented speaker and more importantly takes a balanced approach to describing the SQL vs NoSQL debate. Interesting points to note:

• He thinks that the arrival of NoSQL is not a paradigm shift, in the way that the move from hierarchical databases to relational databases was. The assertion that SQL is not dead, not surprisingly, goes down well with this audience.
• Hadoop. I’m not even going to try to summarise this section of the talk but it is an excellent introduction to how it works, and if you’re even vaguely interested in Hadoop (which you should be given Thursday’s announcements) then you need to watch this – I believe will be available to view on demand somewhere (the slide deck is here). It is, honestly, the best explanation of all this I’ve ever seen and there are several thousand people here in this room who agree with me…
• He does a comparison of Hive vs Parallel Data Warehouse v.next on the same queries, same data and same hardware, and shows that PDW can outperform Hive by up to 10x. This demonstrates that a parallel database still has advantages over a NoSQL approach as far as performance goes in many cases, although of course each has its own strengths and weaknesses and performance isn’t the only consideration.

This was not only an enthralling and educational talk, but it was also great marketing from Microsoft’s point of view. You can announce Hadoop for Windows to a room full of SQL Server types and however many whizzy demos you do, and however much woo-hooing goes on, if we don’t really understand the technology we’ll go back to our day jobs and ignore it. On the other hand, teach us what the technology actually does and you’ll get us interested enough to try it out for ourselves and maybe even use it on a project.

Finally, if you’re at the Summit today come and find me at the Birds of a Feather lunch on the SSAS Performance Tuning table, or later on the BI Expert Pod this afternoon.

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/IOLqVHQcdFs/

It’s only day 2 of the PASS Summit and I’m already feeling conferenced-out, although that might have something to do with my alcohol consumption over the last few days, the jetlag, and the early starts. I saw a few good sessions yesterday, although for some reason all the BI talks were allotted ridiculously small rooms so I had to stand or sit on the floor for them. Probably the most impressive from my point of view was a talk I saw yesterday afternoon about Power View (Crescent). Now, I’ve seen a lot of Power View demos over the last year or so but it seems to me that over the last few months since CTP3 the product has turned a corner and gone from being something that was kind-of-good-but-I’ll-wait-for-the-next-release to something that is genuinely worth getting excited about. I can’t really put my finger on what has happened – maybe it’s just reached a critical mass in terms of functionality and it doesn’t seem like a typical Microsoft Version 1.0 any more; certainly it was the first time that I’d seen it and thought that I’d be willing to take the pain of installing Sharepoint to use it.

Anyway, back to the stuff I picked up from the keynote…

• Some nice demos of SSRS, DQS, column store indexes and other non-BI-related stuff, but nothing new and interesting (at least from my point of view)
• Appliances. There’s now a Dell version of PDW, but in general big boxes with flashing lights don’t get me all that excited.
• More on PDW and its roadmap. The next update (pre SQL2012) will get various enhancements including a distributed cost-based query optimiser and limited support for stored procedures. I suspect this time next year I’ll be watching a demo of Tabular in DirectQuery mode working on the next full version of PDW and we’ll have a great story for ad-hoc BI on truly large data volumes.
• Semantic search. Looks very cool; I wonder how this can be integrated into the wider BI stack beyond a few basic SSRS reports? I’ll have to take a closer look at this…
• An announcement !? It seems like BIDS, ie BI Development Studio, is no longer a separate thing but should be thought of as part of SQL Server Data Tools (aka Juneau). Wonder what this means for the BIDS Helper guys? Somehow “BI bits of SQL Server Data Tools Helper” isn’t such a catchy name.
• SQL Azure. The Azure Management Portal is getting a Metro UI; there’ll be a new max size for a SQL Azure DB of 150GB.

So nothing massively exciting here from a BI point of view – clearly all the good stuff was announced yesterday. I’ll be back tomorrow; in the meantime, if you’re at PASS make sure you come to my lightning talk this afternoon because I’m doing some MDX and it would be nice to have some people in the audience who have a clue what I’m talking about!

<!– Advertisement –>

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Cvkme0H2xf0/

So, here we are again in Seattle. I’ve been here for a couple of days already and only just over my jetlag – spending all day inside in the convention centre and meeting rooms is not the best way to adjust to a new time zone. Anyway, there are a lot of cool BI-related announcements coming over the next few days so I thought I’d live blog the keynotes over the next few days; today it’s the turn of Ted Kummert, so let’s see what he’s got to say…

• The official name of Project Crescent is going to be called “PowerView”. I like this name – it has echoes of PowerPivot and (ahem) QlikView.
• Denali will be known as SQL Server 2012 and will release in the first half of next year
• Microsoft will be offering its own Hadoop distribution on Windows; MS have forged a partnership with HortonWorks to do this. I guess this means the end for Dryad/LINQ to HPC as a product, but it’s a good decision – the market doesn’t want another MS me-too product, it wants Hadoop. There will also be an ODBC driver and addin for Excel for Apache Hive, so you will be able to get data from Hadoop directly into PowerPivot and SSAS Tabular without having to stage it in a relational database. It’ll be available as an on-premises solution and also there’ll be a CTP of an Azure-based solution by the end of the year. This is today’s first big announcement, clearly. I have a few customers with the kind of data volumes that mean they’ll be interested in this, especially now it’s coming in a friendly, MS-packaged format. Denny Lee has more details on all this here.
• There’s a new thing coming from SQL Azure Labs called Data Explorer that will be available at the end of this year. This is a web-based data integration tool for working with data from a number of sources: I can see SQL Azure, Excel, Access and the usual sources are supported, and it also generates recommendations of data from the Azure Datamarket that you might be interested in. It allows you to mash up data from various different sources then publish the result as an OData feed – very similar to Yahoo Pipes, as far as I can see, but the cool thing is that there’s only one type of (very PowerPivot friendly) end point. Can’t wait to play with this but, however cool it looks, you have to remember that this is coming from SQL Azure Labs so it’s not going to be a real product any time soon.
• Amir Netz (just promoted to be a Technical Fellow at MS – a very prestigious role, and great for the profile of BI inside the company I think) is now on stage for a Crescent demo. He confirmed that export to PowerPoint will make it into RTM.
• …and now Amir moves onto mobile BI. He shows PowerView on Windows Mobile and… an IPad and an Android phone! Hurray! It seems like, at last, we might have a credible mobile BI strategy from Microsoft. He spends a lot of time demoing on a Windows tablet as well – I wonder why? The audience wants to see the iPad again; maybe the iPad stuff isn’t quite ready yet, but if you remember that PowerView is a Silverlight app then you can imagine that this must have involved quite a lot of hard work to do.

Overall, some very exciting news. The Hadoop and mobile BI announcements fill some glaring gaps in the MS BI story, and I’m certainly a lot happier than I was this time last year..! The DBA crowd here, though, are a bit grumpy because all the announcements have been BI related – my heart bleeds for them, truly.

One last thing: I’ve finally started using Twitter, and if you want more up-to-date news of what’s happening at PASS then I’ll be tweeting throughout the conference. I’m @Technitrain

Like this:

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/2v2K5S-m3qU/

Not much to say, really, apart from what’s in the title and the fact that if you are serious about SSAS you need to read it! You can get it here:
http://sqlcat.com/sqlcat/b/whitepapers/archive/2011/10/10/analysis-services-2008-r2-performance-guide.aspx

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/Nj-SH5xtonk/

Over the last few months I’ve been working on setting up a new business to provide advanced SQL Server training courses in London, similar to what’s available at the SQLBits training day but in a more traditional classroom environment, lasting several days and with practical exercises. I’m not quite ready to launch yet (watch this space – the website will be ready soon) but I do have two courses to promote right now. Both are run by guys from COEO, and both cost £990 plus VAT. Here are the details:

SQL Server Developer Workshop with Gavin Payne
1st – 2nd November 2011
A 2-day interactive workshop that drills down into new features, tools and best practices for developers working with SQL Server 2008 or 2008 R2.
More details and registration here.

SQL Server Internals and Troubleshooting Workshop with Christian Bolton
6th – 7th December 2011
The Advanced Troubleshooting Workshop for SQL Server 2005, 2008 and R2 provides attendees with SQL Server internals knowledge, practical troubleshooting skills and a proven methodical approach to problem solving. The workshop will enable attendees to tackle complex SQL Server problems with confidence.
More details and registration here.

I’ll have some more courses, including runs of my MDX and SSAS cube design courses, to announce soon…

<!– Advertisement –>

Like this:

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/iE1cH9Tvy88/