good sql server books

13. T-SQL and SQL query AnalyzerWhat is SQL?What is T-SQL?Introduce new features of T-SQLHow to Use T-SQLSummaryIn this chapter, we will introduce some basic concepts about the Structured Query Language and transact-SQL and their differences. This

11. Microsoft SQL server network settingsOverview of Network ServicesSQL Server application interfaceNetwork Connection LibraryNetwork components and SQL server performanceNetwork MonitoringSummaryAfter you install Microsoft SQL Server, you must set

35. use SQL query analyzer and SQL profilerUse SQL query AnalyzerUse SQL profilerOptimize T-SQL statementSummaryIn this chapter, we will continue with the description of the pre-stored procedures in Chapter 21st. This chapter describes how to use

Because server A cannot see the witness server W or the original mirror partner server B, you must enter the disconnected state and make the database unavailable. Server B and Server w can compose quorum. Server B cannot see server A, so Server B

18. Create and use a view tableView tableView table conceptsCreate a viewModify and delete a tableEnhanced viewing table functionality in SQL Server 2000SummaryIn Chapter 17th, we learned about indexes. indexes are a secondary database structure

Basic SQL Server connection knowledge Abstract:The SQL Server 2000 client connects to SQL Server through a stack consisting of APIS, object libraries, and protocols. Ken Henderson will introduce each component of the stack one by one and explain how

I like reading books. After all, I am engaged in technology in the IT industry. If I don't read books or study, I may fall behind tomorrow. Since last year, I have been learning UML (United Model language). Software Engineers all know that it is

My messy technical books First, I declare that I am a book purchasing enthusiast. As long as the economy permits me, even if I only take a fancy to a certain chapter of a book, I will wander several times in the bookstore at most, but in

Books I read in 2011 the peak of the Tide [Recommended] -The history of the technology industry, including at-and-T, IBM, Apple, Intel, Microsoft, Cisco, Yahoo Inc. and Google, is worth seeing. as's program World -Read this book as long as you

SQL Server Database Synchronization is a commonly used part of the project. If data in a project is stored on different database servers, and these databases need to be called by multiple domains, configuring SQL Server Database Synchronization is a