10/27/2008 06:53:00 AM by Geppy
Well, the next thing that I ran into in my SQL Server management project was adding to my ClickOnce deployment the MSI files for the SQL Server Native Client and the SMO files. Internet searching did actually bring up a lot of information, but in general people were hesitant to provide details. So I thought I would post some details for future searches.
First, grab the Bootstrap Manifest Generator - which the only link I could find at this time was: http://www.davidguyer.us/bmg/publish.htm. (Note: the tool is not perfect, but it is better than nothing and will help you get to the end result.)
Second, play around a fair amount with BMG to determine what is needed. What I found was:
- the MSI file (for me, the Native Client and SMO from Microsoft)
- the eula files (grabbed from within the installers)
- adding an MSI check of ignore if >= 3
Anyway, I'm still playing with the details of the solution but wanted to take the time to post the information that I have gathered before it is forgotten as irrelevant. Also, below are the sample project files for the three MSIs that I needed to have added to VS2005 prereq list. (Each Zip is the entire package with absolute path - missing the actual MSI files that you need to get from Microsoft.)
SQL Native ClientSQL SMOMSXML v6Update: 10/27 12:36 PM
I just found this blog entry that was also fairly detailed on this topic.
http://www.vfpconversion.com/Article.aspx?quickid=0703072
10/23/2008 01:05:00 PM by Geppy
So, I've been having a hard time determining what to post and finding the time to post. So I'm just going to jump in finally. I am in the process of writing a utility to provide standardized SQL Server configuration, management, and monitoring. I also chose this time to switch from Visual Basic .Net to C#. So far, not too horrible of a switch - but there have been some gotchas.
The issue that I tracked down this week that the web has been surprisingly unhelpful on is a ContextMenuStrip and its popup location. So, my first premise is to try to do as much as possible using the VS IDE. Keep code to only what I have to code. Well, I have ContextMenuStrip controls which are then linked to as the DropDown for my MenuBar items. This has resulted in the first time you right-click on a DataGridView having the context menu popup at the menu bar. Yuck.
So after much (fruitless) searching and trial and error I have the solution. In the Constructor I have added a line to remove the OwnerItem and all works well. Ex,
this.contextMenu_MyPopup.OwnerItem = null;
You can remove this from the Designer, but as you work with the GUI it always comes back. Only by adding this line for each of my ContextMenuStrip controls was I able to permanently rid myself of this undesired behavior.
Anyway, hopefully this will help someone from needing to perform the trial and error approach.
5/21/2008 07:51:00 PM by Geppy
So, my current job position is Database Administrator. I have been working in this position for 5 years as a new Oracle DBA and as an experienced SQL Server DBA. The comparisons between the databases have been interesting to me, and the differences sometimes even more so.
I am hoping to start posting my thoughts and findings on each database here so that others will have a task oriented place to look up administrative resources. (Additionally, I will have a place to come back to as well for information.)
Note: If you are interested in my thoughts on religion, that is my original blog and may be located by clicking "Religion" at the top right of this page.
