Uncategorized


ea8yscquj6

Si se crea un KPI con MDX en un cubo de SQL Server, cuando dicha información se despliega en Performance Point Server 2007, en lugar del valor del KPI se muestra una etiqueta que dice ERROR para las columnas de value y goal tal y como se muestra en la siguiente figura:

image

PAra solucionarlo primero es recomendable instalar el SP2 de Performance Point, más detalles en http://office.microsoft.com/download/afile.aspx?AssetID=AM103381121033, además se debe verificar que el Application Pool del SharePoint y el application pool del Monitoring Server están configurados adecuadamente. Para más detalles consultar http://technet.microsoft.com/en-us/library/bb905547.aspx

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Si desea configurar un servidor de SQL Server en 32 bits y desea que el sistema operativo reconozca 32GB de RAM, puede tomar en cuenta las siguientes consideraciones.

Si usted desea mantener el sistema operativo en 32 bits, entonces su opción es tener Windows 2003 Enterprise configurado con PAE. Consulte lo siguiente:

PAE Mode http://www.microsoft.com/whdc/system/platform/server/PAE/pae_os.mspx
PAE is the second method supported to access memory above 4 GB; this method has been widely implemented. PAE maps up to 64 GB of physical memory into a 32-bit (4 GB) virtual address space using either 4-KB or 2-MB pages. The Page directories and the page tables are extended to 8 byte formats, allowing the extension of the base addresses of page tables and page frames to 24 bits (from 20 bits). This is where the extra four bits are introduced to complete the 36-bit physical address.

Windows supports PAE with 4-KB pages. PAE also supports a mode where 2-MB pages are supported. Many of the UNIX operating systems rely on the 2 MB-page mode. The address translation is done without the use of page tables (the PDE supplies the page frame address directly).

Para configurar PAE en Windows 2003 puede consultar este artículo http://msdn.microsoft.com/en-us/library/ms791485.aspx

Este es un ejemplo de cómo configurar PAE en Windows 2003

Primer Boot.ini:

[boot loader]

timeout=0

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT=” Windows Server 2003, Enterprise” /fastdetect

Cambie el Boot.ini de la siguiente forma:

[boot loader]

timeout=0

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT=” Windows Server 2003, Enterprise” /fastdetect /PAE

Si lo desea realizar por medio del commando Bootcfg utilice lo siguiente:

bootcfg /raw "/pae" /A /ID 1

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

La herramienta ForeFront Client Security y Windows Live One Care, pasaron las pruebas de antivirus, pueden ver todo el reporte en http://www.icsalabs.com/icsa/topic.php?tid=d3a8$95695e0b-40700fe6$8dd1-8fc093ea

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

 

May 2009 Testing Report

Desktop/Server Monthly Detection (4.0)

Vendor Product OS Criteria Pass/Fail
+/- ALWIL Software Avast 4 Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.8.1335 5/15/2009 5/15/2009 Passed
On-Demand Scan of Wild List 4.8.1335 5/15/2009 5/15/2009 Passed
+/- ALWIL Software Avast 4 Server Edition Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.8 5/13/2009 5/14/2009 Passed
On-Demand Scan of Wild List 4.8 5/13/2009 5/14/2009 Passed
+/- Authentium Command Antivirus for Windows Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.95.2 5/13/2009 5/14/2009 Passed
On-Demand Scan of Wild List 4.95.2 5/13/2009 5/14/2009 Passed
+/- AVG Technologies AVG Antivirus Professional Edition Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
On-Access Detection of Wild List 8.1.660 5/14/2009 5/14/2009 Failed
On-Demand Scan of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 8.1.660 5/14/2009 5/14/2009 Failed
+/- AVG Technologies AVG File Server Edition Win 2000 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.339 5/20/2009 5/20/2009 Passed
On-Demand Scan of Wild List 8.5.339 5/20/2009 5/20/2009 Passed
+/- AVG Technologies AVG File Server Edition Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
+/- AVG Technologies AVG Professional Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
+/- AVG Technologies AVG Professional Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
+/- Avira GmbH AntiVir Windows Workstation Linux Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 2.1.12-161 5/14/2009 5/18/2009 Passed
On-Demand Scan of Wild List 2.1.12-161 5/14/209 5/18/2009 Passed
+/- BitDefender SRL BitDefender Antivirus Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 12.0.12 5/11/2009 5/11/2009 Passed
On-Demand Scan of Wild List 12.0.12 5/11/2009 5/11/2009 Passed
+/- BullGuard Ltd. BullGuard Win 2000 Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 7.25481 5/18/2009 5/20/2009 Passed
On-Demand Scan of Wild List 7.25481 5/18/2009 5/20/2009 Passed
+/- BullGuard Ltd. Bullguard Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Failed
On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Failed
+/- BullGuard Ltd. Bullguard Internet Security Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
+/- CA, Inc. CA Anti-Virus Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 9.0.0.17 5/26/2009 5/11/2009 Passed
On-Access Detection of Wild List 9.0.0.174 5/8/2009 5/11/2009 Failed
On-Demand Scan of Wild List 9.0.0.174 5/26/2009 5/11/2009 Passed
On-Demand Scan of Wild List 9.0.0.174 5/8/2009 5/11/2009 Failed
+/- CA, Inc. CA Anti-Virus Win XP Home Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 9.0.0.175 5/26/2009 5/15/2009 Passed
On-Access Detection of Wild List 9.0.0.174 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 9.0.0.174 5/15/2009 5/15/2009 Passed
+/- CA, Inc. CA Anti-Virus for the Enterprise Linux Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 7.1.2885 5/27/2009 5/27/2009 Passed
On-Access Detection of Wild List 7.1.2885 5/16/2009 5/18/2009 Failed
On-Demand Scan of Wild List 7.1.2885 5/27/2009 5/27/2009 Passed
On-Demand Scan of Wild List 7.1.2885 5/16/2009 5/18/2009 Failed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win 2000 Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win 2000 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/15/2009 Passed
On-Access Detection of Wild List 8.1.660.0 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/15/2009 Passed
On-Demand Scan of Wild List 8.1.660.0 5/15/2009 5/15/2009 Failed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660 5/22/2009 5/15/2009 Passed
On-Access Detection of Wild List 8.1.660 5/14/2009 5/15/2009 Failed
On-Demand Scan of Wild List 8.1.660 5/22/2009 5/15/2009 Passed
On-Demand Scan of Wild List 8.1.660 5/14/2009 5/15/2009 Failed
+/- ESET, LLC ESET NOD32 Antivirus Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 3.0.672.0 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 3.0.672.0 5/18/2009 5/18/2009 Passed
+/- ESET, LLC ESET NOD32 Antivirus Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 3.0.667.0 5/15/2009 5/15/2009 Passed
On-Demand Scan of Wild List 3.0.667.0 5/15/2009 5/15/2009 Passed
+/- F-Secure Corporation F-Secure AntiVirus Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.0 build 101 5/11/2009 5/11/2009 Passed
On-Demand Scan of Wild List 8.0 build 101 5/11/2009 5/11/2009 Passed
+/- F-Secure Corporation F-Secure AntiVirus Internet Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.10 build 14240 5/15/2009 5/15/2009 Passed
On-Demand Scan of Wild List 8.10 build 14240 5/15/2009 5/15/2009 Passed
+/- IBM Internet Security Systems Proventia Desktop Endpoint Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 9.0.226.2270 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 9.0.226.2270 5/14/2009 5/14/2009 Passed
+/- Kaspersky Lab ZAO Kaspersky Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.0.0.357 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 8.0.0.357 5/12/2009 5/13/2009 Passed
+/- Kaspersky Lab ZAO Kaspersky Internet Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.0.0.506 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 8.0.0.506 5/18/2009 5/18/2009 Passed
+/- McAfee, Inc. VirusScan Win XP Home Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 13.3.127 5/20/2009 5/20/2009 Failed
On-Demand Scan of Wild List 13.3.127 5/20/2009 5/20/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Vista 32-bit Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0i 5/11/2009 5/12/2009 Failed
On-Access Detection of Wild List 8.5.0i 5/11/2009 5/12/2009 Failed
On-Demand Scan of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Vista 64-bit Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed
On-Demand Scan of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Win 2003 Server Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0 5/13/2009 5/14/2009 Failed
On-Demand Scan of Wild List 8.7.0 5/13/2009 5/14/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Win XP Pro Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0i 5/26/2009 5/27/2009 Failed
On-Demand Scan of Wild List 8.7.0i 5/26/2009 5/27/2009 Failed
+/- Microsoft Corporation Microsoft ForeFront Client Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Passed
On-Access Detection of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Failed
On-Demand Scan of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Passed
On-Demand Scan of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Failed
+/- Microsoft Corporation Microsoft ForeFront Client Security Win 2000 Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1958.0 1.57.1651.0 5/20/2009 Passed
On-Demand Scan of Wild List 1.5.1958.0 1.57.1651.0 5/20/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Client Security Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1958.0 1.57.1329.0 5/14/2009 Passed
On-Demand Scan of Wild List 1.5.1958.0 1.57.1329.0 5/14/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Client Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1955.0 5/19/2009 5/19/2009 Passed
On-Demand Scan of Wild List 1.5.1955.0 5/19/2009 5/19/2009 Passed
+/- Microsoft Corporation Windows Live OneCare Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 2.5.2900.24 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 2.5.2900.20 5/18/2009 5/19/2009 Passed
+/- Norman Norman Virus Control Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 5.99 6/3/2009 6/8/2009 Passed
On-Access Detection of Wild List 5.99 6/1/2009 6/1/2009 Failed
On-Access Detection of Wild List 5.99 6/1/2009 5/26/2009 Failed
On-Access Detection of Wild List 5.99 5/26/2009 5/26/2009 Failed
On-Demand Scan of Wild List 5.99 6/3/2009 6/8/2009 Passed
On-Demand Scan of Wild List 5.99 6/1/2009 6/1/2009 Failed
On-Demand Scan of Wild List 5.99 5/26/2009 5/26/2009 Failed
+/- Panda Security Panda AntiVirus Pro 2009 Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.00.00 5/19/2009 5/20/2009 Passed
On-Access Detection of Wild List 8.00.00 5/19/2009 5/20/2009 Failed
On-Demand Scan of Wild List 8.00.00 5/19/2009 5/20/2009 Passed
On-Demand Scan of Wild List 8.00.00 5/19/2009 5/20/2009 Failed
+/- Panda Security Panda for Desktops Win XP Pro Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.02.32 5/14/2009 5/15/2009 Failed
On-Demand Scan of Wild List 4.02.32 5/14/2009 5/15/2009 Failed
+/- Panda Security Panda for FileServers Win 2003 Server Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.02.32 5/14/2009 5/14/2009 Failed
On-Demand Scan of Wild List 8.02.32 5/14/2009 5/14/2009 Failed
+/- Panda Security Panda Internet Security 2009 Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 14.00.00 5/13/2009 5/13/2009 Passed
On-Demand Scan of Wild List 14.00.00 5/13/2009 5/13/2009 Passed
+/- PC TOOLS PC Tools Antivirus Win XP Pro Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.0.0.19 6/2/2009 6/2/2009 Failed
On-Access Detection of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
On-Access Detection of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 6.0.0.19 6/2/2009 6/2/2009 Failed
On-Demand Scan of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
+/- Radialpoint Radialpoint Internet Security Suite v.6.0 Win XP Home Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.0.4.27425 5/19/2009 5/20/2009 Passed
On-Demand Scan of Wild List 6.0.4.27425 5/19/2009 5/20/2009 Passed
+/- Radialpoint RadialPoint Internet Security Suite v.7.0 Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 7.0.22.31377 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 7.0.22.31377 5/12/2009 5/13/2009 Passed
+/- Symantec Corporation Norton Antivirus Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 16.5.0.134 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 16.5.0.134 5/14/2009 5/14/2009 Passed
+/- Symantec Corporation Norton Antivirus 2009 Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 16.5.0.134 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 16.5.0.134 5/12/2009 5/13/2009 Passed
+/- Symantec Corporation Symantec Endpoint Protection Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 11.0.780.1109 5/19/2009 6/12/2009 Passed
On-Demand Scan of Wild List 11.0.780.1109 5/19/2009 6/12/2009 Passed
+/- Symantec Corporation Symantec Endpoint Protection Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 11.0.780.1109 5/14/2009 5/15/2009 Passed
On-Demand Scan of Wild List 11.0.780.1109 5/14/2009 5/15/2009 Passed
+/- Symantec Corporation Symantec Endpoint Protection Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 11.0.780.1109 5/19/2009 5/21/2009 Passed
On-Demand Scan of Wild List 11.0.780.1109 5/19/2009 5/21/2009 Passed
+/- VirusBuster VirusBuster Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 5.3.157 6/10/2009 6/11/2009 Passed
On-Access Detection of Wild List 5.3.157 6/4/2009 6/4/2009 Failed
On-Access Detection of Wild List 5.3.157 5/19/2009 5/20/2009 Failed
On-Demand Scan of Wild List 5.3.157 6/10/2009 6/11/2009 Passed
On-Demand Scan of Wild List 5.3.157 6/4/2009 6/4/2009 Failed
On-Demand Scan of Wild List 5.3.157 5/19/2009 5/20/2009 Failed
+/- Webroot Software, Inc. Webroot AntiVirus (WAV) Win XP Home Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Access Detection of Wild List 6.0.2.39 6/2/2009 6/3/2009 Failed
On-Access Detection of Wild List 6.0.2.39 5/19/2009 5/20/2009 Failed
On-Demand Scan of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Demand Scan of Wild List 6.0.2.39 6/2/2009 6/3/2009 Failed
On-Demand Scan of Wild List 6.0.2.39 5/19/2009 5/20/2009 Failed
+/- Webroot Software, Inc. Webroot Internet Security Essentials (WISE) Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Access Detection of Wild List 6.1.0 Build 128 6/3/2009 6/3/2009 Failed
On-Access Detection of Wild List 6.1.0 Build 128 5/26/2009 5/26/2009 Failed
On-Access Detection of Wild List 6.1.0 Build 128 5/26/2009 5/26/2009 Failed
On-Demand Scan of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Demand Scan of Wild List 6.1.0 Build 128 6/3/2009 6/3/2009 Failed
On-Demand Scan of Wild List 6.1.0 Build 128 5/26/2009 5/27/2009 Failed

ECM (4.0)

Vendor Product OS Criteria Pass/Fail
+/- Microsoft Corporation Microsoft ForeFront Security for SharePoint Windows Server 2003 ECM Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed
On-Demand Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed
On-Demand Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Security for SharePoint Windows Server 2008 ECM Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the ECM Test Set 10.1.0802.0 05/20/2009 5/20/2009 Passed
On-Demand Detection of the ECM Test Set 10.1.0802.0 05/20/2009 5/20/2009 Passed

Gateway Monthly Detection (4.0)

Vendor Product OS Criteria Pass/Fail
+/- Anchiva Systems, Inc. Anchiva 206 Appliance Gateway Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
Mail On-Access 206 5/13/2009 5/13/2009 Passed
Mail On-Access 206 5/13/2009 5/13/2009 Failed
+/- Fortinet, Inc. Fortigate Appliance Gateway Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
Mail On-Access 3600 05/26/2009 5/12/2009 Passed
Mail On-Access 3600 05/12/2009 5/12/2009 Failed
+/- Secure Computing Corporation Webwasher Linux Gateway Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
Mail On-Access 6.7.1 build 3376 06/02/2009 5/14/2009 Passed
Mail On-Access 6.7.1 build 3376 05/14/2009 5/14/2009 Failed

Groupware Monthly Detection (4.0)

Vendor Product OS Criteria Pass/Fail
+/- GFI Software LTD MailSecurity Microsoft Exchange 2000 Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 10.0 Build 20060721 05/14/2009 5/14/2009 Passed
+/- McAfee, Inc. Groupshield Lotus Domino Groupware Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 5.3 05/14/2009 5/14/2009 Failed
+/- McAfee, Inc. Groupshield Microsoft Exchange 2000 Groupware Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 6.0.616.102 05/13/2009 5/14/2009 Failed
+/- Microsoft Corporation Microsoft ForeFront Security for Exchange Server Exchange 2007 on Windows Server 2003 Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 10.0.0566.0 05/18/2009 5/18/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Security for Exchange Server Exchange 2007 on Windows Server 2008 Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 10.1.0746.0 05/21/2009 5/21/2009 Passed
+/- Symantec Corporation Mail Security Lotus Domino Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 7.5.0.19 05/13/2009 5/14/2009 Passed
+/- Symantec Corporation Mail Security Microsoft Exchange Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 5.0.3.360 05/14/2009 5/14/2009 Passed

 

Para utilizar SQL 2008 con TFS 2008 debes primero aplicar el SP1 de TFS al instalador, primero tienes que bajar el SP1 desde la siguiente dirección

Download details- Visual Studio 2008 Team Foundation Server SP1

Después tienes que aplicar el SP1 al instalador de TFS 2008

  1. Copie el directorio del DVD del instalador al disco duro local
  2. Extraiga el a un directorio local con el comando  TFS90sp1-KB949786.exe /extract:<Destino del Sp1>
  3. Ejecute el siguiente comando para aplicar el Sp1 al instalador  msiexec /a <Directorio del AT>\vs_setup.msi /p <Directorio del SP1>\ TFS90sp1-KB949786.msp TARGETDIR=<Directorio del AT>
  4. Ahora ya tiene integrado el Sp1 con TFS 2008

Más información en

http://blogs.msdn.com/aabdou/archive/2008/05/13/team-foundation-server-sp1-beta-now-available.aspx

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Para saber la versión de SQL que está instalado en un servidor se puede utilizar el siguiente TSQL

select @@version

ó

select SERVERPROPERTY(‘productversion’), SERVERPROPERTY(‘productlevel’)

Esto da resultado por ejemplo:

10.0.2531.0    SP1

Pero si se instala el Cumulative Update 1 for SQL Server 2008 SP1, se tiene el siguiente resultado

10.0.2710.0    SP1

Entonces, cómo se sabe que el Cumulative Update está aplicado, si siempre dice SP1, para determinarlo puedes consultar la siguiente tabla, que es actualiza por Bill Graziano

http://www.sqlteam.com/article/sql-server-versions

 

 

SQL Server 2008
10.00.2714 SQL Server 2008 SP1 CU2 15 May 2009
10.00.2710 SQL Server 2008 SP1 CU1 16 Apr 2009
10.00.2531 SQL Server 2008 SP1 7 Apr 2009
10.00.1806 SQL Server 2008 RTM CU5 18 May 2009
10.00.1798 SQL Server 2008 RTM CU4 17 Mar 2009
10.00.1787 SQL Server 2008 RTM CU3 19 Jan 2009
10.00.1779 SQL Server 2008 RTM CU2 17 Nov 2008
10.00.1763 SQL Server 2008 RTM CU1 22 Sept 2008
10.00.1600 SQL Server 2008 RTM 6 Aug 2008
SQL Server 2005
9.00.4220 SQL Server 2005 SP3 CU3 21 Apr 2009
9.00.4211 SQL Server 2005 SP3 CU2 17 Feb 2009
9.00.4207 SQL Server 2005 SP3 CU1 20 Dec 2008
9.00.4035 SQL Server 2005 SP3 16 Dec 2008
9.00.3225 SQL Server 2005 SP2 CU13 21 Apr 2009
9.00.3315 SQL Server 2005 SP2 CU12 17 Feb 2009
9.00.3310 SQL Server 2005 Security Update 10 Feb 2009
9.00.3301 SQL Server 2005 SP2 CU11 15 Dec 2008
9.00.3294 SQL Server 2005 SP2 CU10 20 Oct 2008
9.00.3282 SQL Server 2005 SP2 CU9 18 Aug 2008
9.00.3257 SQL Server 2005 SP2 CU8 16 June 2008
9.00.3239 SQL Server 2005 SP2 CU7 14 April 2008
9.00.3233 SQL Server 2005 QFE Security Update 8 July 2008
9.00.3228 SQL Server 2005 SP2 CU6 18 Feb 2008
9.00.3215 SQL Server 2005 SP2 CU5 17 Dec 2007
9.00.3200 SQL Server 2005 SP2 CU4 15 Oct 2007
9.00.3186 SQL Server 2005 SP2 CU3 20 Aug 2007
9.00.3175 SQL Server 2005 SP2 CU2 28 June 2007
9.00.3161 SQL Server 2005 SP2 Cumulative Update 1 (CU1)  
9.00.3152 SQL Server 2005 SP2 Cumulative Hotfix 7 Mar 2007
9.00.3077 SQL Server 2005 Security Update 10 Feb 2009
9.00.3054 KB934458 – Fix to check database in maintenance plans. Also read Bob Ward’s post on SP2 for a great description of what to install. 5-Apr-07
9.00.3042.01 SQL Server 2005 “SP2a” 5-Mar-07
9.00.3042 SQL Server 2005 SP2 Feb-07
9.00.2047 SQL Server 2005 SP1  
9.00.1399 SQL Server 2005 RTM Nov-05
SQL Server 2000
8.00.2039 SQL Server 2000 SP4  
8.00.760 SQL Server 2000 SP3  
8.00.534 SQL Server 2000 SP2 30 Nov 2001
8.00.384 SQL Server 2000 SP1  
8.00.194 SQL Server 2000 RTM  
SQL Server 7
7.00.1063 SQL Server 7.0 SP4  
7.00.961 SQL Server 7.0 SP3 15 Dec 2000
7.00.842 SQL Server 7.0 SP2 20 Mar 2000
7.00.699 SQL Server 7.0 SP1 July 1999
7.00.623 SQL Server 7.0 / MSDE 1.0 RTM  
SQL Server 6.5
6.50.416 SQL Server 6.5 with Service Pack 5a  
6.50.415 SQL Server 6.5 with Service Pack 5  
6.50.281 SQL Server 6.5 with Service Pack 4  
6.50.258 SQL Server 6.5 with Service Pack 3  
6.50.240 SQL Server 6.5 with Service Pack 2  
6.50.213 SQL Server 6.5 with Service Pack 1  
6.50.201 SQL Server 6.5 RTM

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Les adjunto un excelente artículo sobre PeerToPeer Replication en SQL Server 2005, fue escrito por

Dinesh Asanka

http://www.sql-server-performance.com/articles/dba/peer-to-peer_replication_p3.aspx

Using Peer-To-Peer Transactional Replication

Let’s consider a typical online e-commerce application. In order to avoid downtime and reduce the load on any single server, the database for this application is in more than one location. As it is an online e-commerce system, data needs to be changed (through inserts, updates, and deletes) at each location and all the data modifications need to be replicated to the other servers. For example, let’s assume there are databases at location A, B, and C.

To accomplish this in SQL Server 2000, we would use merge replication. Location A is the publisher, and B and C are the subscribers.

clip_image001
Figure 1: Merge replication.

The obvious drawback of this method is that it is a single point of failure configuration. If database B is down, the A to C replication link will continue to work. Users who are connected to both servers A and C will not see any adverse effect. However, if database A fails, B and C will be isolated from the system. Modifications will not be visible on other end.

SQL Server 2000 replication uses the publisher and subscriber hierarchy method. Successful operation of this configuration requires that the publisher be present at all times.

With the peer-to-peer replication topology in SQL Server 2005, each node acts as a publisher and as a subscriber. Replication recognizes when changes have occurred on a given node but only allows those changes to cycle through the nodes one at a time.

clip_image002
Figure 2: Peer-to-peer replication.

If one database is down (A, for example), the other databases (B and C) can still replicate. Whenever that database (A) comes back up, it can synchronize with the others (B and C) and get the changes that took place after it went down. This is possible because the databases (A, B, and C) all act as both publisher and subscriber.

How to Configure Peer-to-Peer Replication

Now that we have seen how peer-to-peer transactional replication works, let’s look at the configuration options.

First, we need to create a publication. In SQL Server 2005, we’ll use the New Publication Wizard.

clip_image003
Figure 3: New Publication Wizard.

As you can see (above), there are four publication types. To configure peer-to-peer transactional replication, we need to select Transactional publication.

After the publication is created, we need to change its properties. In the Publication Properties window (see below), set Allow peer-to-peer subscriptions to True. Please note that once we set this property to “true” we cannot revert to “false” until replication for the publication is dropped.

clip_image004
Figure 4: Publication Properties.

Now we’ll go back, right click on the publication, and run the peer-to-peer transactional replication wizard (see below).

With this wizard, we can add more SQL Servers or SQL Server instances to the peer network. You will not be able to add main publication databases or the previously selected database on which we ran the wizard.

clip_image005
Figure 5: Configure Peer-To-Peer Topology Wizard: selecting peers.

After configuring the peer network, we need to specify how we have initialized the databases for the other servers in the peer-to-peer network.

clip_image006
Figure 6: Configure Peer-To-Peer Topology Wizard: initializing the new peers.

The obvious way to initialize the new peer databases is to restore the backups (making sure they are not changed before setting up peer-to-peer replication). Otherwise, we can specify the backup file used. The SQL Server engine will synchronize the databases by comparing the publication database to the backup.

After we provide authentication for the Log Reader and the SQL Agent, the wizard will begin building the peer-to-peer topology. For our example, the process results in the creation of three publications and six subscriptions (see below). For each publication, the wizard will create a distribution database as well.

clip_image007
Figure 7: Configure Peer-To-Peer Topology Wizard: building the topology.

When we have completed the wizard, this is what we’ll see in SQL Server 2005 explorer:

clip_image008
Figure 8: The results of running the wizard.

Introducing Another Node

In today’s competitive environment, businesses expand widely and frequently. What if we need to add another node? In SQL Server 2005, using peer-to-peer replication, all we need to do is configure the new node as a publisher and a subscriber and attach it to the peer-to-peer network.

Conclusion

Peer-to-peer transactional replication has added a new dimension to SQL Server database replication, giving DBAs more flexibility. As a new feature, it isn’t yet widely used. But it will be. So check it out and see how your organization will benefit.

Next Page »