SQL Server 2008

Synonym pe un tabel remote avand o coloana de tip XML

mitza — Tue, 24 Sep 2013 04:05:48 GMT

Hello world.
Am urmatoarea problema.
Avand 2 servere(Server 1 si Server 2). Pe Server 1 creez un synonym al unui tabel care se afla pe Server 2 si care
contine o coloana de tip XML. Synonym-ul se creaza, dar nu poate fi accesat, generand urmatoarea eroare (select * from Synonym_name / select convert(nvarchar(max), XML_column) from Synonym_name):
"Msg 9514, Level 16, State 1, Line 1
Xml data type is not supported in distributed queries. Remote object 'Synonym_name' has xml column(s).".
Va multumesc.

Accesare linked server folosind openquery

mitza — Sat, 17 Aug 2013 12:59:20 GMT

Hello World!

Am urmatoarea problema..Am 2 servere SQL: "Server_1" si "Server_2".
Pe "Server_2" am configurat un linked server catre "Server_1", numit "Link_1". Am creat o procedura de test, care foloseste legatura "Link_1";

if(OBJECT_ID('ProcTest_1') is not null)
drop proc ProcTest_1
go

create proc ProcTest_1
as
begin
select * from openquery(Link_1, 'select top 10 * from TableTest')
end
go

Daca o execut din SSMS, nu returneaza nici o eroare, in consecinta returneaza datele din tabel;
Daca o execut in scopul unui utilizator, de exemplu "User_1", din SSMS sau dintr-o interfata web care se conexteaza la baza de date prin acest user:
setuser 'User_1'
exec ProcTest_1
setuser
returneaza eroarea:
Msg 15274, Level 16, State 1, Line 2
Access to the remote server is denied because the current security context is not trusted.

Intrebarea mea este urmatoarea:
Ce trebuie sa mai configurez pe linked server pentru a putea rula procedura si in scopul altor useri;
Mentionez ca optiunile "RPC" si "RPC out" sunt setate pe true, iar pe ambele servere am rulat "ALTER DATABASE ... SET TRUSTWORTHY ON" pe bazele de date folosite;

Va multumesc!

Functie pentru convertirea numerelor in litere

Valy Maties — Mon, 10 Jun 2013 19:49:07 GMT

Va salut, stimati prieteni!
Pentru un prim post as vrea sa postez o functie pe care am cautat-o dar nu am gasit o solutie 100% buna, si din punct de vedere gramatical, prin care valorile de pe o chitanta si nu numai sa fie transformate in litere.
Pornind de la o idee gasita tot pe acest site (parca, nu mai stiu, am cautat in mai multe locuri) am creat functia aceasta:
(este copiata direct din serverul meu)
Sper sa ajute pe cineva!

