Powershell

Powershell Truncate a String

I am working on a script where I need to push some data into an oracle database. That is easy enough as I know that I can use sqlplus to execute my query into oracle but, the Oracle column that I am putting data into cannot be ny more than 10 characters. Some of the data that I want to put in is...

Query Oracle with Powershell

I have a small project that I am working on and it requires that I pull data from Oracle from within a Powershell script. This is not something that is fun but it can be done and it is not really that difficult to get the data out of Oracle, it is dealing with the data once you have the data...

PowerShell SQL Server Health Check Script – Revisited

In the past couple months I have received a few comments and questions about my SQL Server Health Check Script. So I thought it might be a good time to revisit the script and clear some things up...

Powershell Disable db File Autogrow

      0 Comments     RSS Feed     Email a friend

October 14, 2011  8:25 AM

Powershell Script to change data and log files that are growing by percent

Posted by: Colin Smith
Powershell, SMO, SQL Server

This is the next step after finding all the files that are growing by percent and not by a fixed value. Below is the modified script to make the changes that I needed.

#### Check Log and Data Growth for all User Databases. If they are not set up correctly then change...

      1 Comment     RSS Feed     Email a friend

October 12, 2011  1:56 PM

Powershell Script to check if data and log files are growing by percent

Posted by: Colin Smith
Data Files, Growth, Log Files, Powershell

In my new shop we try to grow our data and log files by a specific amount and not by a percentage. Our team lead ran into a database that had not been set up properly and wanted someone to check all our databases to verify that they have been set up correctly. Since I am the new guy and...

      0 Comments     RSS Feed     Email a friend

---

September 30, 2011  4:13 AM

Powershell to add logins to SQL Server

Posted by: Colin Smith
Groups, Logins, Powershell, SQL Server

This is a script that I threw together for an app that needed to have 60 logins created on the sql server. We had all the ad groups created using a standard naming convention.

app_dev_groupname

was the standard that we went with so here is...

      0 Comments     RSS Feed     Email a friend

---

September 27, 2011  10:00 AM

Some Powershell Help

Posted by: Colin Smith
Help, Powershell

Since I started my new job, I let the guys that I used to work with know that I would be happy to help them out if they have any questions about anything especially powershell since I took care of pretty much all of our Powershell needs. And the other day I got an email asking about how to find out...

      0 Comments     RSS Feed     Email a friend

---

September 19, 2011  10:00 AM

SQL Server Health Check Follow Up

Posted by: Colin Smith
Help, Powershell

A long while ago I wrote a script that does a SQL Server Health check and I posted it here. Recently I have gotten some comments on it and I want to help some people out. So I thought I would...

      0 Comments     RSS Feed     Email a friend

---

September 9, 2011  9:21 PM

Powershell Register Servers to CMS

Posted by: Colin Smith
CMS, Powershell, Register

I wanted to take my list of servers that I have in a database and put them in a CMS so I could have them all listed and accesibile for other DBA's to use that do not know powershell. This is a cool and powerfull thing, I just prefer powershell. Anyway I thought since I already have a listing of all...

      0 Comments     RSS Feed     Email a friend