Drill down slow: yukon

Showing posts with label yukon. Show all posts

Thursday, March 22, 2012

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyID=62b348bb-0458-4203-bb03-8be49e16e6cd&displaylang=en.
Developer edition is available for MSDN subscribers.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARR
Express edition can be downloaded from
http://www.microsoft.com/downloads/d...isplaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

download link of Yukon

Hi ,
need a download link of latest build of YUKON
Thanks
ARRExpress edition can be downloaded from
http://www.microsoft.com/downloads/...displaylang=en.
Developer edition is available for MSDN subscribers.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Aju" <ajuonline@.yahoo.com> wrote in message
news:%23KkDrzPBFHA.2640@.TK2MSFTNGP14.phx.gbl...
> Hi ,
> need a download link of latest build of YUKON
> Thanks
> ARR
>

Download DB AdventureWorksDW

Hi Gurus ... I will thank you to indicate me ... where i can download
the Yukon DB "AdventureWorksDW".
Thanks in Advance
VictorHi Victor,
As far as I know, it's only available through the beta of Yukon.
Unfortunately the beta is not a public one and therefore not available
through a download.
Karl Gram, BSc, MBA
http://www.gramonline.com
"Victor Chambi" <vchambi@.hotmail.com> wrote in message
news:1ec9e625.0403261126.2d30ea4f@.posting.google.com...
> Hi Gurus ... I will thank you to indicate me ... where i can download
> the Yukon DB "AdventureWorksDW".
> Thanks in Advance
> Victor|||That is correct.
MS has said they plan to do a public beta the first 1/2 of this year.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Karl Gram" <NOSPAMkarl@.gramonline.nl> wrote in message
news:OB2qVo3EEHA.3804@.TK2MSFTNGP09.phx.gbl...
> Hi Victor,
> As far as I know, it's only available through the beta of Yukon.
> Unfortunately the beta is not a public one and therefore not available
> through a download.
> --
> Karl Gram, BSc, MBA
> http://www.gramonline.com
>
> "Victor Chambi" <vchambi@.hotmail.com> wrote in message
> news:1ec9e625.0403261126.2d30ea4f@.posting.google.com...
>|||And the beta might include two AW DBs by default, one for OLTP and one for
DW.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:e3MDA13EEHA.3748@.TK2MSFTNGP11.phx.gbl...
> That is correct.
> MS has said they plan to do a public beta the first 1/2 of this year.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Karl Gram" <NOSPAMkarl@.gramonline.nl> wrote in message
> news:OB2qVo3EEHA.3804@.TK2MSFTNGP09.phx.gbl...
>sql

Friday, March 9, 2012

Dotnet Code can be run in SQLServer in 2005-WHY?

I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me i
n
this regard,it would bemuch appreciated. Thanks in advance.Let me know if an
y
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:

> See if this helps:
> http://msdn.microsoft.com/library/d...clrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Dotnet Code can be run in SQLServer in 2005-WHY?

I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me in
this regard,it would bemuch appreciated. Thanks in advance.Let me know if any
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:

> See if this helps:
> http://msdn.microsoft.com/library/de...lrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
ShyamSee if this helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>|||I´ll keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
>> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
>> Hi,
>> I had recently undergone training in YUKON.As the first class begun,i
>> came
>> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
>> Server.I was surprised by this. My trainer answered that,it was due to
>> performance,scalability and many other "ABILITY" terms...
>> Could someone please give me better answers on this as to why there is a
>> necesary to run dotnet code inside SQL Server? Any article/URL would be
>> appreciated greatly.
>> Thanks,
>> Shyam
>>
>|||Hi Vyas,
Thanks for the Link.But,it gives a better picture :)
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me in
this regard,it would bemuch appreciated. Thanks in advance.Let me know if any
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:
> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Friday, February 17, 2012

Doing a join between XML data typed field and a relational table in Yukon (SQL 2005)

