The Guru's Guide to SQL Server Architecture and Internals helps SQL Server power users manage their complex enterprise systems. This valuable reference manual goes far beyond the product's base ...

When I am teaching a class I always emphasize the importance of SQL Server Books Online. This Help system is, in my opinion, the best in the business. The proof is that even the experts use it on a ...

在 MicrosoftSQL Server 2000 中，分布式查询允许SQL Server用户访问基于SQL Server的服务器以外的数据(位于其他运行SQL Server的服务器或是具有OLE DB接口的其他数据源中)。OLE DB提供了统一的方式来访问异类数据源中的列表数据。 在本文中，分布式查询是指任何引用了一个 ...

Just a few days ago Eric Ligman, Microsoft’s director of partner experience, posted a massive list of free e-books from Microsoft on programming everything Redmondish. It’s a potential treasure trove ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

假定您现在拥有一个以Microsoft .NET为架构的网络订购系统，但是品管维护系统却仍然使用一套旧式的Oracle数据库应用程序。当您的顾客在产品保固期间下了产品更换之类的订单，则该笔订单将不收取任何费用。此时您需要从Oracle数据库得到实时的查询结果。

Next up in our series looking at open-source business applications is SQL-Ledger. This software package, written in the Perl scripting language, is a double-entry accounting system aimed at small and ...