Visual Studio 2005 Team Edition for Database Professionals

conexiuni in vs 2008 c# express edition

crestinul — Fri, 11 Apr 2008 08:38:13 GMT

Vreau sa fac un project de test cu linq in vs2008 si pt asta trebuie sa adaug intai conexiune.IN lista de tipuri de conexiuni am numai 3 tipuri acces database sql server compact sql express .Eu am instalat sql 2005 standard si as vrea sa fac o conexiune la aceasta instanta,aveti idee cum as putea face asta cu vs2008 express?

Multumesc

Inregistare timp functie de declansare eveniment.

marian2007 — Fri, 07 Sep 2007 07:24:54 GMT

In cadrul aplicatiei exista tabla "logica" no.1 (tbl_1) in care sunt campurile:

id (int) -keya primara,
code (varchar(10) - identificator unic in cadrul aplicatiei stabilit in prealabil,
name varchar(100) -numele unei componente stabilit in prealabil,
Freq (int) -frecventa (nr. de ore) la care are loc un eveniment stabilit in prealabil,
ET_Ovh (smalldatetime) - camp calculat care exprima timpul estimat pana la producerea evenimentului,
HrsToNextOvh (int) -camp calculat rezultat al diferentei: [Freq]-[RunHrsFromLastOvh]

DateOfLastOvh (smalldatetime) -camp introdus manual
TotalHrsAtLastOvh (int) - camp introdus manual
RunHrsFromLastOvh (int) - camp calculat rezultat al diferentei: [TotalRunHrs]-[TotalHrsAtLastOvh]
TolleranceHrs (int) - camp calculat rezultat al produsului: 0.05*[Freq]
TotalRunHrs (int) - camp introdus manual.

si o alta tabla (tbl_2) "logica" sa o numim Work_Time compusa din:

wo_id (int) - primary key

code (varchar(10) - identificator unic in cadrul aplicatiei stabilit in prealabil

start_time (smalldatetime) - camp introdus manual

stop_time (smalldatetime) -camp introdus manual

wo_interval - camp calculat rezultat al expresiei ((24)*COVERT([real],[wo_stop]-[wo_start],(108)))

Cele doua table au in comun (pt partea de logica a aplicatiei) campul . 
Acestea fiind tabelele logice ale aplicatiei, pentru a rezolva prima tabla a trebuit sa folosesc o tabla primara cu care colectez datele manual si un view ca sa pot acoperi campurile calculate. Aici treaba merge!
Problema mea este insa ca doresc ca la declansarea evenimentului dicatat de campul [HrsToNextOvh], sa intre in operare tabla tbl_2 in care automat sa se transfere -(corespunzator evenimentului), corelat cu actiunea manuala de introducere a datei-timp in campul [start_time].Dupa efectuarea evenimentului se va introduce (manual) data-timp pt campul [stop_date].  Repetare aceluiasi eveniment (dictat evident de valoarile din campurile [Freq] si [TotalRunHrs]) reclama repetarea inregistrari pt tabla tbl_2.Cerinta finala este ca in urma unei interogari (sau alt mecanism) sa se afiseze valorile de tip asociate cu activitatea in timp a evenimentelor (un fel de history).Descrierea problemei este ceva mai ampla (solicita putina rabdare) dar prin ea am incercat sa descriu cat mai bine situatia de "business logic".Multumesc pentru rabdare. P.S. Folosesc MS SQL2k5  (pt a nu exista dubii).

Problema de conversie Excel to MS SQL

marian2007 — Thu, 06 Sep 2007 11:27:10 GMT

In primul rand, fiind prima data cand postez pe acest forum, trebuie sa va spun bine v-am gasit. Sincer am ajuns aici din intamplare(!), in urma cautarilor mele pe forumul MSDN. Stiam ca multi romani sunt parte componeneta in echipa celor de la MICROSOFT dar, cunoscand mentalitatea romaneasca privind lipsa de implicare benevola in orice fel de proiect, nu am realizat ca totusi pot avea loc schimbari in bine si la noi si, astfel, sa poata lua nastere o comunitate de acest gen. Pregatirea mea este intr-un alt domeniu decat cel pentru care exista acest forum, dar dorinta mea de a realiza un proiect de organizare a datelor m-au indrumat ceva timp in urma catre MS SQL. Sunt un incepator dar sper sa reusesc sa-mi insusesc suficiente informatii astfel incat intr-o zi sa pot sa ma indrept cu pretentii catre o certificare Microsoft.

Problema(le) mele sunt date de incercarea mea de a converti un algoritm functional facut de mine in Excel v.11 intr-o solutie Visual Studio.Net (ramura VB) ca interfata cu MS SQL ca baza de date. Solutia mea functionala din Excel acopera ceeea ce se numeste business objects. Dorinta mea este sa pot acoperi toate calculele in MS SQL , ramanad ca VS.NET si CrystalReports sa preia prin "ADO", toate rezultatele cerute de aplicatie prin view-uri proceduri si functii create in partea de DataBase.

Daca se considera ca acest forum ma poate ajuta (inclusiv sectiunea aleasa de mine) va rog sa imi cofirmati pentru a continua postarea problemelor mele.

dal and bll layers

crestinul — Mon, 26 Feb 2007 10:07:22 GMT

Stie cineva vreun tutorial cu exemple de clase dal (data acces layer) si bll (bussines logical layer)?

Multumesc

sqldatasource issue

crestinul — Tue, 13 Feb 2007 11:29:25 GMT

Am tras o sqldatasource pe form si am configurat-o cu wizzardu ei.A generat query-ul asta

SELECT * FROM [Department] WHERE ([DepartmentID] = @DepartmentID)

pentru ca am folosit si parametru.

Problema e ca atunci cand dau test query imi zice ca obiectul Department nu exista .

Department face parte din schema Humanresources am pus si asa :

SELECT * FROM [HumanResources.Department] WHERE ([DepartmentID] = @DepartmentID)

zice la fel.

Nu aveti idee cum pot rezolva?

Multumesc

VS 2005 Team Edition for Database Professionals -Final/Trial

adrian_trif — Mon, 11 Dec 2006 11:57:37 GMT

A aparut VS 2005 Team Edition for Database Professionals - versiunea finala.

Un trial se poate lua de aici: http://www.microsoft.com/downloads/details.aspx?FamilyID=7de00386-893d-4142-a778-992b69d482ad&DisplayLang=en

Pentru instalare trebuie sa aveti deja instalat:

Visual Studio 2005 Team Suite (merge si pe versiunea trial)
o instanta SQL Server 2005 (Developer, Enterprise, Express sau Evaluation)

Visual Studio 2005 Team Edition for Database Professionals CTP 5 Update

xmldeveloper — Sat, 16 Sep 2006 06:56:15 GMT

Visual Studio 2005 Team Edition for Database Professionals CTP 5 Update

ATENTIE ! Cititi instructiunile de instalare !

In plus aruncati o privire si aici CTP5 Refresh Available!

Visual Studio Team System presentations from demos and talks at TechEd 2006 (US)

xmldeveloper — Sat, 16 Sep 2006 07:15:21 GMT

Visual Studio Team System presentations from demos and talks at TechEd 2006 (US)

Daca nu ati fost la TechEd (ca si mine) puteti sa va faceti o idee despre ce s-a intamplat acolo.

DAT312: Managing and Deploying Your SQL Server Schemas with Visual Studio Team
Take a deeper look inside an exciting new addition to Visual Studio Team System.

DAT320: Testing and Refactoring Your Database with Visual Studio Team Edition
Learn how Visual Studio Team Edition for Database Professionals is used to help with Database Unit Testing, Database Rename Refactoring and Database Population. You will learn specifics about how to use this great new product to increase developer productivity and drive software quality for database applications.


DAT433: Under the Hood of Visual Studio Team Edition for Database Professionals
Understand how we enabled source and version control for database schema, and what it means to move to a model where the "One Version of the Truth" for database schema is no longer the production server but the version under source control.


DEV217: Introducing Visual Studio 2005 Team Edition for Database Professionals
Learn about Visual Studio Team Edition for Database Professionals. If you work with databases then you will want to see the new capabilities offered by the latest addition to Visual Studio Team System from Microsoft. In this presentation, learn how this exciting new product will change the way you work with databases forever, by moving the "One Version of the Truth" for database schema from the production server into source control. This presentation focuses on Managing Change to databases through integrated change management, database unit testing and sophisticated comparison tools. We also discuss how day-to-day database tasks can now be integrated into a managed workflow with Team Foundation Server.

DEV233: Visual Studio 2005 Team Foundation Server: Using Metrics to Manage and Troubleshoot Your Projects
Many projects run over time, and unfortunately over budget. This can effect both the quality and performance of your applications, as features are sometimes cut to keep to deadlines. VSTS provides an integrated and seamless mechanism to not only track the quality, performance and reliability of your current development solution - but also, through advanced reporting and analysis, to allow you to manage you projects more effectively with greater insight into potential issues.

DEV237: Visual Studio 2005 Team Foundation Server: Step-by-Step Migration and Adoption Planning
Visual Studio 2005 Team System is a large product that can bring a lot of value to your organization, but it is not without some complexities. If you are struggling to adopt, or still haven't made the commitment, come learn about the steps that can lead to a successful implementation. Learn about different deployment strategies, in addition to strategies for managing users and projects. Learn where the most value is immediately, and what can be integrated into your organization at a later time. Also, discover what resources are available for learning more about the features of Visual Studio 2005 Team System.

DEV304: Delving into Visual Studio 2005 Team Edition for Software Architects
Discover all the creative ways Visual Studio 2005 Team Edition for Software Architects can help you model your application and its deployment. We review the foundation technologies, but then go beyond to discover the hidden capabilities of the Distributed System Designers. Our discussions lead to customization, by using the SDM SDK. We finish by looking to the future and DSL tools.

DEV307: Delving into Visual Studio 2005 Team Edition for Software Developers
Something wicked this way comes and it's your code! Too often code is thrown over the wall to QA in the expectation that they will put the quality into the code. If you're ready to leave the carnival life behind, come to this session where we dive into Visual Studio 2005 Team Edition for Software Developers for both managed developers using Visual C# and Visual Basic and unmanaged developers using Visual C++. We start by using the integrated unit testing and code coverage tools. We then use both static and dynamic code analysis tools to find problems in our code. Finally, we dig into the performance tools and find those areas where time should be spent making your solutions run better.

DEV311: Delving into Visual Studio 2005 Team Edition for Software Testers
Visual Studio 2005 Team Edition for Testers includes powerful load testing tools. Drill into the advanced load testing features to find out how to find performance and stress bugs in your applications before putting them into production. We show you how to take advantage of the advanced extensibility points in Web, unit, and load tests to build effective load tests. Find out how to model different user populations accessing your application through browsers and Web services. Learn how to identify problems using performance counter thresholds SQL profiler integration, and how to share results with your team through rich reports. In addition, we cover how to generate massive loads using Team Test Load Agents.


DEV327: Visual Studio 2005 Team Foundation Server (Part 1): Applying Version Control, Work Item Tracking and Team Build to Your Software Development Project
Visual Studio 2005 Team Foundation Server provides integrated version control, work item tracking, build mechanism and extensive reporting for any size organization. This session overviews the core features and functionality of Team Foundation Server and how, in conjunction with Visual Studio 2005 Team Suite, it can improve your team's collaboration, predictability and productivity.


DEV429: Visual Studio 2005 Team Foundation Server (Part 2): Developing Custom Process Templates, Work Item Types and Policies
One of the most powerful features of Visual Studio 2005 Team Foundation Server is the ability to extend and customize the toolset to meet your development and organizational needs. From simply extending the information you can track within a work item, to fully integrating your current development process, Team Foundation Server can help. This session overviews extending work item tracking, creating new development polices to increase the quality and security of you applications and editing the existing process templates to support your current process.

DEV439: Visual Studio 2005 Team System and Microsoft Solution Framework: Implementing an Agile or CMMI Process
Visual Studio 2005 Team System provides a rich environment and integrated support for software development processes. Team Foundation Server ships with two predefined software development processes, Microsoft Solutions Framework (MSF) for Agile Software Development and MSF for Capability Maturity Model Integration (CMMI) Process Improvement. This session shows you how you can implement these development processes into your environment, as well to incorporating your current software development process into Microsoft Visual Studio Team System.