So what's coming wth IIS7, the overview session will highlight the key points of interests for IT Pros in Internet Information Services version 7. IIS7 modularity increases security by allowing a reduced installation footprint and creation of specialized, streamlined servers. Application Pools are now “sandboxed” by default. You’ll see how IIS7 ...

Recently on our Development platform we have deployed the Vista operating system to test an application against this installation. Part of the project is to deploy reports for the users using reporting services components, I was able to fix the issues between SQL Server 2005 & Vista but bit struggling with errors such as '' Access to the path ...

Also see Idera's hilarious new video! ''Life of Simon, SQL Server DBA'' http://www.youtube.com/ideradotcom View Video Format: ??? Duration: --:--...(read more)

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more keen on applying ''disabling SA account''! I was confronted by a Database developer that if there ...

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage of these systems is with 64-bit editions of Microsoft Windows products. Same way SQL Server has ...

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client ...

Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server)) You might have seen the above error very ...

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN it is pretty informative that : The /3GB ...