Shawn Melton

Leaning all things SQL Server and PowerShell

Category Archives: General

Mentoree

Fair warning that some religous terminology may be mentioned in this blog post, continue reading at your own risk. I recently took part in the first round of the Mentoring Experiment. This is a program that Steve Jones (t|b) and Andy Warren (t|b) started (they seem to do that alot). I acted as the mentoree [...]

Adjusting and learning

Short and sweet post here…not the sugar sweet, the awesome sweet!!! So I’m still working on the script I talked about in a previous post. I wanted to try to drop using the parameter and try to work it all out in the script if it comes across more than one instance. So I came [...]

What a few lines of code can do

You find out PowerShell is fun when you start playing with it and actually try to perform a task with it. I have been using it the past few months to try and decrease the time it takes me to perform a scan of a SQL Server. What I mean by scan is I work [...]

Look what I did with PowerShell

I was pretty excited that work was finally going to install Remote Desktop Connection Manager v2.2 on our laptops, until I started using it. It is nice if you work on one server at a time but sometimes I multitask while something is running, or I need to compare something to the results on another [...]

The rest of the story (PowerShell errors)

So I got a new server given to me to check over. Unlike most folks I like to open up PowerShell to get quick fix on the configuration. I seem to have gotten used to using PowerShell enough now that it takes me about as much time to do it PowerShell as it would in [...]

What OS permissions does SQL Server have?

If you set the service account for the SQL Server services up at installation you are ahead of the game when dealing with securing your SQL Server installation. However there are some environments where the DBA does not do the initial installation of SQL Server. That requires the DBA to go back and configure a custom account [...]

Get those ACLs with PowerShell

If I want to view the access permissions to a particular directory in Windows I can always go to the folder itself and check the security properties on the folder: But that is boring, lets use PowerShell!!! The cmdlet (commandlet) of choice for this is going to be: Get-Acl I will let you dive into this [...]

Books I get to read. (E-Books)

I thought I would share some of the E-books I have purchased recently. I did not like them to begin with but have an iPod Touch now and it is not too bad reading on it. It just depends on what format it is in. I found a free app to read PDF files and [...]

Training for the Master from the Masters

(Bottom left corner of this photo you’ll see the nose of the sniper) A talent and a gift, what is the difference? I follow the definition that a talent is something you learn and a gift is something you were born with. I believe one of my gifts is helping people, or sometimes called the [...]

Reading

If you follow alot of blogs Google Reader is an excellent source to keep up with it all, even if you don’t use it for Gmail.  One of the things I do ever so often is see how much I read of the blogs I follow.  Which I just noticed a link in Reader that [...]

Follow

Get every new post delivered to your Inbox.

Join 137 other followers