June 20, 2012 4:18 PM
Posted by: Colin Smith
Learining,
online course,
Powershell,
TrainingThis morning I was catching up on some blog reading and I saw this great paragraph from Brent Ozar (blog | twitter) about...
April 27, 2012 4:36 PM
Posted by: Colin Smith
Comment,
Help,
PowershellJackandJill left me a comment about an issue with one of my scripts and I would like to reach out to you and let you know that I would like to help. I am not sure what the issue really is and I would like to get more information from you so I can help you get it working. My twitter is @smithco32...
April 27, 2012 3:54 PM
Posted by: Colin Smith
Jobs,
Powershell,
ReportingI told you about the SQL server jobs repository I was buyilding, and that is done. It works great and I have one report written that gives me an overview of all the jobs in my environment and what succeeded and what failed in the past 24 hours. That is very nice but because of that, I noticed a few...
April 18, 2012 6:00 PM
Posted by: Colin Smith
Powershell,
SQL Server,
Swag,
TrainingAll,
I have just been informed by my good friends at Idera that they will be providing me with two full licenses for there great
April 18, 2012 8:00 AM
Posted by: Colin Smith
Powershell,
SQL ServerI have been working on a task that will populate a database with a ton of information about jobs from all my sql servers and allow me to do reporting on it. Of course I chose powershell to write the script to go get all my data and to populate my tables. I am also using some SPROCS in order to...
April 3, 2012 3:33 PM
Posted by: Colin Smith
Idera,
PowershellI was just notified of a new Beta of Powershell Plus. I love Powershell Plus and I am excited to get this Beta and play with it. If you would like to play with it and give your feedback to Idera then follow the link and put it to the test and let them know what you think. You might win a Kindle...
January 15, 2012 8:00 AM
Posted by: Colin Smith
Powershell,
Scripting,
SMOThis is a function that I keep in my profile so I can call it in any of my scripts that will run from my profile. It makes it easier for me so it might for you.
function connect-sql ($arg)
{
if($arg -eq $null)
{
$server = Read-Host "enter instance name to connect to"
}
else
{
$server =...
January 14, 2012 8:00 AM
Posted by: Colin Smith
AD,
Groups,
Powershell,
SQL ServerThis is the script that I threw together to check and see if a user is in multiple AD Groups that are logins to the SQL Server instance. This helped me resolve an issue and it may help you look for things like explicit deny or some other reason why a user does not have the access they need or...
November 29, 2011 5:35 PM
Posted by: Colin Smith
Powershell,
SQL ServerI had a person on my team that wanted to identify tables in our enterprise that might be good candidates for compression. I thought it might help him out if I had a script that would look at every table in our enterprise that exists in a SQL Server database and give him some basic info that may...
