O'Reilly logo

Expert Scripting and Automation for SQL Server DBAs by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Peter A. Carter 2016

Peter A. Carter, Expert Scripting and Automation for SQL Server DBAs, 10.1007/978-1-4842-1943-0_1

1. T-SQL Techniques for DBAs

Peter A. Carter

(1)Botley, UK

Electronic supplementary material

The online version of this chapter (doi:10.​1007/​978-1-4842-1943-0_​1) contains supplementary material, which is available to authorized users.

As a DBA, you will almost certainly understand the basics of the T-SQL language and use it for querying metadata views, such as sys.databases or sys.tables. Often, DBAs do not have advanced T-SQL skills, however, as they do not need them in day-to-day operations. In order to implement sophisticated automation and, in turn, reduce operational costs and overheads, DBAs should gain an understanding ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required