Browse by Tags
All Tags »
SQL Server 2008 (
RSS)
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...
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...
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...
Microsoft continues in helping you learn SQL Server 2008 , this time in collaboration with AppDev . You can download up to three hours of training. If you haven't used AppDev courses till now then you should know that they really walk you through the subject they're covering, also giving you an exam at the end of each part. It really makes for a great way to learn on whatever it is you're interested in. The courses offered are: SQL Server 2008 for Developers, SQL Server 2008: Installing...
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...
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...
Do you want to influence how SQL Server 2010 Kilimanjaro will look like? Do you submit issues to Microsoft Connect? Well this is the post for you... When I first saw Anthony Carrabino 's post about a free hosted SQL Server 2008 offer I thought to myself that maybe I shouldn't have bothered putting up a virtual machine with SQL Server 2008 on it, when Microsoft is already offering me one all ready and for free... but that's not the exact case. Reading the page for the free SQL Server 2008...
Did you ever have a problem where you went to a course, studied something, but then didn't use it, so you ended up forgetting what you've learned?... Well Microsoft is going to see to it that it won't happen when you study SQL Server 2008 . So, if you're interested in taking a course about the different parts of SQL Server 2008 (be it maintaining a DB, SSAS 2008, SSRS 2008 etc.), then you'll also get a fully licensed copy of SQL Server 2008 Standard Edition with one client access...
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...
My favorite "toy" in SQL Server 2008 just got a brand new spanking release! Report Builder 2.0 just went RC1 after it didn't appear in the feature pack of SQL Server 2008 RTM . When I tried it out first, as a Report Designer Preview in CTP6, I loved it so much that I even decided to make a webcast out of it (both in Hebrew and in English ). Later, I found out this would become the "next generation" of Report Builder. When I downloaded the feature pack that came with SQL Server...
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...
Till now Microsoft enabled you to download SQL Server 2008 for a trial version of 180 days. You could get it from MSDN for the Developers and Architects of you and from TechNet for IT Professionals and IT Managers (you get the same download on both sites, only with differently focused follow – up emails, according to your role). Yesterday however, Microsoft also released SQL Server 2008 Express . Yes, I grant you, it does not have full functionality in it like SQL Server 2008, but I personally would...
Yes, it’s finally out – THE NEW VERSION of SqlServer , 2008 ;)
Microsoft is giving you the chance to learn more about SQL Server 2008 with free chapters from Peter DeBetta upcoming book - “ Introducing SQL Server 2008 ”. Chapter 1 details Policy-based Management and you can view it online. If you'll sign up, then you'll be able to read also about Transact-SQL Enhancement in SQL Server 2008 (which are detailed in the 11th chapter of the book).
More Posts
Next page »