/****** Object: UserDefinedFunction [dbo].[mvf_TraducereValori]    Script Date: 06/10/2013 22:37:57 ******/
/****** Se utilizeaza astfel: SELECT dbo.mvf_TraducereValori(435678243827109809.99) sau in loc de valoare
puneti un camp dintr-o tabela. Valoarea zecimalelor este tradusa doar pentru primele 2 cifre                   ******/
/****** Realizat de Vali Maties ******/

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE function [dbo].[mvf_TraducereValori] (@valoare numeric(32,2))
returns varchar(300)
as
begin
    -------------------------------------------------------------------------------------------

    declare @strval nvarchar(32),@lungime int=0,@retu varchar(300),@nivele int=0,@n1 int=0,@n2 int=0,@n3 int=0,
        @i int=0,@nivel varchar(3)

    set @strval=LTRIM(RTRIM(cast(cast(@valoare as bigint) as varchar(32))))
    if @valoare=0
        begin
            set @retu='ZeroLei'
            return @retu
        end
    declare @nivele_t table (nivel int,poz int,sg varchar(10),plural varchar(10))
        insert into @nivele_t values
            (1,1,'',''),
            (1,2,'Zece','Zeci'),
            (1,3,'Suta','Sute'),
            (2,1,'Mie','Mii'),
            (2,2,'Zece','Zeci'),
            (2,3,'Suta','Sute'),
            (3,1,'Milion','Milioane'),
            (3,2,'Zece','Zeci'),
            (3,3,'Suta','Sute'),
            (4,1,'Miliard','Miliarde'),
            (4,2,'Zece','Zeci'),
            (4,3,'Suta','Sute'),
            (5,1,'Bilion','Bilioane'),
            (5,2,'Zece','Zeci'),
            (5,3,'Suta','Sute'),
            (6,1,'Biliard','Biliarde'),
            (6,2,'Zece','Zeci'),
            (6,3,'Suta','Sute')
    declare @gfem table(id int,nume varchar(10))
        insert into @gfem values
            (1,'O'),
            (2,'Doua'),            (3,'Trei'),
            (4,'Patru'),        (5,'Cinci'),
            (6,'Sase'),            (7,'Sapte'),
            (8,'Opt'),            (9,'Noua')
    declare @gmasc table(id int,nume varchar(10))
        insert into @gmasc values
            (1,'Unu'),
            (2,'Doi'),            (3,'Trei'),
            (4,'Patru'),        (5,'Cinci'),
            (6,'Sase'),            (7,'Sapte'),
            (8,'Opt'),            (9,'Noua')
    declare @gneu table(id int,nume varchar(10))
        insert into @gneu values
            (1,'Unu'),
            (2,'Doua'),            (3,'Trei'),
            (4,'Patru'),        (5,'Cinci'),
            (6,'Sase'),            (7,'Sapte'),
            (8,'Opt'),            (9,'Noua')
    declare @ex table (id int,nume varchar(10))
        insert into @ex values
            (1,'Un'),            (4,'Pai'),
            (6,'Sai')

    set @nivele=ceiling(LEN(@strval)/3.0)
    if @nivele>(select max(nivel) nivel from @nivele_t)
        begin
            set @retu='Valoare mult prea mare!'
            return @retu
        end
    set @retu=''
    set @strval=REPLICATE('0',(@nivele*3)-len(ltrim(rtrim(@strval))))+LTRIM(@strval)
    while @i<@nivele
        begin
            set @i=@i+1
            select @nivel=LEFT(RIGHT(@strval,3*((@nivele-@i)+1)),3)
            set @n1=SUBSTRING(@nivel,1,1)
            set @n2=SUBSTRING(@nivel,2,1)
            set @n3=SUBSTRING(@nivel,3,1)
            select @retu=@retu+
            case
                when @n1<>0 and @n2<>0 and @n3<>0 then
                    (select nume from @gfem where id=@n1)+
                                            (Select case when @n1=1 then sg else plural end
                                                from @nivele_t where nivel=(@nivele-@i)+1 and poz=3)+
                    case when @n2=1 then case when @n3 in (1,4,6) then (select nume from @ex where id=@n3)
                               else case when @i<>@nivele then
                                   (select nume from @gneu where id=@n3)
                                   else (select nume from @gmasc where id=@n3) end end +'sprezece'
                        when @n2=6 then (select nume from @ex where id=@n2)+'zeciSi'+
                            (select nume from @gneu where id=@n3)
                        else (select nume from @gfem where id=@n2)+'zeciSi'+
                            case when @nivele>1 and (@nivele-@i)+1<>1 then
                                (select nume from @gneu where id=@n3) else
                                (select nume from @gmasc where id=@n3)
                                end
                                end+
                        (select plural from @nivele_t where nivel=(@nivele-@i)+1 and poz=1)
                when @n1<>0 and @n2=0 and @n3<>0 then
                    (select nume from @gfem where id=@n1)+
                                            (Select case when @n1=1 then sg else plural end
                                                from @nivele_t where nivel=(@nivele-@i)+1 and poz=3)+
                    (select nume from @gneu where id=@n3)+
                        (select plural from @nivele_t where nivel=(@nivele-@i)+1 and poz=1)
                when @n1<>0 and @n2<>0 and @n3=0 then
                    (select nume from @gfem where id=@n1)+
                                            (Select case when @n1=1 then sg else plural end
                                                from @nivele_t where nivel=(@nivele-@i)+1 and poz=3)+
                    case when @n2=1 then 'Zece'
                        when @n2=6 then (select nume from @ex where id=@n2)+'zeci'
                        else (select nume from @gfem where id=@n2)+'zeci' end+
                        (select plural from @nivele_t where nivel=(@nivele-@i)+1 and poz=1)
                when @n1=0 and @n2<>0 and @n3<>0 then
                    case when @n2=1 then case when @n3 in (1,4,6) then (select nume from @ex where id=@n3)
                                else case when @i<>@nivele then
                                   (select nume from @gneu where id=@n3)
                                   else (select nume from @gmasc where id=@n3) end end +'sprezece'
                        when @n2=6 then (select nume from @ex where id=@n2)+'zeciSi'+
                            case when @i=@nivele then (select nume from @gmasc where id=@n3) else
                            (select nume from @gneu where id=@n3) end
                        else (select nume from @gfem where id=@n2)+'zeciSi'+
                            case when @i=@nivele then (select nume from @gmasc where id=@n3) else
                            (select nume from @gneu where id=@n3) end end+
                        (select plural from @nivele_t where nivel=(@nivele-@i)+1 and poz=1)
                when @n1=0 and @n2<>0 and @n3=0 then
                    case when @n2=1 then 'Zece'
                        when @n2=6 then (select nume from @ex where id=@n2)+'zeci'+
                            (select nume from @gneu where id=@n3)
                        else (select nume from @gfem where id=@n2)+'zeci' end+
                        (select plural from @nivele_t where nivel=(@nivele-@i)+1 and poz=1)
                when @n1=0 and @n2=0 and @n3<>0 then
                    case when @i=nivele then
                          case when @n3<>1 then (select nume from @gmasc where id=@n3) else
                          (select nume from @ex where id=@n3) end else
          (select nume from @gfem where id=@n3)+
                        (select case when @n3=1 then sg else plural end
                            from @nivele_t where nivel=(@nivele-@i)+1 and poz=1)
                when @n1<>0 and @n2=0 and @n3=0 then
                    (select nume from @gfem where id=@n1)+
                                            (Select case when @n1=1 then sg else plural end
                                                from @nivele_t where nivel=(@nivele-@i)+1 and poz=3)+
                    (select plural from @nivele_t where nivel=(@nivele-@i)+1 and poz=1)
