Chapter 9. SQL Server Development
In this chapter, we will cover the following topics:
- Importing data from a text file
- Exporting records to a text file
- Adding files to FileTable
- Inserting XML into SQL Server
- Extracting XML from SQL Server
- Creating an RSS feed from the SQL Server content
- Applying XSL to an RSS feed
- Creating a JSON file from SQL Server
- Storing binary data into SQL Server
- Extracting binary data from SQL Server
- Creating a new assembly
- Listing user-defined assemblies
- Extracting user-defined assemblies
Introduction
SQL Server has seen immense enhancements and support to different components that were traditionally not supported natively in databases, such as XML and Common Language Runtime (CLR) assemblies. This chapter explores how you can use PowerShell ...
Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
