I don't know if you've noticed it, but I don't blog all that much lately (I know blog, I know - but that doesn't mean I don't love you!). So as you may gather that if I do blog, it must be something that seems important to me.
The SQL Server Team has recently blogged about an initiative they're doing with the Pragmatic Works Foundation. Pragmatic Works Foundation is a non-profit that provides free technical training to veterans, the jobless, and underemployed. In 2012 they're doing a course for returning veterans. The SQL Server team will donate $50 for each story...
The Microsoft BI Conference 2008 has been the source for quite a few announcements. First of all, now that DATAllegro was purchased by Microsoft, the talk is about SQL Server handling bigger amounts of data. There have been posts not just about terabyte projects, but also petabyte projects. The full integration of DATAllegro's technology into SQL Server is planned for the first half of calendar year 2010 and is code named Project Madison. SQL Server 2010 itself is code named Project Kilimanjaro.
The real surprise? Project Gemini which sounds like Microsoft giving QlickView a run for its money... but I'm...
I came across two very interesting web sites lately, both of which are a great source for good webcasts. The first site is Learn Microsoft BI which has all sorts of video on BI projects and how to develop them using SSAS. There has actually just been a first video on PerformancePoint Server as well. The site requires registration, but is well worth it.
The other site is SQL Server Videos which targets more DBAs and developers.
Having done just a few webcasts and knowing how much work goes into it, I am in complete awe of what's given in both...
Webcast: צעדים ראשונים ב Reporting Services 2008
אני חושבת שהבאזז סביב SQL Server 2008 כבר הדליק את כולנו. אני החלטתי להתחיל ולבדוק את מה שקיים כבר במערכת ודבר ראשון, החלטתי להתחיל עם Reporting Services 2008. ב Webcast הזה, אני אראה איך בונים דוח בסיסי עם הממשק החדש.
קובץ ה WMV להורדה
לאתר Reporting Services 2008 כאן
לפורום של MSDN ישראל לשאלות ותשובות בנושא SQL Server כאן
להורדת דוגמאות ל Reporting Services 2008 כאן
להורדת הסקריפט בו אני משתמשת בסרטון כאן
Webcast: First Steps in Reporting Services 2008
I think the buzz around SQL Server 2008 has got us all interested in learning more about the product and what it has to offer. I personnaly, decided to learn first more about Reporting Services 2008. In this webcast, I'll show you how to work with the new interface and build a basic report.
To download the WMV file
The links mentioned in the webcast are:
The Reporting Services 2008 Site here
The MSDN Forum for Q&A on Reporting Services 2008 here
Samples for Reporting Services 2008 here
To download the script I...
SQL Server Data Services - SSDSWell
I guess this means that soon enough we'll all have to know some new initials... Microsoft
has announced in MIX08 about SQL Server Data Services (SSDS). SSDS
is a new, web-based, on-demand data storage and query processing utility
services. SQL Server Data Services is built on SQL Server database and
Windows Server technologies and Microsoft promises scalability and security in
this new service. Just so as to promise
they're keeping up on all ends, SSDS also enables the use of LINQ -
based query language and also full - text search.
SQL Server Data Services also supports
a flexible data model with...
If you were wondering where to turn to check on your latest SQL Server question, then wonder no more! MSDN and TechNet are now linked for all their information regarding SQL Server. I like it best when I don't have to choose ;)
Yes, it's true, it's finally here! The latest version of Microsoft SQL Server 2008 CTP just got released and it includes all sorts of goodies – especially for us developing on SSAS. The general highlights include:
T – SQL intellisense
Analysis Services MDX Query Optimizer - Block Computation
Analysis Services Aggregation Design
Lookup Enhancements for SSIS
Robust Report Server Platform
Microsoft is urging you to download it and send them feedback so as to refine and enhance product features. The CTP will automatically expire after 180 days. The download is available here. The CTP version of SQL Server 2008 Express Edition is...
CU 4 was released yesterday, and as in previous versions, contains the hotfixes that have been developed since the release of SP2. Like with cumulative update 3, this one is also multilanguage and is available through writing a request to Microsoft Online Customer Services at http://go.microsoft.com/?linkid=6294451. To install cumulative update package 4 for SQL Server 2005 Service Pack 2, you need to enable the SMO and the SQL-DMO stored procedures.
The cumulative update is also known as build 3200. For further detail, please see the knowledge base article.
I thought this time around, we'll discuss how solve order can affect your MDX calculations. I found that people tend to ignore this property, as it is not mentioned in the "Form View" of the Calculation Tab of the cube (which is what people usually tend to use when they write MDX for a cube. I hope this will be taken into consideration in SQL Server 2008). Now, this is a shame, as solve order can greatly affect your calculations.
For each calculation you do in MDX, you can specify the optional property of solve_order. If you do not mention...