We installed SQL Server 2008 R2 about 2 months ago, and I recently tried to use a new feature in Reporting Services 2008 R2 . I used the Business Intelligence Development Studio (BIDS) to open a new Report Server Project. After creating a data source I also defined a shared dataset (a new feature to SSRS 2008 R2). I put some of the fields into a table and tried to run the report (still inside the BIDS). But I failed with an error: The report preview failed because the report could not be built. Read...

This is a live post from the session of Guy Glantser at Tech Ed Israel 2010 . Top - Down: Performance Monitor : %Processor Time % Disk Time Page faults \ sec Buffer cache hit ratio Full scans \ sec SQL complications \ sec Resource Governor : Managing SQL server workload and system resource consumption In essence, we check how much each query, application etc. require from our different resources. We can check by groups, resources and so on. We can then decide how to limit the use of the resource...

I had to configure a data file in a very large database this one time and I used Management Studio for that. The file size I was aiming at was 3TB (a very large database indeed). I was quite surprised to see that SSMS has a limit to the size you can configure, which was 2,097,152 MB (i.e. roughly 2TB). I thought I was missing something here and quickly turned to SQL Server Maximum Capacity Specifications to see how big a data file can get, and to found out it is 16TB, not 2TB (the transaction log...

When you work with large tables in SQL Server 2005 and 2008, you will inevitably start using partitioned tables in order to ease the maintenance of these tables, and improve query performance. I recently wanted to merge several partitions at the tail of an existing partition function, and I wanted to understand whether I need to merge the partitions in a sequential order from the last partition and work my way up the chain of partitions, or would it be better to start from the newest partition (that...

Via Dan English ’s blog, I’ve learned that Pass is offering a day of BI webinars for free ! The Pass Convention itself is scheduled for November in Seattle. As this year there will no dedicated BI conference from Microsoft , Pass is the conference for you to get updated on all your BI needs. This is also why I was very happy to hear they’re also offering a day of free sessions with very well known speakers. The sessions are mostly SQL Server 2008 oriented, but I believe you’ll find more than enough...

הנכם מוזמנים למפגש קהילת נס ציונה - מפגש אוגוסט 2009 ,המפגש יתקיים ב 12/08 בשעה 17:00 בחברת HP Indigo , אינשטיין 20 , אודיטוריום בניין 20, פארק המדע, נס ציונה ישראל ( שמירה ב- outlook ). מבט כולל על אירוע this session is especially for you. We're going to discuss and demonstrate the new programmability features in SQL Server 2008: T-SQL enhancements (MERGE statement, row constructors, grouping , sets, compound assignment ) New data types (new temporal, spatial and hierarchical data types). Management...

You know how they say “time just flies by you”? I think the year 2010 is coming quicker than I thought, and with it the new SQL Server 2010 , code named Madison. Microsoft has announced that it is planning a Technology Preview for Madison in early July, so if you have a petabyte size DW then you might be one of the lucky customers invited to take project Madison for a test drive. Other announcements (coinciding with TechEd 2009), are of new features available in SQL Server 2008 R2 such as Master...

Site stats have shown me that you like free e-books , which is fine - because I like them too! :)... So following their free SSIS 2005 book, Microsoft is offering a few more books for free. First and foremost is Introducing Microsoft SQL Server 2008 . Yes, they have offered the book before, but only a few chapters out of it. This time, we're talking about the whole book! Most of the book handles what's new with the product in general like Performance and Programmability, but chapter 7 is...

הנכם מוזמנים למפגש קהילת Business Intelligence פברואר 2009. המפגש יתקיים ביום רביעי ה-25/02 בשעה 17:30 בבית מיקרוסופט, רח' הפנינה 2 רעננה. ( שמירה ב- outlook ). Analysis Services Performance Tuning and Optimization Technology : Analysis Services 2005 / 2008 , Level : 300 Description: Improving the performances of the Analysis Services is one of the main tasks of the DBA. In this session I will discuss the methodology for monitoring the Analysis Services server performances and how to analyze...

Cumulative Update 3 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008. http://support.microsoft.com/kb/960484