Microsoft SQL Server 2012 Bible
Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Format: PDF / Kindle (mobi) / ePub
Harness the powerful new SQL Server 2012
Microsoft SQL Server 2012 is the most significant update to this product since 2005, and it may change how database administrators and developers perform many aspects of their jobs. If you're a database administrator or developer, Microsoft SQL Server 2012 Bible teaches you everything you need to take full advantage of this major release. This detailed guide not only covers all the new features of SQL Server 2012, it also shows you step by step how to develop top-notch SQL Server databases and new data connections and keep your databases performing at peak.
The book is crammed with specific examples, sample code, and a host of tips, workarounds, and best practices. In addition, downloadable code is available from the book's companion web site, which you can use to jumpstart your own projects.
- Serves as an authoritative guide to Microsoft's SQL Server 2012 for database administrators and developers
- Covers all the software's new features and capabilities, including SQL Azure for cloud computing, enhancements to client connectivity, and new functionality that ensures high-availability of mission-critical applications
- Explains major new changes to the SQL Server Business Intelligence tools, such as Integration, Reporting, and Analysis Services
- Demonstrates tasks both graphically and in SQL code to enhance your learning
- Provides source code from the companion web site, which you can use as a basis for your own projects
- Explores tips, smart workarounds, and best practices to help you on the job
Get thoroughly up to speed on SQL Server 2012 with Microsoft SQL Server 2012 Bible.
configuration: consistency and performance. Graphically, many of the server options may be configured within the Server Properties page, which you can open by right-clicking a server in the console tree and choosing Properties from the Context menu. The General tab in Management Studio's SQL Server Properties dialog box (see Figure 19.1) reports the versions and environment of the server. Figure 19.1 The General tab of Management Studio's Server Properties dialog. The same information is
connections configuration option can be set by typing a value from 0 through 32767 in the Max Number of Concurrent Connections box on the Server Properties Connections tab (refer to Figure 19.9). The following code sets the maximum number of user connections to 10240: EXEC sp_configure ‘show advanced options', 1; RECONFIGURE; GO EXEC sp_configure ‘user connections', 10240; RECONFIGURE; SQL Server service must be restarted for the user connections option to take effect. To determine the maximum
statement will look like this: CREATE DATABASE AWMini (Edition= ‘Business', MaxSize=50 GB) Note A few words on cost and sizing. When you create a 50GB database, for example, you are paying for that 50GB, regardless of whether you have 5GB or 40GB of data in the database. That is because when you create the database, SQL Database allocates 50GB of space. You can programmatically change the size larger or smaller, but in SQL Database, you pay for the size you specify. One last note; unlike
assist product support and developers. Used to troubleshoot specific problems with working on a support ticket. Operational: Events geared toward DBAs and end users like Admin events, but include events that Operations may be interested in as well, such as when a database was detached. Channels are useful when searching for types of events and are used heavily in the new Extended Events Profiler UI. The system_health Session The system_health session is a predefined Extended Events session
and the CustomerIDs from SalesOrder2 are appended together into a single list. The first SELECT sets up the overall result, so it supplies the result set column headers. Each individual SELECT generates a result set for the UNION operation, so each SELECT's individual WHERE clause filters data for that SELECT. The final SELECT's ORDER BY then serves as the ORDER BY for the entire unioned results set. The ORDER BY must refer to the columns by either the first SELECT's column names or by the