If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Rate Thread | Display Modes |
#1
|
|||
|
|||
How to read this
Start at the beginning. When you reach the end, stop.
|
Ads |
#2
|
|||
|
|||
How to read this
Introduction; Who should read this book; Who should not read this book;
Organization of this book; Conventions and features in this book; System requirements; Code samples; Acknowledgments; Errata & book support; We want to hear from you; Stay in touch; Getting started with Microsoft SQL Server 2012; Chapter 1: Overview of Microsoft SQL Server 2012; 1.1 Business intelligence; 1.2 Database Engine; 1.3 T-SQL programming interface; 1.4 Security subsystem; 1.5 Replication; 1.6 Summary; Chapter 2: Installing, Configuring, and Upgrading Microsoft SQL Server 2012; 2.1 Editions of SQL Server 2012; 2.2 Choosing hardware for SQL Server; 2.3 Software prerequisites; 2.4 Before installation; 2.5 Installing SQL Server; 2.6 After installation; 2.7 How to upgrade to SQL Server 2012; 2.8 Summary; Chapter 3: Using SQL Server 2012 administration and development tools; 3.1 Using SQL Server Books Online; 3.2 Using SQL Server Management Studio; 3.3 Using SQL Server Management Studio to create solutions and projects; 3.4 Using SQL Server Data Tools; 3.5 Using SQL Server Configuration Manager; 3.6 Summary; Designing databases; Chapter 4: Designing SQL Server databases; 4.1 Understanding SQL Server system databases; 4.2 Understanding the SQL Server database structure; 4.3 Adding files and filegroups; 4.4 Detaching and attaching SQL Server databases; 4.5 Understanding database recovery models; 4.6 Summary; Chapter 5: Creating your first table; 5.1 Developing a naming standard; 5.2 Understanding schemas; 5.3 Understanding SQL Server data types; 5.4 Understanding column properties; 5.5 Creating tables; 5.6 Altering tables; 5.7 Understanding computed columns; 5.8 Adding constraints to a table; 5.9 Understanding the FileTable; 5.10 Creating database diagrams; 5.11 Summary; Chapter 6: Building and maintaining indexes; 6.1 Index structure overview; 6.2 Adding index options; 6.3 Adding included columns; 6.4 Adding filters to indexes; 6.5 Placing indexes; 6.6 Disabling and dropping indexes; 6.7 Summary; Advanced database design topics; Chapter 7: Table compression; 7.1 Understanding row compression; 7.2 Understanding page compression; 7.3 Estimating effects of compression; 7.4 Compression considerations; 7.5 Summary; Chapter 8: Table partitioning; 8.1 Creating a partition function; 8.2 Creating a partition scheme; 8.3 Partitioning tables and indexes; 8.4 Summary; Chapter 9: Database snapshots; 9.1 Understanding database snapshot prerequisites and limitations; 9.2 Creating and viewing database snapshots; 9.3 Dropping database snapshots; 9.4 Reverting to a database snapshot; 9.5 Summary; Chapter 10: The SELECT statement; 10.1 Writing a SELECT statement; 10.2 Sorting results; 10.3 Filtering data with the WHERE clause; 10.4 Creating aliases; 10.5 Using the JOIN operator to return data from multiple tables; 10.6 Limiting the data returned in your result set; 10.7 Using UNION to combine result sets; 10.8 Summary; Using Transact-SQL (T-SQL); Chapter 11: Advanced data retrieval topics; 11.1 Pivoting and unpivoting data; 11.2 Paging data; 11.3 Writing expressions; 11.4 Using variables; 11.5 Summary; Chapter 12: Modifying data; 12.1 Inserting data into SQL Server tables; 12.2 Using sequence numbers; 12.3 Updating data in tables; 12.4 Deleting data from tables; 12.5 Merging data; 12.6 Returning output data; 12.7 Summary; Chapter 13: Built-in scalar functions; 13.1 Using date and time functions; 13.2 Using conversion functions; 13.3 Using string functions; 13.4 Using logical functions; 13.5 Summary; Creating other database objects; Chapter 14: Advanced T-SQL topics; 14.1 Aggregating, windowing, and grouping; 14.2 Windowing; 14.3 Using SQL Server temporary objects; 14.4 Handling T-SQL errors; 14.5 Controlling flow keywords; 14.6 Summary; Chapter 15: Views; 15.1 What are views?; 15.2 Creating indexed views; 15.3 Summary; Chapter 16: User-defined functions; 16.1 Understanding user-defined scalar functions; 16.2 Understanding table-valued functions; 16.3 Limitations of functions; 16.4 Summary; Chapter 17: Stored procedures; 17.1 Working with stored procedures; 17.2 Using the EXECUTE keyword; 17.3 Parameterizing stored procedures; 17.4 Dropping stored procedures; 17.5 Summary; Chapter 18: Data manipulation triggers; 18.1 Types of triggers; 18.2 Creating triggers; 18.3 Altering triggers; 18.4 Dropping triggers; 18.5 Enabling and disabling triggers; 18.6 Summary; SQL Server replication; Chapter 19: Replication; 19.1 Types of replication; 19.2 Replication agents; 19.3 Configuring replication; 19.4 Monitoring replication; 19.5 Summary; Database maintenance; Chapter 20: Backups; 20.1 Understanding backup devices; 20.2 Full database backups; 20.3 Differential database backups; 20.4 Transaction log database backups; 20.5 Restoring databases; 20.6 Summary; Chapter 21: Managing and maintaining indexes and statistics; 21.1 Checking index fragmentation; 21.2 Defragmenting indexes; 21.3 Creating and updating database statistics; 21.4 Summary; Chapter 22: Maintenance plans; 22.1 Performing database consistency checks; 22.2 Creating maintenance plans; 22.3 Summary; Database management; Chapter 23: SQL Server Profiler; 23.1 Understanding SQL Server Profiler; 23.2 Creating traces; 23.3 Running server-side traces; 23.4 Summary; Chapter 24: Extended Events; 24.1 Understanding the Extended Events architecture; 24.2 Creating and configuring an Extended Events session; 24.3 Using an Extended Events session to monitor system performance; 24.4 Summary; Chapter 25: SQL Server security; 25.1 Understanding principals; 25.2 Creating server logins; 25.3 Creating user-defined server roles; 25.4 Creating database users; 25.5 Creating built-in database roles; 25.6 Configuring contained databases; 25.7 Summary; Chapter 26: Resource Governor; 26.1 Enabling and disabling Resource Governor; 26.2 Creating resource pools; 26.3 Creating a workload group; 26.4 Using classifier functions; 26.5 Testing classifier functions; 26.6 Modifying Resource Governor configurations; 26.7 Summary; Chapter 27: SQL Server Agent; 27.1 SQL Server Agent components; 27.2 Viewing SQL Server Agent Configuration Manager options; 27.3 Configuring SQL Server Agent properties; 27.4 Creating operators; 27.5 Configuring alerts; 27.6 Configuring jobs; 27.7 Creating proxies; 27.8 Summary; Chapter 28: Database Mail; 28.1 Database Mail components; 28.2 Configuring Database Mail; 28.3 Sending email using Database Mail; 28.4 Monitoring Database Mail; 28.5 Summary; Chapter 29: Data definition triggers; 29.1 Types of triggers; 29.2 Creating triggers; 29.3 Altering triggers; 29.4 Enabling and disabling triggers; 29.5 Dropping triggers; 29.6 Summary; Chapter 30: Dynamic management objects; 30.1 Retrieving SQL Server metadata from DMOs; 30.2 Querying server performance statistics; 30.3 Querying server information; 30.4 Querying performance information; 30.5 Querying indexing statistics; 30.6 Summary; High-availability solutions; Chapter 31: AlwaysOn; 31.1 Failover cluster instance improvements; 31.2 Creating AlwaysOn Availability Groups; 31.3 Administering AlwaysOn Availability Groups; 31.4 Reading secondary database copies; 31.5 Summary; Chapter 32: Log shipping; 32.1 Log shipping components; 32.2 Log shipping prerequisites; 32.3 Configuring log shipping; 32.4 Summary; About the Author; |
#3
|
|||
|
|||
How to read this
Karlheinz Fenstermacher wrote:
Introduction; Who should read this book; Who should not read this book; Organization of this book; Conventions and features in this book; System requirements; Code samples; Acknowledgments; Errata & book support; We want to hear from you; Stay in touch; Getting started with Microsoft SQL Server 2012; Chapter 1: Overview of Microsoft SQL Server 2012; ... snipped the rest of the unformatted Table of Contents And what does Microsoft SQL Server have to do with THIS newsgroup? Did you happen to notice the title of THIS newsgroup? "How to read this". Are you expressing a problem in reading a book in a language that is not your native language? Or that you've never seen a book and don't know how to "operate" it? |
#4
|
|||
|
|||
How to read this
VanguardLH wrote:
Karlheinz Fenstermacher wrote: Introduction; Who should read this book; Who should not read this book; Organization of this book; Conventions and features in this book; System requirements; Code samples; Acknowledgments; Errata & book support; We want to hear from you; Stay in touch; Getting started with Microsoft SQL Server 2012; Chapter 1: Overview of Microsoft SQL Server 2012; ... snipped the rest of the unformatted Table of Contents And what does Microsoft SQL Server have to do with THIS newsgroup? Did you happen to notice the title of THIS newsgroup? "How to read this". Are you expressing a problem in reading a book in a language that is not your native language? Or that you've never seen a book and don't know how to "operate" it? It could be a part of this ebook. Price is listed as $31 CDN. "Microsoft SQL Server 2012 Step by Step By Patrick LeBlanc" https://books.google.ca/books?id=Ua1...ons%22&f=false It's available as a paperback too. http://www.barnesandnoble.com/w/micr...=9780735670037 Although what this has to do with Windows 7, who can say. Paul |
#5
|
|||
|
|||
How to read this
On Thu, 25 Jun 2015 20:19:26 -0500, VanguardLH wrote:
Karlheinz Fenstermacher wrote: Introduction; Who should read this book; Who should not read this book; snipped the rest of the unformatted Table of Contents And what does Microsoft SQL Server have to do with THIS newsgroup? Did you happen to notice the title of THIS newsgroup? A troll using that nym has also been infesting alt.usage.english recently, though not just with copy/paste junk as here. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#6
|
|||
|
|||
How to read this
In message , Paul
writes: VanguardLH wrote: [] language that is not your native language? Or that you've never seen a book and don't know how to "operate" it? [] Ah, are you perhaps referring to https://www.youtube.com/watch?v=pQHX-SjgQvQ (there are probably other copies)? -- J. P. Gilliver. UMRA: 1960/1985 MB++G()AL-IS-Ch++(p)Ar@T+H+Sh0!:`)DNAf computers don't solve problems; they help humans solve problems - Colin Barker, Computing 1999-2-18, p. 21 |
Thread Tools | |
Display Modes | Rate This Thread |
|
|