when @n1=0 and @n2=0 and @n3=0 then ''
                end
        end
        set @retu=@retu+case when @valoare=1 then 'Leu' else 'Lei' end
        -- Pana aici s-a tradus partea intreaga

        set @strval=right(CAST(@valoare as varchar(40)),2)
        if CAST(@strval as numeric(2,0))<>0
            begin
                set @n1=SUBSTRING(@strval,1,1)
                set @n2=SUBSTRING(@strval,2,1)
                select @retu=@retu+'Si'+
                    case
                        when @n1=0 and @n2<>0
                            then case when @n2=1 then
                                    (select nume from @ex where id=@n2)+'Ban'
                                else
                                (select nume from @gmasc where id=@n2)+'Bani'
                                end
                        when @n1<>0 and @n2=0
                            then case when @n1=1 then 'Zece'
                                    when @n1=6 then (select nume from @ex where id=@n1)+'zeci'
                                    else (select nume from @gfem where id=@n1)+'zeci' end+'Bani'
                        when @n1<>0 and @n2<>0
                            then case
                                    when @n1=1 then
                                        case
                                            when @n2 in (1,4,6,7) then
                                                (select nume from @ex where id=@n2)+'sprezeceBani'
                                            else (select nume from @gmasc where id=@n2)+'sprezeceBani'
                                        end
                                    when @n1=6 then (select nume from @ex where id=@n1)+'zeciSi'+
                                        (select nume from @gmasc where id=@n2)+'Bani'
                                    else (select nume from @gfem where id=@n1)+'zeciSi'+
                                        (select nume from @gmasc where id=@n2)+'Bani'
                                end

                    end
            end

    return @retu
    -------------------------------------------------------------------------------------------
end
GO

Partitionarea tabelelor de sistem MS-SQL

mitza — Fri, 09 Nov 2012 08:38:49 GMT

Hello World!
Se pot partiona tabelele de sistem din Microsoft SQL Server, care de fapt sunt view-uri de sistem(sys.tables, sys.columns, ...), sau se pot crea indexi sau statistici pe acestea, in vederea cresterii vitezei de accesare a lor, in conditiile unei aplicatii cu foarte multe tabele, implicit coloane si indexi si la care timpul de cautare in aceste tabele este foarte mare?
Va multumesc.

centre de certificare

elionescu — Mon, 06 Feb 2012 16:30:13 GMT

Hello World!

As vrea sa imi 'improspatez' certificarea de SQL Server 6.5 si am gasit (google) 3 centre unde se pot sustine astfel de examene in Bucuresti: Promanagement, Newhorizons, Intelprof.
Din pacate insa nu reusesc sa gasesc si pe site-ul Microsoft Romania o lista a tuturor centrelor autorizate. Ma poate ajuta, va rog, cineva?

