Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Journey to Katmai


The Journey to Katmai

Author
Message
Steve Jones
Steve Jones
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: Administrators
Points: 41604 Visits: 18876
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sjones/3044.asp

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
michaela
michaela
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1427 Visits: 440

I would like to install the 2k8 ctp on a vista machine; I have already a 2k5 developer (named) instance installed. I've read that the 2k8 ctp does not work yet with many instances; can I install it as a 2nd instance on this machine? I would not want to break the sql 2k5 installation. Thank you in advance.





Sugesh Kumar
Sugesh Kumar
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3665 Visits: 358

The following side-by-side conditions are not supported in this release:

  • Side-by-side Tools - Presence of SQL Server 2005 Management Tools or BI Development Studio will block installation of SQL Server "Katmai" Management Tools and BI Development Studio.

  • Side-by-side with SQL Server 2000 - An instance of SQL Server 2000, including MSDE, will block installation of this release of SQL Server "Katmai".

  • Side-by-side with SQL Server "Katmai" CTP1 - An instance of SQL Server "Katmai" CTP1 will block installation of this release of SQL Server "Katmai".

  • Side-by-side instances of SQL Server "Katmai" CTP3 - Multiple instances of this release of SQL Server "Katmai" are not supported on a single computer.

This is from BOL of SQL 2008.



Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
michaela
michaela
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1427 Visits: 440
Thank you. It's great to know.



James T Bond
James T Bond
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 32
I'm actually pretty excited about the baked in spatial support in Katmai.

http://www.directionsmag.com/article.php?article_id=2477&trv=1
Regan Galbraith
Regan Galbraith
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 265

Consider using virtual server's - install a virtual server, andd then on the cirtual server you *should* be able to install Katmai

anyone doing this yet? I'm waiting to get virtual server on a machine that can handle it...


WILLIAM MITCHELL
WILLIAM MITCHELL
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1754 Visits: 3041
Here's a bit of trivia - Katmai was Intel's code name for the original Pentium III processor. You'd think that somebody at MS would have known that
mngong
mngong
Mr or Mrs. 500
Mr or Mrs. 500 (581 reputation)Mr or Mrs. 500 (581 reputation)Mr or Mrs. 500 (581 reputation)Mr or Mrs. 500 (581 reputation)Mr or Mrs. 500 (581 reputation)Mr or Mrs. 500 (581 reputation)Mr or Mrs. 500 (581 reputation)Mr or Mrs. 500 (581 reputation)

Group: General Forum Members
Points: 581 Visits: 1
I have always wanted Microsoft to incorporate an ability to see who are the active users and the complete sql they are running as Oracle enterprise manager lets you do(more information than sp_who2 provides)

Mike



Regan Galbraith
Regan Galbraith
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 265

In SQL 2000, use the function ::fn_get_sql (X'sqh handle') where SQL_handle is the sql_handle column from sysprocesses.

In SQL 2005, have a look at sys.dm_exec_sql_text(sql_handle), getting sql_handle from sys.sysprocesses

HTH


Donald Desnoyer
Donald Desnoyer
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 34
Intellisense would be nice, but only if they incorporate it into Visual Studio too. I have to believe the majority of SQL developers use VS and not EM/SSMS.

I also think Red-Gate has missed a golden opportunity by having SQL Prompt only hocked into SSMS. From what I've read, it was a challenge for them, since SSMS doesn't expose a plug-in architecture. VS already exposes this architecture, so you would think it would be fairly easy for them to adapt their existing SQL Prompt code over to VS.

I could be wrong and perhaps that's one of the reasons Red-Gate is publishing this software and I'm not.

Thoughts ?

Thanks,
Don
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search