Post reply

First Impressions: SQL Server 2005

  • August 5, 2004 at 4:27 pm

    #108480

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bk

    Brian Knight
    Free SQL Server Training Webinars

  • August 9, 2004 at 7:37 am

    #518169

    Good intro. article Brian, I look forward to the other 12

    For anyone who's interested, the main page for SQL Server 2005 is at :

    http://www.microsoft.com/sql/

    A download for the MSDE 2000 replacement db engine, which does not require the MS Passport is also available at :

    http://www.microsoft.com/downloads/details.aspx?FamilyId=62B348BB-0458-4203-BB03-8BE49E16E6CD&displaylang=en

     

    Documentation for SQL Server 2005 is at :

    http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en


    Jon

  • August 9, 2004 at 1:06 pm

    #518245

    Nice intro article on 2005. However, Brian, I do advise that before going to a GA version of your article that you have an editor check out your grammar and spelling ... 

  • August 9, 2004 at 1:23 pm

    #518246

    Darn notepad! Yes, you caught me rushing to go to bed after a long day

    Brian Knight
    Free SQL Server Training Webinars

  • August 9, 2004 at 3:08 pm

    #518258

    What a boring article, has no useful content, except to say you successfully installed the beta2.

  • August 9, 2004 at 3:15 pm

    #518260

    Brian,

    I don't really agree with the following comment:

    "Business Intelligence tasks like DTS, Reporting Services and Analysis Services can be managed through the BI Workbench"

    That is at best ambiguous and at worst, wrong (IMHO)!

    DTS/Reporting Services/Analysis Services are managed/controlled/administered/etc... through SQL Server Management Studio (as are SQL Server and SQL Mobile). The BI Workbench (or to give it its proper name Business Intelligence Development Studio) is used to build DTS/Reporting Services/Analysis Services objects and deploy them to the relevant servers.

    Other than these comments, thats a good intro article. This is mere constructive criticism.

     

    Regards

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • August 11, 2004 at 2:30 am

    #518429

    Good introduction for me about SQL Server.  The article gives me a footstep for me to SQL Server 2005.  SHORT and SWEET.

  • August 11, 2004 at 5:44 am

    #518453

    I have also found the speed to be a bit disappointing.  I've not spent any time in the relational side as yet, only the BI tools (AS, DTS, RS and NS).  Have you looked at these yet, and do they run sluggishly for you also?

     

    Steve.

  • August 11, 2004 at 6:02 am

    #518457

    I started to work with those last week in depth and they too seem sluggish on the same server (dual proc). I'm reminded though by MS that most perf fixes are in B3 and they shoot for only functionality in this release.

    What do you think of DTS so far? The learning curve in the new DTS is pretty steep...especially if you're fairly good in SQL Server 2000 DTS.

    Brian Knight
    Free SQL Server Training Webinars

  • August 11, 2004 at 6:11 am

    #518460

    Well, you were there in Feb'03 when they said 'what new?  Its easier to ask whats not new...' 

    I quite like the new DTS, I just want to get to a point where we can test this in our production environment to see if it really does perform better and makes it easier to solve the old dts problems (looping, packages dying with no cause of death, Slowly changing dims).

    I agree that the learning curve will be large, but I am confident that the next BKnight 'Professional 2005 DTS' will set me straight

    Steve.

  • August 11, 2004 at 6:19 am

    #518464

    I agree, it seems that the added DTS functionality far by makes up for the shortcomings in the performance in this early beta. Even though the design environment seems a bit sluggish, the DTS engine itself seems to be flying in data movement and decisioning. Movement of millions of records seems to be only limitted by my network bandwidth but overall is copying several fold faster than the last as I add complex logic in.

    PS: Thanks for the book plug . I'll mail you the check after I finish this.

    Brian Knight
    Free SQL Server Training Webinars

  • August 11, 2004 at 7:01 am

    #518475

    DTS2005 is a huge step in the right direction but its still missing some key functionality, functionality that you will find in products like Informatica.

    e.g.

    Why can't you set breakpoints in a data flow?

    Monitoring package execution (this exists but its not very good).

    Better and more logging (e.g. I want to know how many rows a component outputted - free form text in sysdtslog90.message is not sufficient).

    Why can't I see the query that I am executing against an OLE DB data source?

     

    If they're going after the Informatica's/Ab Initio's of this world then they've still got some improvements to make.

     

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • August 11, 2004 at 2:44 pm

    #518571

    I have used all the tools in SQL server 2005 beta2 and no its not sluggish when you understand the processes that are going on.

    Its about the same speed as Visual Studio 2003.

    You are right, with Microsoft it is in the programmers contracts that secure tested functionality comes first and optimisations 2nd.

  • August 11, 2004 at 3:19 pm

    #518577

    I am just getting a chance to take a look and have to say it is a bit kludgy feeling IMHO. I of course am currently doing a dry run of it without reading any documentation to see how long it takes me to find things. Hope I can easily find things I am looking for but it seems to be think in the seat a bit. Haven't got around myself yet playing with DTS or comparing query performance. So I guess I can say. It's OK.

  • August 12, 2004 at 6:27 am

    #518641

    Nice article! Thanks! I am iching for your next articles, especially on the replication services. Would you mind shed some light early?

    Justin

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply