appunti di Ermanno Goletto
Finalmente anch’io sono riuscito ad ottenere uno score di 1000 in un esame. Il 70-431 richiede la conoscenza delle nuove feature di SQL Server 2005: Mirroring, Snapshot, integrazione con CLR, Service Broker Inoltre è anche importante la conoscenza degli strumenti per il monitoring e il troubleshooting quali viste di sistema, SQL Profiler e relativi counter. … Leggi tutto
How to use the IIS Debug Diagnostics Tool to troubleshoot an IIS process that stops unexpectedly http://support.microsoft.com/kb/919789 How to troubleshoot an IIS process that consumes lots of RAM by using the IIS Debug Diagnostics tool http://support.microsoft.com/kb/919790 You cannot remotely connect to a named instance of SQL Server 2000 by using the TCP/IP protocol http://support.microsoft.com/kb/922131
How to configure SQL Server 2000 to use non-uniform memory access (NUMA) http://support.microsoft.com/kb/921928 SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS) http://support.microsoft.com/kb/919023 How to troubleshoot problems that occur when you start or use Word 2007, Word 2003, or Word 2002 http://support.microsoft.com/kb/921541
The user is not assigned to a default schema when you use Windows authentication to connect the user to SQL Server 2005 http://support.microsoft.com/kb/918346 Description of the Credential Roaming service update for Windows Server 2003 and for Windows XP http://support.microsoft.com/kb/907247 How to make the connection control apply to anonymous connections in an SMTP virtual server http://support.microsoft.com/kb/920600
How to transfer the logins and the passwords between instances of SQL Server 2005 http://support.microsoft.com/kb/918992
Cumulative hotfix package (build 2153) for SQL Server 2005 is available http://support.microsoft.com/kb/918222 How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005 http://support.microsoft.com/kb/917825 How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967 You cannot control the behavior that occurs when a user presses ENTER when you add … Leggi tutto
MDAC Component Checker http://go.microsoft.com/?linkid=4935017 Microsoft Shared Computer Toolkit for Windows XP version 1.1 http://go.microsoft.com/?linkid=4935020
How to upgrade or downgrade an assembly that has a referenced assembly for a CLR object in an instance of SQL Server 2005 http://support.microsoft.com/kb/917407
La pubblicazione di SQL Server tramite ISA 2004 seguendo la procedura standard http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/publishingsql.mspx pare abbia qualche problema. Per risolvere il problema sembra sia necessario creare un’ulteriore regola per consentire traffico sulla porta tcp 1433 tra localhost (isa) e il SQL Server. Di seguito il link al tread che ha condotto a queste conclusioni: http://forum.sysadmin.it/forum_posts.asp?TID=9426
How to install SharePoint Portal Server 2003 Service Pack 2 and Windows SharePoint Services Service Pack 2 in a deployment that uses SQL Server 2005 as the database back end http://support.microsoft.com/kb/917446 Microsoft SQL Server I/O subsystem requirements for the tempdb database http://support.microsoft.com/kb/917047 How to switch between forms in a Windows Forms application that is built … Leggi tutto