Hello,
I have a Yukon XML question and would be very happy if someone can
assist:
Let's assume I have 2 tables:
One will be product table Regular relational table with Product ID
as a primary key and some descriptive fields.
Second is an Order table it has Order ID as a PK and Order details
which is a field of XML data type and holds all lines in the order
including quantity, product id, prices, etc.
I want to make a join that will present the orders with all product
details for each order line.
Do you know how can I do a Join between XML field and relational
table?
Thanks,
Nitsan
"Nitsan" <nitsan.shaked@.intel.com> wrote in message
news:31b6c8ae.0407120300.6902d2e1@.posting.google.c om...
[snip]
> Do you know how can I do a Join between XML field and relational
> table?
You should be able to do this with the new nesting of FOR XML statements in
Yukon. See:
http://sqljunkies.com/WebLog/mrys/ar...2/19/1208.aspx
Bryant
|||Thanks for your answer,
I looked into it and it looks like it was doing select on relational tables
and just created XML as an answer.
I am looking for the opposite - Query in XML content join relational table
to get data (even not necessarily in XML format).
Thanks,
Nitsan
"Bryant Likes" <bryant@.suespammers.org> wrote in message
news:OeRsQuBaEHA.524@.TK2MSFTNGP09.phx.gbl...
> "Nitsan" <nitsan.shaked@.intel.com> wrote in message
> news:31b6c8ae.0407120300.6902d2e1@.posting.google.c om...
> [snip]
> You should be able to do this with the new nesting of FOR XML statements
in
> Yukon. See:
> http://sqljunkies.com/WebLog/mrys/ar...2/19/1208.aspx
> --
> Bryant
>
|||Even outside of the capabilties of FOR XML, you can do what you want.
You can use a value from the XML data type using the method xmltype.value()
in a SQL predicate. Or you can use the value of a sql:variable or sql:column
to do the join inside an XQuery.
Bob Beauchemin
http://staff.develop.com/bobb
"Nitsan Shaked" <nitsan.shaked@.intel.com> wrote in message
news:ccuhjj$kr2$1@.news01.intel.com...
> Thanks for your answer,
> I looked into it and it looks like it was doing select on relational
tables
> and just created XML as an answer.
> I am looking for the opposite - Query in XML content join relational table
> to get data (even not necessarily in XML format).
> Thanks,
> Nitsan
> "Bryant Likes" <bryant@.suespammers.org> wrote in message
> news:OeRsQuBaEHA.524@.TK2MSFTNGP09.phx.gbl...
> in
>
|||Nitsan,
in SQL Server 2005 Beta 2 or SQL Server 2005 Express Edition Technical
Preview you can use nodes() method on XML type to get a row set out of an
XML instance and then do the join in T-SQL space:
create table products(ProdID int primary key, ProdDesc nvarchar(max))
go
create table orders(OrderID int primary key, OrdDetails xml)
go
insert products values(1, 'Prod1')
insert products values(2, 'Prod2')
go
insert orders values(1,
'<prod id="1">
<quantity>2</quantity>
<price>12345.67</price>
</prod>
<prod id="2">
<quantity>3</quantity>
<price>9876.54</price>
</prod>')
go
select OrderID, quantity, price, ProdDesc
from
(
select
OrderID,
prod.value('./@.id', 'int') as id,
prod.value('(./quantity)[1]', 'int') as quantity,
prod.value('(./price)[1]', 'money') as price
from orders cross apply orders.OrdDetails.nodes('/prod') as prods(prod)
) as OrdLine
join products on OrdLine.id=products.ProdID
go
You can then apply FOR XML to results if you need results as XML.
Regards,
Eugene Kogan,
Technical Lead,
SQL Server Engine
Microsoft Corp
[This posting is provided "AS IS" with no warranties, and confers no
rights.]
"Nitsan" <nitsan.shaked@.intel.com> wrote in message
news:31b6c8ae.0407120300.6902d2e1@.posting.google.c om...
> Hello,
> I have a Yukon XML question and would be very happy if someone can
> assist:
> Let's assume I have 2 tables:
> One will be product table - Regular relational table with Product ID
> as a primary key and some descriptive fields.
> Second is an Order table - it has Order ID as a PK and Order details
> which is a field of XML data type and holds all lines in the order
> including quantity, product id, prices, etc.
> I want to make a join that will present the orders with all product
> details for each order line.
> Do you know how can I do a Join between XML field and relational
> table?
> Thanks,
> Nitsan
|||Thanks,
Do you have a short example if usin git for this purpose?
"Bob Beauchemin" <no_bobb_spam@.develop.com> wrote in message
news:O9D73DEaEHA.3508@.TK2MSFTNGP09.phx.gbl...
> Even outside of the capabilties of FOR XML, you can do what you want.
> You can use a value from the XML data type using the method
xmltype.value()
> in a SQL predicate. Or you can use the value of a sql:variable or
sql:column[vbcol=seagreen]
> to do the join inside an XQuery.
> Bob Beauchemin
> http://staff.develop.com/bobb
>
> "Nitsan Shaked" <nitsan.shaked@.intel.com> wrote in message
> news:ccuhjj$kr2$1@.news01.intel.com...
> tables
table[vbcol=seagreen]
statements
>
|||Thank you very much !!!
"Eugene Kogan" <eugene_kogan@.hotmail.com> wrote in message
news:uUd0kAJaEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Nitsan,
> in SQL Server 2005 Beta 2 or SQL Server 2005 Express Edition Technical
> Preview you can use nodes() method on XML type to get a row set out of an
> XML instance and then do the join in T-SQL space:
> create table products(ProdID int primary key, ProdDesc nvarchar(max))
> go
> create table orders(OrderID int primary key, OrdDetails xml)
> go
> insert products values(1, 'Prod1')
> insert products values(2, 'Prod2')
> go
> insert orders values(1,
> '<prod id="1">
> <quantity>2</quantity>
> <price>12345.67</price>
> </prod>
> <prod id="2">
> <quantity>3</quantity>
> <price>9876.54</price>
> </prod>')
> go
> select OrderID, quantity, price, ProdDesc
> from
> (
> select
> OrderID,
> prod.value('./@.id', 'int') as id,
> prod.value('(./quantity)[1]', 'int') as quantity,
> prod.value('(./price)[1]', 'money') as price
> from orders cross apply orders.OrdDetails.nodes('/prod') as prods(prod)
> ) as OrdLine
> join products on OrdLine.id=products.ProdID
> go
> You can then apply FOR XML to results if you need results as XML.
>
> Regards,
> Eugene Kogan,
> Technical Lead,
> SQL Server Engine
> Microsoft Corp
> [This posting is provided "AS IS" with no warranties, and confers no
> rights.]
> "Nitsan" <nitsan.shaked@.intel.com> wrote in message
> news:31b6c8ae.0407120300.6902d2e1@.posting.google.c om...
>
|||Hi Nitsan,
Here's a really short example, starting with the authors table in the pubs
database:
create table xmlauth (
authbio xml)
go
insert xmlauth values('<author id="172-32-1176"><hobbies><golf score="78"
/><tennis/></hobbies></author>')
insert xmlauth values('<author id="213-46-8915"><hobbies><golf score="82"
/><bowling/></hobbies></author>')
If you know each document contains one author, you can use xml.value:
select authbio.query('/author/hobbies/*') as hobbies, au_lname
from authors, xmlauth
where authors.au_id =
xmlauth.authbio.value('author[1]/@.id', 'varchar(11)')
(if you have a schema collection which specifies a single author occurance,
you can leave out the subscript [1] in the value subquery)
If documents may contain more than one author, (e.g)
insert xmlauth values('
<authors>
<author id="274-80-9391"><hobbies><swimming
/><bowling/></hobbies></author>
<author id="274-80-9391"><hobbies><baseball
/><bowling/></hobbies></author>
</authors>')
you would need xml.nodes. Eugene's excellent example illustrates that.
You can even do this (caution: NOT recommended, cartesian product) using the
SQL value in the XQuery:
select * from
(
select authbio.query('
for $a in /author
where $a/@.id = sql:column("authors.au_id")
return $a/hobbies/*') as hobbies, au_lname
from xmlauth, authors
) as a
where hobbies.exist('/*')=1
or
select * from
(
select authbio.query('
for $a in /author
where $a/@.id = sql:column("authors.au_id")
return $a/hobbies/*') as hobbies, au_lname
from xmlauth, authors
) as a
where convert(nvarchar(100), hobbies) <> ''
Hope this helps,
Bob Beauchemin
http://staff.develop.com/bobb
"Nitsan Shaked" <nitsan.shaked@.intel.com> wrote in message
news:cd034u$fo8$1@.news01.intel.com...
> Thanks,
> Do you have a short example if usin git for this purpose?
> "Bob Beauchemin" <no_bobb_spam@.develop.com> wrote in message
> news:O9D73DEaEHA.3508@.TK2MSFTNGP09.phx.gbl...
> xmltype.value()
> sql:column
> table
> statements
>

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed Visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in Visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?
Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?
|||I've installed Visio for VS2005 Beta? but I can't found where is that command
to do it
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>
|||I mean not to create new diagram but contigious development of a database
(two way connection with a database)
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>
|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed Visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?
|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in Visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.
|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?|||I've installed visio for VS2005 Beta? but I can't found where is that comman
d
to do it
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>|||I mean not to create new diagram but contigious development of a database
(two way connection with a database)
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Thursday, March 22, 2012

download link of Yukon

download link of Yukon

download link of Yukon

Download DB AdventureWorksDW

Friday, March 9, 2012

Dotnet Code can be run in SQLServer in 2005-WHY?

Dotnet Code can be run in SQLServer in 2005-WHY?

Dotnet Code can be run in SQLServer in 2005-WHY?

Friday, February 17, 2012

Doing a join between XML data typed field and a relational table in Yukon (SQL 2005)

Does Yukon have diagramm designer?

Does Yukon have diagramm designer?

Does Yukon have diagramm designer?

Drill down slow

Blog Archive

About Me