If you are starting to learn SQL Server administration, or just need to rehash on your backup and restore fundamentals, here’s a great ebook to read:
Ebook
Free PowerShell Ebook (Mastering PowerShell) from PowerShell.com
If you have the slightest interest in PowerShell, and you’re keen on learning more about it, I strongly recommend you download this book:
Mastering PowerShell (from PowerShell.com and written by Dr. Tobias Weltner)
It is an awesome, well written 567 page book that covers PowerShell through and through. Here are the chapters:
- The PowerShell Console
- Interactive PowerShell
- Variables
- Arrays and Hashtables
- The PowerShell Pipeline
- Using Objects
- Conditions
- Loops
- Functions
- Scripts
- Finding and Avoiding Errors
- Command Discovery and Scriptblocks
- Text and Regular Expressions
- XML
- The File System
- The Registry
- Processes, Services, Event Logs
- Windows Management Instrumentation
- User Management
- Your Own Cmdlets and Extensions
Thanks PowerShell.com!
Have You Downloaded the Free MS Press SQL Server 2008 Ebook Yet?
… written by one of our cool DevTeach speakers Peter de Betta?
Yup, it’s a free MS Press Ebook on SQL Server 2008. What else can we SQL Server junkies ask for? (Ok, fine I said that too soon, there’s probably still a fair bit of stuff we want out of SQL Server).
Anyway, this is the link to Peter‘s blog about the book :
http://sqlblog.com/blogs/peter_debetta/archive/2008/09/16/introducing-sql-server-2008-the-book.aspx
This is the excerpt:
To get your free copy, browse to http://www.microsoft.com/learning/sql/2008/default.mspx. From there, look in the Special Offers section for the “Free e-book offer“. Although the site states you can get excerpts, the whole book is available for reading.
Coolio?
SQL Server XML Red Gate Ebook, XQuery Labs
Jacob Sebastian is a SQL Server XML Guru!
Check out his collection for XQUery Labs. This is the first 12 of his series, and right now he has 43 and counting:
XQuery Sample Scripts
* XQuery Lab 1 – Transforming rows to columns
* XQuery Lab 2 – An example using OUTER APPLY
* XQuery Lab 3 – Filtering specific nodes
* XQuery Lab 4 – Joining XML Nodes with a Relational Table
* XQuery Lab 5 – Working with Namespaces
* XQuery Lab 6 – Processing Header-Detail information
* XQuery Lab 7 – Extracting a comma separated list of values
* XQuery Lab 8 – How to update the attribute value of an XML variable?
* XQuery Lab 9 – How to delete an attribute from an XML variable?
* XQuery Lab 10 – How to insert an attribute to an XML variable
* XQuery Lab 11 – How to insert an element to an XML variable
* XQuery Lab 12 – Different ways of reading values from an XML variable
Jacob Sebastian has also released a free ebook via RedGate – The Art of XSD – SQL Server XML Schema Collections
Check it out, all 483 pages! 🙂
Free SQL Server Ebooks/Resources
Free ebooks 🙂 Grab them while they’re free. (BTW, I purchased Grant Fritchey’s ebook, now RedGate is offering it for free)
SQL Server 2008 MS Press Free Ebook
http://csna01.libredigital.com/?urss1q2we6
How to Become an Exceptional DBA
http://www.red-gate.com/products/sql_backup/offers/brad_exceptional_dba_ebook.htm
Best of SQL Server Central
https://www.red-gate.com/Dynamic/Downloads/DownloadForm.aspx?download=ebook1
Brad’s Sure Guide to SQL Server 2008
http://www.red-gate.com/specials/ToolbeltBradsure.htm?utm_source=ssc&utm_medium=email&utm_content=Bradsure-080925&utm_campaign=sqltoolbelt
Brad’s Sure DBA Checklist
http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/
RedGate’s SQL Server DBA Best Practices
http://www.simple-talk.com/content/file.ashx?file=1208
Dissecting SQL Server Execution Plans
http://www.red-gate.com/specials/Grant.htm