Cu multumiri,
E. Ionescu

Incepator SQL...va rog ajutor

Campean Ciprian — Thu, 23 Feb 2012 17:04:27 GMT

Nu am reusit sa rezolv urmatoarea problema:

Se dă tabelul:
CREATE TABLE Angajaţi(
ID INTEGER NOT NULL,
Prenume VARCHAR (25) NOT NULL,
Nume VARCHAR (25) NOT NULL,
CNMU VARCHAR (13) NOT NULL,
Adresa VARCHAR (25) NOT NULL,
Domiciliu VARCHAR (25) NOT NULL,
DataNaşterii DATE,
LoculNaşterii VARCHAR (50),
NrTelefon VARCHAR (20),
PregătireŞcolară VARCHAR (20),
StareCivilă VARCHAR (20),
Sex VARCHAR (10),
SalariuMax NUMERIC (10),
SalariuMediu NUMERIC (10));

Cerinta este formulata asa:
Trebuie să prezentaţi toate stările civile în care se află cel mult 4 angajaţi. Aşadar, dacă aveţi stările:
-căsătorit
- necăsătorit
unde 5 angajaţi au starea căsătorit şi 3 angajaţi au starea necăsătorit, la ieşire, dvs. veţi afişa: necăsătorit, deoarece în starea civilă căsătorit se află mai mult de 4 angajaţi.

Nu am reusit sa ii dau de cap, desi am consultat ceva materiale....nu prea imi este clar...
Va rog cine poate sa ma indrume...
Multumesc

Auditare Sql Server 2008

ssandu — Thu, 31 Mar 2011 09:55:51 GMT

Salut tuturor
Am facut o auditare la un server SQL dar in fisierul sqlaudit rezultat la statement nu vad si valoarea parametrilor
De ex. am SELECT * FROM tabel WHERE cod = @cod
Cum sa fac sa vad si valoarea parametrilor ?
As vrea sa fac totul din facilitatea de auditare a SQL Server fara sa folosesc triggere pe tabele ptr INSERT, UPDATE, DELETE etc.
Multumesc

Transfer de formule din reporting service 2008 spre Excell

ionel_dragomir — Fri, 03 Jun 2011 10:30:40 GMT

Buna ziua,

Am rapoarte care functionau perfect in reporting service 2005 si se exportau in Excell cu formule in celule!

La sql 2008 R2 acelasi raport nu transfera formulele, pune direct rezultatul in celula din excell.

Cum pot rezolva acest lucru?

In textboxul din raport era scris:

=iif(LEFT(reportitems!textbox15.Value,1)="P",1,0)+iif(LEFT(reportitems!textbox23.Value,1)="P",1,0)+iif(LEFT(reportitems!textbox19.Value,1)="P",1,0)+....

si in excell era:

=iif(LEFT(_88232;1)="P",1,0)+iif(LEFT(_88233;1)="P",1,0)+iif(LEFT(_88234;1)="P",1,0)+.....

si la completarea celulelor la care se realiza referinta in celula rezultat se modifica valoarea!

Astept idei de rezolvare, dar va rog sa nu imi trimiteti link-ul ca nu se poate in sql 2008 R2.

Cu stima,

Ionel Dragomir

migrare de la SQL Server 2005 la SQL Server 2008 R2

roxanamau2002 — Wed, 06 Apr 2011 14:20:06 GMT

buna,

am nevoie de sfaturi in ceea ce priveste procesul de migrare de pe SQL Server 2005 pe SQL Server 2008 R2. migrarea consta in crearea unor servere noi, instalare SQL Server 2008 si migrarea bazelor de date si a pachetelor SSIS, SSAS. ma puteti sfatui la care pas sa dau atentie deosebita si ce anune sa verific inainte de a incepe intregul proces?

multumesc anticipat

database tuning advisor issue

crestinul — Thu, 24 Mar 2011 15:04:38 GMT

Am creat un trace xml plan ca sa-l analizez in Tuning Advisor,problema e ca -mi zice ca nu poate deschide fisierul .L-am salvat cu encodingul windows 1250 dar tot la fel.
Aveti cumva idee cepoate fi?
Multumesc mult

Certificare Sql Server 2008

mihaispr — Tue, 28 Dec 2010 19:47:34 GMT

Buna seara,

Ma intereseaza dk pot da gratuit acest examen ca user al forumului.

