Pro SQL Azure

Learn the basics of Microsoft Azure and understand how SQL Server on Azure VMs (Infrastructure-as-a-Service) and Azure SQL Databases (Platform-as-a-Service) work. This book shows you how to deploy, op

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database—one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach:

Pro SQL Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwid

MODEL clause, and advanced grouping syntax---features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing over

SQL Azure represents Microsoft’s cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name "Oslo").Pro SQL Azure introduces

Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Mi

Pro SQL Server 2012 Administrationis a one-stop source for all the knowledge you'll need to professionally manage a database under Microsoft SQL Server 2012. SQL Server administration is a complex fie

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more

Provides information on the administration of SQL Server 2008, covering such topics as performing backups and recovery; monitoring server activity; managing security; and automating routine maintenanc

Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book w

The end of the twentieth century also marked the beginnings of the Extensible Markup Language (XML). SQL (Structured Query Language) Server was only a year or two later but allowed for yet another qua

Pro TSQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, builtin TransactSQL language. Discussing new and existing features, the book takes you on an

In a series of books written by experts, each installment aims to help the IT professional hone his or her skill set in a particular programming language. Original.

Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level report

In a series of books written by experts, each installment aims to help the IT professional hone his or her skill set in a particular programming language. Original.

In a series of books written by experts, each installment aims to help the IT professional hone his or her skill set in a particular programming language. Original.

Now available in paperback— Service Broker is a key Microsoft product in support of message–based processing between applications. Pro SQL Server 2008 Service Broker helps you to take full advantage o

Every business has reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, act

In a series of books written by experts, each installment aims to help the IT professional hone his or her skill set in a particular programming language.

Pro SQL Server 2008 Failover Clustering is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations. Whether deploying a single–instance, two–node clu

This tutorial describes and demonstrates new T-SQL features with working examples, and can be used as a reference for quickly locating details about specific features. The book addresses the needs of

An updated guide to Microsoft's enterprise-level reporting tool discusses the new features of SQL Server 2008, with detailed coverage of such topics as building reports, using Report Designer, designi

Provides information on writing message-based applications using the Server Broker feature of SQL Server 2008.

From fundamentals to advanced topics, this book teaches readers not only how to use SQL Server Integration Services (SSIS), but also how to make integration projects stronger, faster, and smarter. The

Provides information on the architecture and features of the T-SQL programming language.

* Deep, thorough coverage of all SRS 2005 technologies related to professional-level business reports* Supported and technically validated by the MS team* Especially (but not exclusively) applicable t

台灣微軟雲端解決方案副總經理 宋明遠 專業推薦! *　完整涵蓋SQL Server 2022及其向下相容版本之管理技巧 *　從DBA觀點出發，建立正確的資料庫系統觀念 *　最實用的企業級資料庫管理與維護指南，解決常見的技術瓶頸 現今的資訊系統邁向全面性地連結整合，從手機、平板乃至於各種裝置、個人電腦與伺服器在結合公有/私有雲後，強化了無所不在的資料應用。但隨之而來的是處理資料的質與量爆增。企業的競爭力絕大部分取決於資訊系統，而資訊系統的核心之一是資料庫。 本書作者以累計超過30年的資料庫管理經驗，由建置穩健的資料庫系統開始，教導讀者一步步打造出可靠有效的環境，並學會最實務的管理與維護技巧。 ■　介紹SQL Server 2022的新功能，說明其設計理念與應用情境。 ■　安裝SQL Server，介紹硬體需求、選擇適當的服務、元件與帳戶，設定系統的驗證模式與管理帳戶的密碼等，開始邁入SQL Server的殿堂。 ■　說明SQL Server Management Studio（SSMS）各項功能，透過圖形化管理介面來管理伺服器。 ■　解說SQL Server資料庫的資料檔案與交易記錄檔案的結構與特性，以獲取最佳磁碟效能。 ■　計畫完善的備份/還原策略，可協助保護資料庫免於遺失資料。藉由還原備份和復原資料庫來測試備份/還原策略，以有效地面對各類災難事件。 ■　SQL Server提供完善的自動化自我管理機制，管理人員可將管理工作交由SQL Server Agent服務代勞，讓管理SQL Server資料庫系統事半功倍。 ■　介紹監控常用的擴充事件和SQL Server Profiler工具程式，並說明如何透過Windows系統提供的效能計數器分析整體效能，以透過資源管理員控管伺服器上的硬體資源。 ■　說明系統「可用性」的需求及規劃，進而說明SQL Server提供的「高可用性」解決方案及相關技術。 ■　實做SQL Server不同類型的複寫，針對部分的資料內容，持續且即時地將變動從一個資料庫帶到另一個資料庫。 ■　介紹Azure上與SQL Server相關的架構與技術，說明備份與高可用性、基本的安全規劃、紀錄與監控，以及自動化作業等。