Browse by Tags
All Tags »
SQL Server 2005 (
RSS)
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...
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...
In celebration of Microsoft Press 25th Anniversary, they are going to offer a monthly free e-book. Till January 28 th 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...
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...
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...
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...
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...
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...
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...
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...
CU6 for SQL Server 2005 Service Pack 2 was released last week. The knowledgebase article detailing what's inside is available here and the download itself is available only after requesting CU6 from Microsoft here . Chris Webb had just written in his blog , that apparently this still does not necessarily lead to a SP3 for SQL Server 2005.
Cumulative update 5 was released last week (18 th of December 2007). Cumulative update 5 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2. For more details please read the knowledgebase article . More importantly, to download it, please submit a request to Microsoft . As always, the release of one cumulative package, also means another one is in the works. And this time is no exception …
I know this means I'm quite late writing about it, but I only came about to learn about this Visual Studio.Net add-in quite recently and I wanted to study it for a bit before writing about it. The BIDS Helper is an excellent extension to the BI Development Studio which comes with SQL Server 2005. Though my main uses for it are for the SSAS part of my BI project, the newly released version also has features for SSIS. Among other features for SSAS, the BIDS Helper enables you to: Validate aggregations...
Well I guess this Microsoft's way of telling you that you should install already the SQL Server 2005 Service Pack 2 , as the Lifecycle Supported Service Packs has announced that the support for SQL Server 2005 Service Pack 1 will end on the 8th of April 2008.
Just in case you were also looking for the SQL Server 2005 Sample Database , then you should know Microsoft has chosen to move it to the CodePlex site. SQL Server 2008 July 2007 CTP Samples are also available on the same site. I recommend downloading the versions which are marked in the end with CI as they enable a Case Insensitive search within them. The LT version is also CI. I really love the way Adventure Works gives you an entire look on the abilities of SQL Server.
More Posts
Next page »