西风居
===========================================================
IIS6.0 Appliation pool
===========================================================

Isolating Web Sites and Applications (IIS 6.0)

Although some of the Web servers that you deploy host only one Web site or application, you might also need to host multiple Web sites and applications on the same Web server. When a Web server hosts multiple Web sites and applications, each Web site and application requires a certain level of isolation.

For example, an Internet service provider (ISP) might host Web sites and applications for hundreds of organizations, each having a unique Web site. In this situation, the security requirements of each organization require a high degree of isolation between Web sites and applications.

Figure 3.4 illustrates the tasks involved in the process isolating your Web sites and applications.

 查看全文
whitechief 发表于:2006.06.14 00:47 ::分类: ( 计算机技术 ) ::阅读:(1438次) :: 评论 (1)
===========================================================
Configure email sending in Reporting Service 2005
===========================================================

I am here to provide a config file sample to show how to configure a smtp server in reporting service 2005.

 查看全文
whitechief 发表于:2006.05.24 04:55 ::分类: ( 计算机技术 ) ::阅读:(1120次) :: 评论 (0)
===========================================================
SQL Server 主健小议 - 转
===========================================================
我们在建立数据库的时候,需要为每张表指定一个主键,所谓主键就是能够唯一标识表中某一行的属性或属性组,一个表只能有一个主键,但可以有多个候选索引。 因为主键可以唯一标识某一行记录,所以可以确保执行数据更新、删除的时候不会出现张冠李戴的错误。当然,其它字段可以辅助我们在执行这些操作时消除共享冲 突,不过就不在这里讨论了。主键除了上述作用外,常常与外键构成参照完整性约束,防止出现数据不一致。所以数据库在设计时,主键起到了很重要的作用。 查看全文
whitechief 发表于:2006.04.27 04:35 ::分类: ( 计算机技术 ) ::阅读:(354次) :: 评论 (2)
===========================================================
SQL Server auditing script - 原创
===========================================================
A stored procedure + configure it to run when starting up + query it from analyzer 查看全文
whitechief 发表于:2006.04.27 02:23 ::分类: ( 计算机技术 ) ::阅读:(195次) :: 评论 (0)
===========================================================
SQL Server Auditing
===========================================================

1, Windows event log

2, SQL Server Error log

3, Use c2 audit option

EXEC sp_configure 'show advanced option', '1'

RECONFIGURE

EXEC sp_configure 'c2 audit mode',1

RECONFIGURE

4, using the customized script

 查看全文
whitechief 发表于:2006.04.26 06:44 ::分类: ( 计算机技术 ) ::阅读:(265次) :: 评论 (0)
===========================================================
Change Windows service of MS SQL Server Reporting Service 2005
===========================================================
There is a support article for sql server 2000. http://support.microsoft.com/kb/842421/ 查看全文
whitechief 发表于:2006.04.20 07:06 ::分类: ( 计算机技术 ) ::阅读:(214次) :: 评论 (0)
===========================================================
How to get the current user in sql server connection
===========================================================
select system_user
select current_user


whitechief 发表于:2006.03.31 08:11 ::分类: ( 计算机技术 ) ::阅读:(222次) :: 评论 (0)
===========================================================
SQL Server replication: 2005-> 2000
===========================================================
Some tips: 查看全文
whitechief 发表于:2006.03.31 08:08 ::分类: ( 计算机技术 ) ::阅读:(280次) :: 评论 (0)
===========================================================
reporting service 2005 在 xp professional 上的安装和配置
===========================================================

公司决定使用microsoft reporting service 2005. So I just installed one instance on my own machine. After the installation and configuration, it is runing well now.

In a word, my feeling is that SSRS 2005 is still not so stable. I encountered many small problems that seemed very wierd. Because of time limit, I just uninstall it and reinstall it again and again. And finally, it works. The following is some points worthy of notice.

 查看全文
whitechief 发表于:2006.02.14 06:44 ::分类: ( 计算机技术 ) ::阅读:(581次) :: 评论 (1)
===========================================================
Cannot connect to the website on xp pro from outside
===========================================================
今天遇到一个奇怪的问题,好像从其他机器不能访问xp pro上建立的website 查看全文
whitechief 发表于:2006.02.11 05:30 ::分类: ( 计算机技术 ) ::阅读:(299次) :: 评论 (0)
===========================================================
unix datetiimestamp 转化为 oracle date type
===========================================================

有时我们需要把unix时间戳转化为oralce date类型,但是oracle的to_date函数没有提供直接的函数来做这件事,因此我们需要自己写一个函数完成此功能。

具体脚本如下:

 查看全文

whitechief 发表于:2005.12.02 11:53 ::分类: ( 计算机技术 ) ::阅读:(340次) :: 评论 (2)
===========================================================
oracle里long类型的总结
===========================================================
1、LONG 数据类型中存储的是可变长字符串,最大长度限制是2GB。

2、对于超出一定长度的文本,基本只能用LONG类型来存储,数据字典中很多对象的定义就是用LONG来存储的。
 查看全文
whitechief 发表于:2005.11.30 11:48 ::分类: ( 计算机技术 ) ::阅读:(478次) :: 评论 (3)
===========================================================
SQL Server 安装后改动计算机名带来的问题以及解决方法
===========================================================

问题:

1,数据库复制不能正确建立

 查看全文
whitechief 发表于:2005.07.28 13:21 ::分类: ( 计算机技术 ) ::阅读:(363次) :: 评论 (0)
===========================================================
Oracle 服务器内存坏了,一直报错 ORA-600
===========================================================

刚开始的现象是长查询的时候,报错ORA-600;后来换了内存条后,这些查询都能正常运行了。但是这时我发现,数据字典不能用了。

 查看全文
whitechief 发表于:2005.07.07 22:03 ::分类: ( 计算机技术 ) ::阅读:(399次) :: 评论 (0)
===========================================================
SQL Server 中的数据库复制技术和log_shipping技术
===========================================================
SQL Server中提供了2种技术,可以把一个数据库的内容定期发到另一台服务器上,那么,这2种技术的分别何在? 查看全文
whitechief 发表于:2005.07.01 13:52 ::分类: ( 计算机技术 ) ::阅读:(401次) :: 评论 (0)
切换风格
新闻聚合
博客日历
文章归档...
最新发表...
博客统计...
网站链接...