List/Grid Tag Archives: SQL

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 »

Using PowerShell to discover information about your Microsoft SQL Servers

Using PowerShell to discover information about your Microsoft SQL Servers

I’m an infrastructure guy who supports many different products at multiple datacenters in an enterprise environment. One of those products is Microsoft SQL Server which I’ve been supporting since version… Read more »

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