Books
Translate This Blog
-
Recent Posts
Top Posts
- Querying UDP Ports with PowerShell
- Changing Ownership of File or Folder Using PowerShell
- Starting,Stopping and Restarting Remote Services with PowerShell
- Avoiding System.Object[] (or Similar Output) when using Export-Csv
- Quick Hits: Finding Exception Types with PowerShell
- Locating Mount Points Using PowerShell
- Using PowerShell Parameter Validation to Make Your Day Easier
- Building a Chart Using PowerShell and Chart Controls
- PowerShell and Excel: Adding Some Formatting To Your Report
- Quick Hits: List All Available WMI Namespaces Using PowerShell
Archives
Categories
- .net
- api
- array
- background jobs
- binary
- book
- c#
- clock
- codeplex
- com object
- convert
- CTP
- database
- deep dive
- excel
- Favorites
- function
- groups
- guest blog
- hash table
- Internet Explorer
- ise
- mcpmag
- module
- MVP
- network
- news
- parameter
- patches
- performance
- pinvoke
- podcast
- port
- PoshChat
- poshpaig
- PoshRSJob
- poshwsus
- powercli
- powerscripting
- Powershell
- printers
- quickhits
- reflection
- regex
- registry
- Regular Expressions
- report
- resolution
- runspace
- runspaces
- scripting games 2012
- scripting games 2013
- scripting guy
- scripts
- SMO
- Speaker
- speaking
- SQL
- tcp
- tips
- tsql
- updates
- user group
- V3
- V4
- v5
- weather
- widget
- win32API
- winter scriting games 2014
- wmi
- word
- WPF
- wsus
- xaml
Tag Archives: SQL
PowerShell Server Inventory, Part 2: Collecting and Sending Data
This will be at least a 3 part series in which I will go over each aspect of my build which will cover the following topics: Staging the SQL database and tables (Part 1) Collecting server data and pushing to … Continue reading
PowerShell Server Inventory, Part 1: SQL Database Build
If you’re like me, you might not have SCOM or SCCM or some other 3rd party solution that you can leverage to track all of your systems in your environment that you can pull up at a glance to know … Continue reading
Updated Function: Get-SQLInstance
One function of mine that I use quite a bit to get information about SQL servers is Get-SQLInstance not only because it provides most of the information that I am looking for but it also is a great way to … Continue reading
Slides and Example Code From Nebraska.Code() Conference Session Available
I had the great opportunity to speak at Nebraska.Code() over the weekend in which I talked about Trend Reporting using PowerShell and SQL. This was a great opportunity and my 1st conference speaking gig that I have done. I appreciate … Continue reading
Trend Reporting using PowerShell and SQL on MCPMag.com
I have a new series of articles that will be focusing on trend reporting using PowerShell and SQL. Be sure to check them out and let me know what you think! PowerShell Trend Reporting, Part 1: Data Gathering PowerShell Trend … Continue reading