Troubleshooting with the Microsoft 2008 R2 Tools

Tuesday, November 30, 2010

This is a live post from the session of Guy Glantser at Tech Ed Israel 2010 . Top - Down: Performance Monitor:%Processor Time% Disk TimePage faults \ secBuffer cache hit ratioFull scans \ secSQL complications \ sec Resource Governor:Managing SQL server workload and system resource consumptionIn 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. Dynamic Management Objects:Querying DMVs to check query statistics, usage of buffers, partitions, indexes.All the data we get is from the last time we...

Free SQL Server and BI webinars from PASS

Monday, August 10, 2009

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 information there even if you’re using SQL Server 2005....

Free SSIS SQL Server 2005 Book

Tuesday, January 27, 2009

In celebration of Microsoft Press 25th Anniversary, they are going to offer a monthly free e-book. Till January 28th 2009, they are offering SQL Server 2005 Integration Services Step by Step by Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman for free. Yes, not just a chapter or two, but the entire book! I think you can find the book useful even if you're using SSIS in SQL Server 2008. Though I know they are some changes made to SSIS from SQL Server 2005 to SQL Server 2008, I think that quite a big part of...

SQL Server 2005 SP3

Tuesday, December 16, 2008

Wow, it's here! After the phase of SQL Server 2005 SP3 beta has ended, Microsoft has announced that SQL Server 2005 SP3 is available for download. SQL Server 2005 SP3 includes all cumulative updates up until and including Cumulative Update 9. Though it has just been released, there is already a Knowledge Base article about customizing the TokenAndPermUserStore cache store in SQL Server 2005 SP3 Still, if you have installed SQL Server 2005 Cumulative Update 9 or SQL Server 2005 Cumulative Update 10, then you may have encountered an error message such as "Unexpected Error Occurred" which was already...

SQL Server SP3 Beta and more news

Tuesday, October 28, 2008

Well apparently, you can miss out on a lot of things during a two weeks vacation. Luckily I came back in time to see SP3 Beta for SQL Server 2005 get released! But I'll talk about that in a bit... The announcement of Project Gemini in SQL Server 2010 sparked a very heated debate in the BI Community, over how much it might be abused by users as an alternative to an organized DW \ OLAP solution. The discussion did not go unnoticed by Microsoft. I guess I can only sum up by saying that we'll see what happens in...

Cumulative Update Package 9 for SQL Server 2005 SP2

Tuesday, August 19, 2008

CU9 for SQL Server 2005 Service Pack 2 has just been released, which I should have guessed as the grounds have also been made for Cumulative Update Package 10 as well. It seems that you may need CU9 to correct a bug caused from installing Cumulative Update Package 7. What's the problem? Apparently you may get an error message after installing CU7, when you explicitly define a slice at a partition and then process the partition by using a query that returns no records. To read more about the problem that may arise from CU7, that was fixed in...

BIDS Helper for SQL Server 2008

Sunday, August 17, 2008

I know I had recommended the BIDS Helper for you before, but as a new version of this Visual Studio add – in just got out this Saturday with support for SQL Server 2008, I thought it's a great time to remind everybody they should check it out. Most of the features in this release are available only through their source code, which is there for you to compile and deploy yourself. My personal favorite feature would be the Non-Default Properties Report, which helps you track the settings in your SSIS Package or your SSAS cube and...

Cumulative Update Package 8 for SQL Server 2005 Service Pack 2

Wednesday, June 18, 2008

CU8 for SQL Server 2005 Service Pack 2 has just been released, which also means that the grounds have also been made for Cumulative Update Package 9 as well. Microsoft recommends that in general, you only install Cumulative Updates to correct problems described in the knowledge base articles relevant to that CU. That said, Cumulative Update Package 8 can, amongst other things, correct something related to Cumulative Update Package 6. It seems that queries that use a cursor run faster on previous builds than they do on CU6. This problem was fixed in CU8, and so if you...

Cumulative Update Package 7 for SQL Server 2005 Service Pack 2

Thursday, April 17, 2008

Microsoft has recently announced the release of Cumulative Update Package 7 for SQL Server 2005 Service Pack 2. CU 7 comes 2 months after its predecessor (just like they promised) and yet again, the groundwork is already built for Cumulative Update Package 8. You can read more about Cumulative Update Package 7 and also download CU 7 upon request from Microsoft Support. You should be aware though, that the Microsoft PSS SQL Support team has announced that installing Cumulative Update Package 7 can impact your SSAS backup and sync operations....

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