September 24, 2012 3:22 PM
Posted by: Colin Smith
DatabaseAfter 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
Posted by: Colin Smith
DatabaseI 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
Posted by: Colin Smith
DatabaseSo 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
Posted by: Colin Smith
DatabaseI 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...
September 19, 2012 9:30 PM
Posted by: Colin Smith
DatabaseToday is my one year anniversary working for my new company. When I made the decision to change jobs I was a bit nervous. The new place really sounded too good to be true and I am not a grass is greener type of a guy. I am very loyal as well, and my old company, while on the decline, actually...
September 19, 2012 9:24 PM
Posted by: Colin Smith
DatabaseThe Problem.
I have a need to have a linked server that can connect to multiple catalogs, but I need a proc to determine what catalog to connect to. So I need to be able to do something like this.
set @SQL = 'select * from linkname.' + @RemoteDBName + '.dbo.table'
exec (@SQL)
I do not...
Comments are off for this post.
August 31, 2012 7:00 AM
Posted by: Colin Smith
DatabaseIf you are like me you are getting away for the long weekend. I am heading out to San Diego to take Mason to the Beach for the first time. I hope that all of you will be having a good time as well. Get away from work and just have a good time. Drink some beer, have a good time with your family and...
August 30, 2012 7:30 AM
Posted by: Colin Smith
DatabaseThis one is really for application support teams. All I ask is that you understand how your app works before you blame the database. For instance, if a user is unable to save a project to a database in your application, you should know and understand the workflow and the security model that is in...
August 30, 2012 2:23 AM
Posted by: Colin Smith
Database8 months ago I had my first child and I thought I would introduce him. His name is Mason and he is my future DBA. He loves to bang on the keyboard when I sit at the computer and I am holding him so I just know that he will be a natural. He hears me talking about work all the time so I am sure he is...
