16Jul 2010 by Grant Fritchey 4 Comments

Steve Jones to Run for PASS Board

PASS
I couldn't hide the lead. Steve Jones (blog|twitter) has announced he's running for the PASS board. I'm excited. I'm almost as excited as if I were going to run. Steve is not simply a major influencer in what we call the SQL Community. He brings two things to the party that I think are going to make him very successful on the board. First, he gets things done. He just does. He's one of those guys that seems to keep it together, just enough, to accomplish stuff. Second, he has real ideas. He's not someone who is simply going to iron out a wrinkle or three at the Summit. He's going to propose stuff that will make a difference. Put those two things together and I think we've got reason to…
Read More
14Jul 2010 by Grant Fritchey 2 Comments

In the Clouds

Misc
The July meeting for the Southern New England SQL Server Users Group is tonight. Andrew Novick will be talking about SQL Azure. It'll be a great meeting. Our sponsor is Red Gate. They bought pizza.
Read More
13Jul 2010 by Grant Fritchey 10 Comments

Red Gate SQL Source Control

SQL Server, T-SQL, Tools
You just have to love Red Gate tools. They find the small area that they want to cover and then they cover it extremely well. I rave regularly about SQL Prompt and SQL Compare and SQL Search (free one, btw). I've got SQL Data Compare and SQL Data Generator open & working on my desk regularly. I'm dabbling in their other tools fairly often as well. I just like Red Gate tools. I guess my constant & consistent praise is why I'm a "Friend of Red Gate." I like to mention that before I start praising their tools some more, just so no one thinks I'm hiding it. Why would I hide it? I'm proud to say it. I am a Friend of Red Gate! ... anyway... where was I... right, new software.…
Read More
09Jul 2010 by Grant Fritchey 7 Comments

Delivering the Bad News

Misc
It's a Friday, the day governments & companies traditionally deliver bad news. I recived the bad news earlier in the week, but I'm passing it on now: The Standard is dead. Let me first say, a couple of authors are right in the middle of finishing up articles. Those will be completed and published and you'll get paid. Andy sums up some of the reasons why the Standard failed very nicely in his blog post. I agree with them, if not where the responsibility lies. Andy takes most of it on himself because, well, he's that kind of guy, may the gods bless him. But, the fact is, I took on the job and just wasn't prepared for what it would entail. The "editing" part of the job was hard.…
Read More
06Jul 2010 by Grant Fritchey 1 Comment

Small PowerShell Script

PowerShell
I'm still trying to learn PowerShell better. The opportunity to answer simple questions and problems with the tool is hard to pass up. We had a need to clean up data directories where data files were left behind or people put inappropiate files, so I wrote the following Powershell script: [sourcecode language="powershell"]param([string]$filelocation="",[string]$sqlinstance="(local)") Set-Location $filelocation foreach($file in get-childitem) {$base = $file.Name; $result = Invoke-Sqlcmd -ServerInstance $sqlinstance -Query "SELECT DB_NAME(mf.database_id) AS db FROM sys.master_files mf WHERE RIGHT(mf.physical_name,LEN('$Base')) = '$Base' UNION ALL SELECT 'NoDb' AS db WHERE NOT EXISTS (SELECT DB_NAME(mf.database_id) AS db FROM sys.master_files mf WHERE RIGHT(mf.physical_name,LEN('$Base')) = '$Base');" ; if($result.DB -eq "NoDb" -and $file.Extension -ne ".cer"){Remove-Item $base}} It's a very simple script. It takes a UNC and a server instance and then walks through the files in the UNC and validates…
Read More
30Jun 2010 by Grant Fritchey 6 Comments

One of these things is not like the other

PowerShell
I'm working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later, if I get it to work) and I wanted to try out different scripting tools to build it. I started with PrimalScript from Sapien. It's slick. It's powerful. It has very nice code completion, a great GUI, integration with source control out of the box. I started scripting and everything was fine. Then, I needed to run invoke-Sqlcmd so I decided to change the profile on the shell so it would load the SQL Server cmdlets automagically. I started getting the error: Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps' because it does not exist Hmmm... weird. I'm pretty sure I used the same command on my workstation as on my laptop.…
Read More
25Jun 2010 by Grant Fritchey 6 Comments

Powershell Fundamentals

PowerShell
I've had the opportunity this week to take class with Don Jones (blog | twitter), PowerShell guru and author of PowerShell 2.0 TFM (makes me laugh, each and every time). I'm not even going to attempt to try to teach you some of the amazing information Don has spent the last week pouring into my ears (since most of  it spilled on the floor). But, I do want to pass on some high points, gotchas, tips, insights, that Don communicated to us during the class because they might help you pick up on the fundamentals of PowerShell. That's the most important lesson I got out of this week, you need the fundamentals to really start to put PowerShell to work. It's very easy to make the mistake that I did. I…
Read More
25Jun 2010 by Grant Fritchey No Comments

PASS Board Nominations

PASS
If you haven't heard, please allow me to let you in on a little secret. The Professional Association of SQL Server users (PASS) is holding open nominations for the board. If you are interested in running for the board or know someone who should run for the board, get to this location as soon as possible and get their name in. I feel that PASS does a lot for individual database users all over the world. I know people who take the contrary position and say that PASS doesn't do anything for them. If you're of that opinion, that's great. As a matter of fact, if you're of that opinion, I'd suggest you should run for the board. Now is your chance to make a difference. Now is the time…
Read More
23Jun 2010 by Grant Fritchey 4 Comments

Learning Powershell

PowerShell
I've been attending a Powershell fundamentals class with Don Jones (blog|twitter). If you read my blog you might be aware of the fact that I've posted a few PowerShell scripts in the past.  So why was I attending a fundamentals class? Because I didn't know what I was doing. I knew going into the class that I needed a better grounding in the fundamentals of Posh, but after the first day of Don's excellent class, I realized that I had been working with PowerShell and didn't have a clue how it really worked. Don's class is excellent and I could spend a lot of time talking about just that (which I'm sure would make Don happy). However I want to concentrate on something that he said during class that really…
Read More