SQL Server 2005 RTM !

Today we change the game, again!   We entered this market 15 years ago as the number 5 player in a field of 4 competitors.  Today only 2 of those competitors remain, IBM and Oracle, and we sell more units of SQL Server each year than both of them combined.   To Be Clear –…

0

Visual Studio 2005 et le .Net Framework 2.0 RTM !

“I am very proud to announce that this morning we shipped Visual Studio 2005 and the .NET Framework 2.0!  This is truly a momentous occasion for our customers around the world and for us.  This is clearly the most productive, most secure, and most reliable enterprise ready platform and tools ever released from the Developer Division. …

0

Microsoft fait ses premiers pas dans le Libre…

par Pierre Tran “Microsoft et l’Open Source étaient jusqu’alors deux entités antagonistes, incompatibles. Mais les temps changent. Après avoir pactisé avec JBoss, l’ennemi public n°1 du monde libre simplifie ses licences Shared Source et réduit de dix à trois le nombre de ces licences. “ La suite ici : http://www.lemondeinformatique.fr/sections/actualites/developpeur_referenc/microsoft_fait_ses_p 

0

Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (6/6) …

Create Inbound certificates on ZAGREB.sql :connect ZAGREB USE master;— drop login BUDA_loginCREATE LOGIN BUDA_login WITH PASSWORD = ‘1Sample_Strong_Password!@#’;CREATE LOGIN PEST_login WITH PASSWORD = ‘1Sample_Strong_Password!@#’;GO SELECT * FROM sys.server_principals USE master;— DROP USER BUDA_userCREATE USER BUDA_user FOR LOGIN BUDA_login;— DROP USER PEST_userCREATE USER PEST_user FOR LOGIN PEST_login; GO SELECT * FROM sys.sysusers; USE master;CREATE CERTIFICATE BUDA_cert  …

0

Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (5/6) …

Create Inbound certificates on PEST.sql :connect PEST USE master;— drop login BUDA_loginCREATE LOGIN BUDA_login WITH PASSWORD = ‘1Sample_Strong_Password!@#’;— drop login ZAGREB_loginCREATE LOGIN ZAGREB_login WITH PASSWORD = ‘1Sample_Strong_Password!@#’;GO SELECT * FROM sys.server_principals USE master;— DROP USER BUDA_userCREATE USER BUDA_user FOR LOGIN BUDA_login;— DROP USER ZAGREB_userCREATE USER ZAGREB_user FOR LOGIN ZAGREB_login;GO SELECT * FROM sys.sysusers; USE master;CREATE…

0

Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (4/6) …

Create Inbound certificates on BUDA.sql :connect buda USE master;— drop login PEST_loginCREATE LOGIN PEST_login WITH PASSWORD = ‘1Sample_Strong_Password!@#’;— drop login ZAGREB_loginCREATE LOGIN ZAGREB_login WITH PASSWORD = ‘1Sample_Strong_Password!@#’;GO SELECT * FROM sys.server_principals USE master;— DROP USER PEST_userCREATE USER PEST_user FOR LOGIN PEST_login;— DROP USER ZAGREB_userCREATE USER ZAGREB_user FOR LOGIN ZAGREB_login;GO SELECT * FROM sys.sysusers; USE master;CREATE…

0

Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (3/6) …

Create Outbound certificates on ZAGREB.sql :connect ZAGREB — Activate DB Mirroring DBCC TRACEON (1400) — DROP endpoint mirroring— DROP certificate BUDA_cert— DROP master key CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘<1_Strong_Password!>’;GO USE master;CREATE CERTIFICATE ZAGREB_cert    WITH SUBJECT = ‘ZAGREB certificate for database mirroring’, START_DATE = ’09/28/2005′,  EXPIRY_DATE = ’09/28/2006′GO USE master;SELECT * FROM sys.certificates;…

0

Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (2/6) …

Create Outbound certificates on PEST.sql :connect PEST — Activate DB Mirroring DBCC TRACEON (1400) — DROP endpoint mirroring— DROP certificate PEST_cert— DROP master key CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘<1_Strong_Password!>’;GO USE master;CREATE CERTIFICATE PEST_cert    WITH SUBJECT = ‘PEST certificate for database mirroring’, START_DATE = ’09/28/2005′,  EXPIRY_DATE = ’09/28/2006′GO USE master;SELECT * FROM sys.certificates;…

0

Mise en oeuvre du Database Mirroring avec SQL Server 2005 RTM (1/6) …

Create Outbound certificates on BUDA.sql :connect BUDA — Activate DB Mirroring DBCC TRACEON (1400) — DROP endpoint mirroring— DROP certificate BUDA_cert— DROP master key CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘<1_Strong_Password!>’;GO USE master;CREATE CERTIFICATE BUDA_cert    WITH SUBJECT = ‘BUDA certificate for database mirroring’, START_DATE = ’09/28/2005′,  EXPIRY_DATE = ’09/28/2006′GO USE master;SELECT * FROM sys.certificates;…

0