EXAM 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance.

70-431 nu mai exista in certificarile recunoscute Microsoft vad ca nu este in aceasta lista de mai jos:

http://demo.measureup.com/start.asp

Astept un raspuns.

Va multumesc.

Interogare mai ciudata

Syberye — Thu, 16 Dec 2010 14:12:44 GMT

Buna ziua

Am o tabela cu multe randuri, milioane. In aceasta tabela am 6 cimpuri care permit valori de la 1 la 4 (una din ele doar pana la 3 de fapt). Se doreste interogarea tabelei dupa unu sau mai multe cimpuri din cele 6 in mod dinamic. Adica la o interogare sa am poate doar doua campuri la alta toate la alta poate unu.

Cum as putea creste performata unui selecte (pe bune sint vreo 20 mil de randuri in tabela) in functie de ce se doreste sa se selecteze. (vreau sa spun ca aceasta tabela face un Join cu o alta tabela si mai are si alte campuri folosite in select)

Partea proasta este ca nu pot crea un index pe ele (mai ales ca o valoarea a oricarui cimp filtreaza foarte putin din date - lucru asta putind duce la o ignorare a index-ului)

Aveti cunva ceva ideie cum sa abordez aceasta problema.

Va multumesc

Tunning SQL Serve 2008

Syberye — Tue, 16 Nov 2010 06:15:56 GMT

Buna ziua

