Allan Mitchell, Mark Allison

Real-World SQL-DMO for SQL Server (eBook, PDF)

• Format: PDF

Produktbeschreibung

Using clear language the authors hope to take developers to another level in administering their SQL Server. In this text Allan Mitchell and Mark Allison show developers how to create tools which will let them do their jobs easier and faster. SQL-DMO is a feature rich library that can be manipulated to do things that simply are not possible using the standard tool set of Microsoft SQL Server. Here, Mitchell and Allison show developers how to do it in a way that is not masked by "techno-babble". Instead, they write in a manner that is easy to understand and clearly explains the points necessary to advance in programming SQL Server.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Apress
• Seitenzahl: 432
• Erscheinungstermin: 9. November 2013
• Englisch
• ISBN-13: 9781430211082
• Artikelnr.: 44000574

Autorenporträt

Allan Mitchell works as a lead data architect for a multinational media company in the United Kingdom. He provides developer and user support for all the company's SQL Servers, and he designs data solutions as well. He is an MCSE and an MCDBA, and in 2002 he was awarded the title of "Most Valuable Professional" by Microsoft. His interests include mountain biking and rugby. You can find Allan on the Microsoft public newsgroups and on the SSWUG list answering questions on a variety of topics. Allan is cofounder of Allison Mitchell Database Consultants Ltd., a successful database-consulting firm based in southeast England.

Inhaltsangabe

1 Getting Started with SQL-DMO.- 2 Backup and Restore: A DBA's Bread and Butter.- 3 Managing Users of Your Database and Server.- 4 Using SQL-DMO with OLE Automation.- 5 Jobs, Alerts, and Operators.- 6 Viewing and Setting Server-wide Options.- 7 Replication and SQL-DMO.- 8 QALite.- 9 Using SQL-DMO to Script an Entire Server.- Appendix A SQL-DMO Object Library Quick Reference.- SQLServers Collection.- Databases Collection.- DatabaseRoles Collection.- FileGroups Collection.- DBFiles Collection.- FullTextCatalogs Collection.- StoredProcedures Collection.- Tables Collection.- Columns Collection.- Users Collection.- Views Collection.- Triggers Collection.- Jobs Collection.- JobSchedules Collection.- JobSteps Collection.- Operators Collection.- Logins Collection.- Replication Object.- The SQL-DMO Object Model.- Appendix B Knowledge-Base Articles and Other SQL-DMO Resources.- Bugs.- Fixes.- Problems.- Information and How-To's.- Useful URLs.