Expert SQL Server 2008 Development

I’ve worked with Microsoft SQL Server for nearly ten years now, and I’ve used SQL Server 2008 since the very first preview version was made available to the public. One thing I have noticed is that, with every new release, SQL Server grows ever more powerful, and ever more complex. There is now a hu...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Những tác giả chính: Aitchison, Alastair, Machanic, Adam
Định dạng: Sách
Ngôn ngữ:English
Được phát hành: Apress 2012
Những chủ đề:
Truy cập trực tuyến:http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/31350
Các nhãn: Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
Miêu tả
Tóm tắt:I’ve worked with Microsoft SQL Server for nearly ten years now, and I’ve used SQL Server 2008 since the very first preview version was made available to the public. One thing I have noticed is that, with every new release, SQL Server grows ever more powerful, and ever more complex. There is now a huge array of features that go way beyond the core functionality expected from a database system and, with so many different facets to cover, it is becoming ever harder to be a SQL Server "expert". SQL Server developers are no longer simply expected to be proficent in writing T-SQL code, but also in XML and SQLCLR (and knowing when to use each). You no longer execute a query to get a single result set from an isolated database, but handle multiple active result sets derived from queries across distributed servers. The types of information stored in modern databases represent not just character, numeric, and binary data, but complex data such as spatial, hierarchical, and filestream data. Attempting to comprehensively cover any one of these topics alone would easily generate enough material to fill an entire book, so I'm not even going to try doing so. Instead, I’m going to concentrate on what I believe you need to know to create high-quality database applications, based on my own practical experience. I’m not going to waste pages discussing the ins and outs of some obscure or little-used feature, unless I can show you a genuine use case for it. Nor will I insult your intelligence by laboriously explaining the basics – I'll assume that you're already familiar with the straightforward examples covered in Books Online, and now want to take your knowledge further.