Am o situatie mai dificila legata de un select in SQL server. Am o tabela din care 4 campuri reprezinta cheia dupa care fac (3 bigint si un cimp data - cel problema) mai sint 5 campuri dupa care se poate face filtrare (3 string, bit, int) aceste campuri ma ajuta sa gasesc un bigint din cele 3 (acelas de fiecare data) si sint 5 valori (int, double) pe baza carora voi face sum, avg si operari pe sum, avg in total imi genereaza 8 valori agregate.
Se doreste raportari in timp real in functie de intervalul de data selectat (o prima problema) si poate in functie de cele 4 campuri de filtrare (este optional).
Problema este urmatoarea in fiecare zii imi vin intre 1-2 mil de inregistrari in tabela respectiva. Raportarea trebe sa se tinda pe un an in urma :(
La un prin set de 1.2 mil inregistrari am reusit sa duc selectul la 7 secunde (fara criteri de selectie) si cu criteri de selectie (produsul x sau valoarea mai mare decit x ..) la 2 secunde pe cel mai mare interval de timp.

Acuma am insa o baza de test de peste 17mil de inregistrari si urmeaza si se doreste sa se faca una de 500 mil inregistrari.

Imi puteti propune anumite modele, exemple (case study), articole legate de managementul unei asemenea cantitati de informati.

In acest moment ma gindesc sa rup tabelel pe intervale de timp (o tabela si o zii) si sa fac un view care pe baza unui union sa le stranga impreuna dar e greu de intretinut si nu stiu sincer daca ma va ajuta ca performanta (select in timp real :( cu parametri diferiti la fiecare select)

Va rog daca aveti sugesti ... va multumesc anticipat
Petre

SQL 2005 standard

marianc — Mon, 18 Oct 2010 14:34:04 GMT

Salut,
caut sa dowloadez o versiune trial de SQL 2005 Standard Trial. imi trebuie fix acesta versiune, nu express, toate linkurile Microsft trimit spre 2008.
Pe unde as putea sa gasesc?

Relationship between two databases

DanLaurentiu — Tue, 07 Sep 2010 11:27:19 GMT

Cum pot relationa doua baze de date in SQL Server 2008?

Ajutor problema incepator!

SorinM — Tue, 31 Aug 2010 16:49:31 GMT

Salut,

Sunt nou pe acest forum.

Am urmatoarea problema careia nu ii dau de cap:

Se da tabela departament cu coloanele departament, nume_angajat, salariu.

Sa se afiseze departamentele unde numarul de angajati este mai mare de 10 iar salariu este mai mare de 300$.

Multumesc.

Adaugare useri de domeniu SQL 2008 R2 pe win 2008 X64

bujulache — Thu, 19 Aug 2010 09:40:01 GMT

Salutare ...
Sunt conectat pe SQL 2008 cu userul meu de domeniu (care e de admin) si vreau sa adaug pt login si alti useri din domeniu insa nu reusesc ...imi apare un mesaj de genu ca acei useri nu exista...
Am tot cautat pe net dar inca nu am gasit nimic concret...inca mai caut...

Sql Server 2008 in Windows 7

DanLaurentiu — Wed, 24 Mar 2010 11:47:24 GMT

Am instalat Sql Server 2008 sau R2-ul si de fiecare data nu mi se instaleaza toate functionalizatile selectate(toate in afara de reporting si analysis services,full text ,sql server replication si database engine). Primesc in timpul instalarii o eroare de tipul "attempted to operate an unauthorized operation".Aveti idee cum pot rezolva asa ceva?

Microsoft Technologies Take Center Stage at India’s Most Definitive Conference for IT Professionals

Shaggy012 — Sat, 17 Apr 2010 06:23:51 GMT

Great Indian Developer Summit 2010 – Gold Standard for India's Software Developer Ecosystem

Bangalore, April 5, 2010: Microsoft has announced a slew of new and exciting releases that will help you take your code to the next level in 2010. As one of the longest running independent developer conferences in India, GIDS.NET at the Great Indian Developer Summit 2010 is uniquely positioned to provide a blend of practical, pragmatic and immediately applicable knowledge and a glimpse of the future of technology. At GIDS.NET, 0n 20 April 2010 in Bangalore, expert speakers will address a wide range of topics, including .NET 4.0, Silverlight 3, WCF 4, Visual Studio 2010, REST, Windows Workflow 4, Thread Synchronization, ASP.NET 4.0, SQL Server 2008 R2, LINQ, Unit Testing, CLR & C# 4.0, .NET Patterns, WPF 4, F#, Windows Azure, ADO.NET, Entity Framework, Debugging, T-SQL Tips & Tricks, and more. At GIDS.Web, on 21 April 2010, several more interesting topics such as Silverlight, SL RIA Web services, Microsoft AJAX, ASP.NET Ajax, tips and tricks for building Front-ends for ASP.NET and ASP.NET MVC, and so on. At GIDS.Workshops, on 23 April 2010, expert trainers hold intensive and interactive tutorials of 3 hour duration each on Silverlight, Ajax, JSON, Agile development and more. Read on for details on the Microsoft computing technologies addressed at GIDS.

On 20 April, Manuvir Das, who took Windows Azure from its first days as project Red Dog to its commercial launch and now heads MS' Remote Desktop Virtualization team, will conduct a keynote on cloud computing paradigm and what it means for developers. In the second keynote of the day, Amazon Web Services' Simone Brunozzi holds forth on the fundamental principles of Cloud Computing, and how they apply to work and business.

Stephen Forte, the Chief Strategy Officer of Telerik, will begin the day explaining how to build data driven, n-tier Rich Internet Applications (RIA) with Silverlight 4.0. In his second talk, he demonstrates how to properly architect and deploy a BI application using a mix of some exciting new tools and some old familiar ones -- OLTP, OLAP, ETL, Microsoft Excel's PowerPivot 2010, data analysis application and data visualization tools are all covered. Stephen's third talk at GIDS 2010 delves into the various techniques of sharing code between the Silverlight client and its ASP.NET Web server and their pros and cons. Some techniques work better in C#, others in VB while others are simpler with a little extra tooling or code-generation.

In the workshop on 23 April, Stephen, who is also a certified Scrum master, gives attendees a jump start for taking a certified scrum master exam, introducing Scrum, stepping through real world applications of the Scrum methodology, negotiating with the business, estimation and team dynamics, how to use Scrum in small and large organizations and consulting environments, using Scrum with virtual teams and in off-shoring, and the tools we will use for Agile development, including planning poker, unit testing, and much more.

Venkat Subramaniam delves into what the functional style of programming offers and how it can be utilized using the F# language on the .NET CLR. Mehfuz Hossain build a VS 2010 addin from ground up using the .Net 4.0 Features, Microsoft Extensibility Framework (MEF) and the Visual Studio 2010 Managed Addin Framework (MAF). In his second talk, Mehfuz shows how to access features like taskbar integration, jumplists, libraries, sensor platform to build a Windows 7 application.

Vinod Malhotra explains how Visual Studio 2010 helps testers quickly create complex multi-machine test environments, file rich actionable bugs faster and leverage test impact information to focus on right set of tests, developers replay the code execution to quickly reproduce a bug and find the root cause, and create automated functional tests and automate build-deploy-test automation to catch regressions. Sachin Vinod Rathi explain how VS 2010's out of the box support for SharePoint templates makes it easy to design, develop and deploy SharePoint Applications, Web Parts from within Visual Studio.

In his session at GIDS.NET Bijoy Singhal shows how to create a service based application in VS 2010 using .NET 4.0 - specifically the advancements in Windows Communication Foundation (WCF) and Windows Workflows Foundation (WF) targeted at the AppFabric, and covers how to package, deploy and manage the application in IIS/WAS using the new capabilities. Bijoys's second talk is an in-depther on Windows Workflow Foundation (WWF) and how it can be leveraged to quickly build a system based on Workflows to handle the various business rules and processes.

Vinod Jagannathan explains the who, why how and what of SQL Azure and conducts live demo of applications running on the cloud and best practices while Ramaprasanna Chellamuthu explians further about Windows Azure AppFabric.

Vineet Bhatia's focused session covers what is new in WCF 4.0 and how to configure communications across different protocols and platforms through the use of WCF. Vinod Kumar teaches writing and tuning queries and programming with T-SQL in SQL Server 2005 and 2008. Chaitra Nagaraj explains how to leverage the ASP.NET AJAX Library Beta, jQuery and AJAX Control Toolkit in ASP.NET applications.

Harish Ranganathan demonstrates how to take an existing ASP.NET Application that uses a SQL Server backend and migrate the application to Windows Azure. His second session, on 20 April, focuses on creating a 3 tier application with Data Access Layer using ADO.NET Entity Framework, Middle tier using WCF RIA Services and UI layer using ASP.NET Webforms.

Alok Jain presents an overview of the Windows Phone 7 application platform, developer tools, application frameworks, toolsets to rapidly build impactful applications for Windows Phone 7 series, and support for Silverlight and XNA. Reddy Duggempudi delves deeper explaining the functionality for Silverlight applications that is unique to the Windows Phone application platform, what it takes to build phone apps using Visual Studio 2010 and Microsoft Expression Blend, and the new input paradigms including multi-touch, software keyboard, accelerometer and microphone.

Janakiram MSV explains how a Java developer can leverage the Windows Azure Hosted Services and Storage Services for deploying and running applications on the cloud platform and utilising the storage using Windows Azure storage SDK. Praveen Srivatsa focuses on architecting and designing Java applications to leverage the cloud metaphor and the benefits of cloud hosted services and, perhaps more importantly, where it does not benefit.

Pandurang Nayak shows how to use Silverlight Web Services to build rich Internet apps. He conducts another session on using jQuery and Microsoft AJAX to build rich user experience for ASP.NET Webforms and ASP.NET MVC based web applications. Nahas Mohammed holds a demo-intensive session on how to consolidate hosting infrastructure by providing a single environment to host ASP.Net and PHP applications side-by-side in IIS.

If you are a developer, programmer, software engineer and/or architect who creates applications, write code, or develops websites leveraging the Microsoft .NET Framework, Visual Studio, SQL Server, jQuery, Visual Studio Team System, ADO.NET, Silverlight, WCF, WPF, RESTful Services, and more, Great Indian Developer Summit is one event you don't want to miss. Attend Great Indian Developer Summit to gain the information, education and solutions you seek. From post-conference workshops, breakout sessions by expert instructors, keynotes by industry heavyweights, enhanced networking opportunities, and more. For more information, visit: http://www.developersummit.com.

About Great Indian Developer Summit

Great Indian Developer Summit is the gold standard for India's software developer ecosystem for gaining exposure to and evaluating new projects, tools, services, platforms, languages, software and standards. Packed with premium knowledge, action plans and advice from been-there-done-it veterans, creators, and visionaries, the 2010 edition of Great Indian Developer Summit features focused sessions, case studies, workshops and power panels that will transform you into a force to reckon with. Featuring 3 co-located conferences: GIDS.NET, GIDS.Web, GIDS.Java and an exclusive day of in-depth tutorials - GIDS.Workshops, from 20 April to 24 April at the IISc campus in Bangalore.

At GIDS you'll participate in hundreds of sessions encompassing the full range of Microsoft computing, Java, Agile, RIA, Rich Web, open source/standards, languages, frameworks and platforms, practical tutorials that deep dive into technical skill and best practices, inspirational keynote presentations, an Expo Hall featuring dozens of the latest projects and products activities, engaging networking events, and the interact with the best and brightest of speakers from around the world.

For further information on GIDS 2010, please visit the summit on the web http://www.developersummit.com/

A Saltmarch Media Press Release
E: info@saltmarch.com
Ph: +91 80 4005 1000

sql server 2008 si windows 7

marcel soare — Mon, 01 Mar 2010 23:14:54 GMT

A instalat cineva sql 2008( inclusiv Analysis si Reporting Services) pe windows 7 ? Care sunt chestiunile cele mai importante (ex UAC), de ce trebuie sa tin cont la instalare?

Am instalat dupa ureche si apoi am tot avut probleme cu reporting, trebuia pornit numai drepturi de administrator.

Un link cu pasii de urmat ar fi ffffff util.

M

surface aria configuration pe sql 2008

crestinul — Wed, 27 Jan 2010 11:17:12 GMT

Am instalat pe un mediu de test microsoft sql server entreprise edition pe 64 biti.
Problema e ca nu reusesc sa-l setez sa accepe conexiuni tcp remote-in sql 2005 aveam utilitarul surface aria configuration in configuration tools pe 2008 insa se pare ca nu mai este.Din sql server config manager am activat tcp ip dar se pare ca tot nu merge, ma gandesc ca ar putea fi de la firewall de 2008 pt ca telnet pe 1433 nu raspunde,poate aveti idee ce ar putea fi.
MUltumesc

Problema pe x64

calinutz — Wed, 18 Nov 2009 14:28:21 GMT

Am instalat pe un XP Professional pe 64 de biti SQL Server 2008 Express. Probleme au inceput sa apara dupa prima saptamana de utilizare si anume, din Management Studio la executia unor select-uri simple Query Editorul ramanea agatat executand SELECT-ul meu peste 5-6 minute si probabil ar fi ramas in continuare pana la time out daca nu le opream. Cu toate ca in tabela pe care faceam select-ul avea 30 de record-uri si selectul era cel mai simplu posibil:
select * from tabela

Am observat comportamentul acesta pentru mai multe tabele din acelasi DB, si am decis sa re-instalez SQL Server-ul.
Poate greseala mea a fost ca am folosit web installer-ul de la MS. Problema este ca de data aceasta, dupa instalare, probabil din viteza am uitat (probabil) sa setez Mixed authentication si acum nu mai pot sa ma logez cu user si parola la serverul meu decat cu Windows Authentication, asa ca am decis sa il dezinstalez din nou pentru a il re-instala si a fi mai atent la pasii instalarii.
Si acum stau si astept de vreo o ora sa treaca de aprox 70% din dezintalare si nu se mai intampla nimic.
"Performing Windows Installer actions..."
"Slp_Config_Remove_Core_WMI_Provider_Cpu64"

Si nu mai se intampla nimic.
Acuma imi pun problema daca il opresc fortat procesul, sau daca dau un restart... poate imi ramane agatat in sistem si nu voi mai putea nici sa il dezinstalez si nici sa il instalez inapoi.
Ma dispera prostiile acestea.
Exista cumva un bug legat de x64 pentru SQL serer 2008 Express despre care nu stiu nici eu si nici cei de la MS?

Oledb visual fox Pro 9 pe 64 bits

Cornestian — Wed, 26 Aug 2009 07:52:24 GMT

In momentul de fata import si export fisiere .dbf folosind proceduri stocate prin oledb vfp 9.

Cu toate ca serverul suporta 64 bits sunt obligat sa rulez pe 32 bit datorila oledb for vfp9.

Ce alta solutie imi recomantati pentru 64 bits

Curiozitate ORDER BY si Select Top 1000 Rows

MrSmersh — Fri, 24 Jul 2009 19:32:54 GMT

Am facut un un view CREATE VIEW view as SELECT ID,col1,col2 FROM bla ORDER BY ID DESC...
Daca in SQL Server Management Studio dau din meniu Select Top 1000 Rows ignora orderu. Cristi cu ceva timp in urma mi-a explicat de ce, dar ceeace nu stiu e cum sa execut view facind ordonarea...
E folosit la client pentru diagnostic, si nu ii intereseaza SQL, ce e peste deschis un view e mult, si un raport doar pentru o ordonare e cam overkill.

Multumesc!

MSSMS CONECTAT LA SQL SERVER CE

ungureandavid — Tue, 14 Jul 2009 07:59:48 GMT

Salut,

Exista vre-o posibilitate sa ma conectez la un fisier sdf cu Microsoft Sql Server Management Studio 2008 ?

David