Blog Feed Info

This page provides an aggregate of feeds from Colorado SQL community members that blog about SQL Server.  If you live in Colorado and would like your fieed listed, please send us an email at and let us know.

ColoradoSQL Bloggers

Friday, October 02, 2015 3:00:49 AM
Yesterday we looked at how you can navigate and retrieve items in the SQL Server provider using common Powershell cmdlets like Get-ChildItem and Set-Location. These are part of a set of core cmdlets that are implemented across providers to give a consistent experience to users. The remaining two cmdlets that we did not cover handle […]
Thursday, October 01, 2015 3:00:45 AM
One of the reasons to create a provider is so administrators have a common interface for using a section of the Windows ecosystem. Whether it’s the file system, the registry, or some other slice of the stack, you should be able to use a provider to browse, explore, and manipulate that part of Windows in […]
Wednesday, September 30, 2015 3:00:07 AM
So far, we’ve covered how to start up SQLPS and some of how we can navigate within the provider. These are the first few steps along the path of using SQL Server and Powershell together. Next is to understand how it works behind the scenes. SQLPS makes a lot more sense once you understand how it’s […]
Tuesday, September 29, 2015 3:00:13 AM
Next up in my series on the SQLPS module is to talk about the fundamentals of the provider. This is the core of the SQL Server module, providing an extension to the shell for managing and working with SQL Server. Providers intended togive administrators a file system-like interface for a part of the Windows ecosystem, […]
Monday, September 28, 2015 3:00:14 AM
Time for me to get off the bench and start blogging again. What better way to go than to explore the oft-maligned SQL Server Powershell module, SQLPS. Over the course of the next month-ish, I want to explore the SQLPS module, the cmdlets it provides, and the functionality within the provider. We’ll look at the […]
Wednesday, September 16, 2015 6:31:49 PM
A few years ago I volunteered to work for the PASS Performance Virtual Chapter.  It was an effort to help revive a group that was in the doldrums, and It’s also where I first got to know Ryan Adams.  Later that year I met Ryan in person at SQL Rally in Dallas where we talked about an idea he […]
Thursday, September 03, 2015 3:00:28 AM
Today I had a bit of a Twitter conversation with some SQL folks I know that were looking for Powershell help. It’s a common enough thing, of course. The trick is, we SQL people are so used to having the #sqlhelp hashtag as our first line of defense for figuring out problems that it’s weird […]
Wednesday, September 02, 2015 10:31:33 AM
Wow, is it already September? Can't believe how time is flying by! Sorry for the lack of posts, it has just been crazy busy with a new job and getting the Denver SQLSaturday setup for 9/19 (if you haven't registered, you better soon since we are up over 250 attendees now).

Enough about that stuff, I'm getting back out on the speaking circuit again after taking the summer off! I'll be presenting at the Kansas City SQLSaturday on 10/3. Currently I'm scheduled to present "Date Dimension: Past & Future in One Script" @ 9am, so first session right after the keynote! I'm really looking forward to presenting my freshly updated version of this session that I will also be presenting at PASS Summit 2015 later in October. If you are going to be in the KC area on 10/3, make sure you register for one of the best SQLSaturday's in the region. It is at a new location this year, but they are still having BBQ for lunch. Can't wait to eat as much BBQ as I can and see all of you in my session.
Tuesday, September 01, 2015 3:00:32 AM
Apologies for the unplanned blogging hiatus, but I’m back. While I’ve got a few technical post ideas bouncing around in my head, some events over the past two weeks have arisen that I want to blog on. If you’re hoping for more Powershell posts, do not despair! They will be along shortly. Recently PASS took […]
Wednesday, July 22, 2015 4:00:57 AM
Last week, as part of T-SQL Tuesday 68, I introduced you to two Powershell functions for validating and setting your SQL Server configurations. While useful, they depend on some sort of configuration source, which begs the question: How do we get this source? This post covers the third function that will help you create your […]
Page 1 of 2 1 2 > >>