#SQLFamily – putting a little love in your heart

Thursday, December 15, 2011

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...
no comments

The future of SQL Server: Project Kilimanjaro, Madison and Gemini

Tuesday, October 7, 2008

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...

BI and SQL Server Videos

Monday, September 15, 2008

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

Thursday, May 1, 2008

Webcast: צעדים ראשונים ב Reporting Services 2008 אני חושבת שהבאזז סביב SQL Server 2008 כבר הדליק את כולנו. אני החלטתי להתחיל ולבדוק את מה שקיים כבר במערכת ודבר ראשון, החלטתי להתחיל עם Reporting Services 2008. ב Webcast הזה, אני אראה איך בונים דוח בסיסי עם הממשק החדש. View Video קובץ ה WMV להורדה לינקים מהסרטון: לאתר Reporting Services 2008 כאן לפורום של MSDN ישראל לשאלות ותשובות בנושא SQL Server כאן להורדת דוגמאות ל Reporting Services 2008 כאן להורדת הסקריפט בו אני משתמשת בסרטון כאן

Webcast: First Steps in Reporting Services 2008 [EN]

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. View Video 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 – SSDS

Saturday, March 8, 2008

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...
no comments

Microsoft SQL Server 2008 November CTP

Tuesday, November 20, 2007

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 Geospatial Support 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...
no comments

Cumulative update package 4 for SQL Server 2005 Service Pack 2

Tuesday, October 16, 2007

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.

Solve Order and how it can improve your MDX

Friday, September 14, 2007

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...