The Multifunctioning DBA:

September, 2012


September 28, 2012  9:12 PM

New TV

Colin Smith Colin Smith Profile: Colin Smith

I am going to be purchasing a new TV but I just do not really know what to get. I am replacing a 65 inch Mitsubishi DLP tv and it is really a nice TV but I want to upgrade. My problem is that I want to have LED, 3D, Good contrast Ratio, Internet apps, and I would like it to be 65 inch or a bit...

September 28, 2012  5:05 PM

Poweshell and user input driven menu

Colin Smith Colin Smith Profile: Colin Smith

I needed to be able to display options to users and let them make simple choices..  to make a selection of what to do. I wrote the following in order to accommodate my needs. So I display a list of choices and the user makes a selection. After the selection is made the script calls the function...


September 27, 2012  6:18 PM

New Virtualization Bits

Colin Smith Colin Smith Profile: Colin Smith

So I got some new bits for the Virtualization beta that I have been working on and the changes that they made, are all to the CLI so no real GUI still. That would be ok but all the Powershell scripts that I had written no longer work since they interface directly with the CLI. So I had to make some...


September 26, 2012  10:35 PM

Chicago in May

Colin Smith Colin Smith Profile: Colin Smith

Like I said in my last post, I will be in Chicago in May for training. I am so excited about the training but also very excited to go to Chicago. My wife and I will be in town on a small vacation with our son, he will be about 18 months) for 5 days after the training. I am not sure what to do wile...


September 25, 2012  4:48 PM

Server 2012 Core

Colin Smith Colin Smith Profile: Colin Smith

I read an interesting post that I just thought I would have to talk about as well. So with the release of Window Server 2012 and SQL Server 2012, we can now install SQL Server on a Core version of the OS. In the article Jeremiah...


September 24, 2012  9:19 PM

2013 training… Approved

Colin Smith Colin Smith Profile: Colin Smith

Wooohooo. I am shocked but after sending my new boss the info for IE2 from sqlskills.com and the news of the super early bird discount, she had me book the class. I have booked the class in Chicago for May 6 - 10. I have booked my flights and my room. I am shocked but very excited. After attending...


September 24, 2012  3:22 PM

2013 Training

Colin Smith Colin Smith Profile: Colin Smith

After changing jobs in late 2011 I was happy to get an opportunity for training in 2012. I was however, disappointed that I did not get to attend the training that I really wanted to go to. Instead I went to the devconnections con in Las Vegas. It was a good con and I attended some great sessions....


September 24, 2012  3:14 PM

Bug more detail

Colin Smith Colin Smith Profile: Colin Smith

I wanted to shed a bit more light on the bug that I talked about it my last post. So this is something that should really never happen. When you add a data file to SQL Server, it gets a file_id and that id is stored in sys.master_files. So if you add a bunch of data files to a database, you might...


September 20, 2012  8:32 PM

Virtulization BUG

Colin Smith Colin Smith Profile: Colin Smith

So in my testing of the Database Virtulization product I ran into a most interesting bug that really caused me some pain to figure out. When I provisioned the VDB, the database showed up on the target instance but was in a restoring state. Checking the error log I found that the database was unable...


September 20, 2012  8:00 AM

Powershell and Unix

Colin Smith Colin Smith Profile: Colin Smith

I had a need to write some scripts that interface with a unix environment for some of the new Database Virtulization beta testing that I am doing. I found plink.exe. This is a great little command line ssh tool. I am able to create input files on the fly in my script and then call plink, pass it...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: