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