Professional Microsoft SQL Server 2012 Administration
Adam Jorgensen, Steven Wort, Ross LoForte, Brian Knight
Format: PDF / Kindle (mobi) / ePub
An essential how-to guide for experienced DBAs on the most significant product release since 2005!
Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security.
- Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server
- Walks you through ways to manage and monitor SQL Server and automate administration
- Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements
- Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting
- Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services
- Includes real-world case examples and best practices from Microsoft insiders
If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.
Requirements screen opens and displays a summary of space to be used by the features selected. Click Next. 12. The Server Conﬁguration screen opens. Provide the service accounts under which SQL Server Database Engine, SQL Server Agent, and SQL Server Browser run under and the Collation to be used by SQL Server 2012. Click Next. Figure 2-7 shows the Server Conﬁguration screen. Installing SQL Server ❘ 39 FIGURE 2-7 As a Security best practice, always consider choosing Service Accounts
File Viewer screen. From this screen, you can check and uncheck log ﬁles that you want to bring into the view. You can consolidate logs from SQL Server, Agent, and the Windows Event Files, as shown in Figure 4-10. Management Studio ❘ 91 FIGURE 4-10 In some situations, you may want to merge the logs from several machines into a single view to determine what’s causing an application problem. To do this, click the Load Log button, and browse to your .LOG ﬁ le. That ﬁ le could be a Windows error
sys.dm_exec_sql_text Multiserver Management Central Management Servers and Server Groups SQL Server Utility Trace Flags Getting Help from Support SQLDumper.exe SQLDiag.exe Summary CHAPTER 5: AUTOMATING SQL SERVER Maintenance Plans Maintenance Plan Wizard Maintenance Plan Designer Automating SQL Server with SQL Server Agent Jobs Schedules Operators Alerts SQL Server Agent Security Service Account Access to SQL Agent SQL Server Agent Proxies Conﬁguring SQL Server Agent General Properties
Windows 2011 Clustering Installing Windows Server 2008 Failover Clustering Preparing Windows Server 2008 for Clustering xxviii 480 481 482 483 484 484 484 487 497 498 498 499 502 502 502 505 505 506 507 509 510 510 511 512 512 514 515 518 520 520 520 521 523 523 523 523 524 527 527 528 531 CONTENTS Clustering Microsoft Distributed Transaction Coordinator Clustering SQL Server 2012 Step by Step to Cluster SQL Server Installing the Service Pack and Cumulative Updates Test, Test, and
DDL_DATABASE_LEVEL_EVENTS 3. Click OK and there will be a pause. If your namespace is incorrect, or the syntax or event/ attribute names are incorrect, you get a message immediately. 4. Then, in your job, you may use the WMI(attribute) event token — in this case: Print ‘$(ESCAPE_SQUOTE(WMI(TSQLCommand)))’ 5. To get events from a database, Service Broker notiﬁcations must be turned on for that database. To turn on Service Broker notiﬁcations for NorthAmerica, use the following syntax: ALTER