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

The Select Statement and the Reverse Function in SQL

Friday, March 14, 2008

I found out today something quite peculiar, which I didn't know up till now. I have a table which has codes and names in it. The names are in Hebrew and need to be reversed. The table should have rows in it only if there exists a description for the code. It shouldn't have codes in it that don't have a description. This is my select statement and its result:   Which was weird, because why would I have a blank line for a code? I shouldn't have a line for it at all in that case. Still, I needed to reverse...
one comment

Browsing a Cube and Influencing Aggregations

Thursday, September 27, 2007

You can browse a cube through the cube browser in Analysis Services or through the one in the Management Studio. I usually use the one in the Management Studio, as it gives your more space to look. In the cube I created in Analysis Services, I added a Budget hierarchy in my Budget dimension. I decided to check the data for the new hierarchy in comparison to the money that was assigned to it in the Budget fact table. And it was problematic…I was opening the Budget hierarchy and in the first 3 levels it reacted pretty quickly, but...

SQL 2008 July CTP!

Thursday, August 2, 2007

SQL 2008 July CTP is out! I started to get suspicious when my brother ( adlai ) called me and asked me "did you downloaded the SQL2008, because I can't download it now ! the link in MSDN doesn't function".With SQL Server 2008 July CTP release, customers can understand and get hands-on experience with the new capabilities that, with the release of SQL Server 2008, will help them support their mission-critical platform and enable pervasive insight across the enterprise. SQL Server 2008 lays the groundwork for innovative policy-based management that enables administrators to reduce their time spent on maintenance tasks. SQL Server 2008 provides enhancements in the...
no comments

Data Dude Service Release 1

Wednesday, August 1, 2007

I'll start by describing Data Dude (or DB Dude) first to all of us who don't use it, now shall I?   It's a tool for the management of databases, enabling you to keep track of version history of a database with a source control on the scripts that build the database. The tool was first introduced to the very talented DBA in my department – Boris Kogan – by Maor David from SRL. Boris was obviously very pleased to have a bit of work and headache saved with this new tool. Just a week ago, Microsoft released the SR1...

SSAS Back Engine and Named Queries in the DSV

Thursday, July 19, 2007

Hi everybody,   What’s up? Thought I’d share with you something strange I found while using named queries in the DSV layer in SQL Server Analysis Services. I have developed quite a complex layer of connected tables in my DSV. As development had evolved (with the customers demand) I found myself turning 3 of my regular tables into named queries. The named queries were basically using the same table twice in an inner join to compare the state of the entity in two different times in the table. After this change, my process time for the cube and the dimensions grew from about...

SQL Server 2005 Best Practices Analyzer

Sunday, July 15, 2007

About a week a go (I admit I'm only catching up to it now…) Microsoft released the SQL Server 2005 Best Practices Analyzer. The tool analyzes and monitors the SQL Server Profiler files. It uses a predefined list of recommendations to determine if there are potential issues in the database environment. Now if you're like me, then after downloading and installing the tool, you can't help but think to yourself "yeah great, but how do I use it?..." Well all you need to do after that is run the SQL Server Profiler and run the program on the trace...

Cumulative update package 2 for SQL Server 2005

Friday, June 22, 2007

Fresh! Straight from the oven! Microsoft has just released the second cumulative update package for SQL server 2005 SP2. The basics? You must apply a SQL Server 2005 Service Pack 2 (SP2) hotfix to an installation of SQL Server 2005 SP2. It includes the SQL Server 2005 hotfixes that have been released since the release of SQL Server 2005 SP2 occurred. At the end of the installation, the SQL Server service will have to be restarted (though the set up program does that for you). Enjoy!

Friendly Names and Translations

Monday, June 18, 2007

We define names for our tables and columns following the guidelines defined in our company. we might even adhere to international naming conventions. Still, nothing promises us the names we give our DB objects will be comprehensible to our customers. And this is where SSAS steps in - Analysis Services enables you to give alternative names to your dimension attributes in the following two ways: Translations may be given to: dimensions, dimension attributes, user hierarchies, measures, measure groups and to many other objects. The translation usually appears in a separate tab called (surprise) "Translations". This tab enables us to...