SQL

Natively Query CSV Files using SQL Syntax in PowerShell

Chrissy LeMaire
7 Min To Read
12 May, 2015
- How to
- SQL

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.

#PSTip Functions and SQL filtering, Part 4

Bartek Bielawski
3 Min To Read
31 Jul, 2014
- Tips and tricks
- SQL

Note: This tip requires PowerShell 3.0 or later. Filtering information retrieved from SQL database should not be limited to text filters only.

#PSTip Functions and SQL filtering, Part 3

Bartek Bielawski
3 Min To Read
30 Jul, 2014
- Tips and tricks
- SQL

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 schema?

#PSTip Functions and SQL filtering, Part 2

Bartek Bielawski
2 Min To Read
29 Jul, 2014
- Tips and tricks
- SQL

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 syntax rather than wildcards that he is used to, makes it feel like a …

#PSTip Functions and SQL filtering, Part 1

Bartek Bielawski
3 Min To Read
28 Jul, 2014
- SQL
- Tips and tricks

Note: This tip requires PowerShell 2.0 or later. This is the first tip in a series of SQL filtering tips.

Using PowerShell to discover information about your Microsoft SQL Servers

Mike Robbins
8 Min To Read
21 Jul, 2014
- How to
- SQL

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 6.

Showing items from SQL