List/Grid Tag Archives: SQL

Configuring Azure environment to set up Azure SQL Database Managed Instance (preview)

Configuring Azure environment to set up Azure SQL Database Managed Instance (preview)

Azure SQL Database Managed Instance (preview) is a new database service in Azure. This is a fully-managed latest version of SQL Server database engine hosted in Azure and managed by… Read more »

Natively Query CSV Files using SQL Syntax in PowerShell

Natively Query CSV Files using SQL Syntax in PowerShell

Note: The previous version of this article relied on the 32-bit JET engine. It has been updated to use ACE, which works in both 64-bit and 32-bit environments. Using Microsoft’s… Read more »

#PSTip Functions and SQL filtering, Part 4

#PSTip Functions and SQL filtering, Part 4

Note: This tip requires PowerShell 3.0 or later. Filtering information retrieved from SQL database should not be limited to text filters only. Sometimes we may want to use dates to… Read more »

#PSTip Functions and SQL filtering, Part 3

#PSTip Functions and SQL filtering, Part 3

Note: This tip requires PowerShell 3.0 or later. Whenever we retrieve information from SQL database we are faced with the problem: are we happy with column names defined in database… Read more »

#PSTip Functions and SQL filtering, Part 2

#PSTip Functions and SQL filtering, Part 2

Note: This tip requires PowerShell 3.0 or later. Adding support for easy filtering on individual table columns is great, but the fact that user would have to use SQL wildcard… Read more »

#PSTip Functions and SQL filtering, Part 1

#PSTip Functions and SQL filtering, Part 1

Note: This tip requires PowerShell 2.0 or later. This is the first tip in a series of SQL filtering tips. I find myself using SQL as a source of the… Read more »

© 2018 PowerShell Magazine. All rights reserved. XHTML / CSS Valid.
Proudly designed by Theme Junkie.