When you create a store procedure on Microsoft SQL Server with some input parameters, sometimes you don’t want to assign all of parameters (optional parameters) so you need to specify default value for the parameters. Otherwise, it shows error when execute the store procedure.
Have you ever try to delete or move a file and Windows have just told you that the file can’t be deleted or moved because it is in used even you’re pretty sure that currently you aren’t using that file?
This post, I’ll cover only in the second section “Create ASP.NET Web Application on MS Visual Studio 2005 (C#)”. I’m not going to repeat other sections again since they’re same as in the previous post. The other sections can be found in “Create Dynamic RSS Feed from MS SQL Server using ASP.NET, Part I: VB.NET”.
Before I started, let’s get to know what RSS is.
Quoted from Wikipedia.org Read the rest of this entry »
This post was continued from Getting started with Microsoft Windows Server Update Services, Part VI: Disconnected network(1). From the previous, you have already exported the WSUS’s meta data and update files. On this post, I’ll show how to import files and metadata to the disconnected WSUS server (the imported server).
In case that you have WSUS server separated from the Internet, you can’t get updates directly. Microsoft has provided a solution by setting up another WSUS server which can connect and update from the Internet. Next, download updates from the Internet to this server and then export updates and metadata to files and copy (may be via backup tape) to the WSUS server which is on the disconnected network.
After 4 parts have passed, you have finished basic configuration on WSUS server. Next, you need to configure client computers to contact the WSUS server to get some updates. The best way is to configure from the domain group policy so that you only configure once. Then, the policy will be apply to all clients in the domain but this approach requires you to have an active directory in domain. In this post, I’ll show how to configure clients using group policy to get updates from the WSUS server.
Note: You can also configure clients that in a non-active directory, too. But I won’t cover in this article.
Nessus vulnerability scanner is a tool which can discover and analyze vulnerabilities in the system so that IT staff can fix that holes and hence the system becomes more secure. Before scanning the system, it is necessary to update Nessus’s plugins to make sure that it’s up-to-date and will able to detect the latest vulnerabilities. If you have a disconnected network from the Internet, you need to update the Nessus’s plugins manually.
This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 2.5 License.