Visit site BPsoftware.com Blog
November 2008
0
votes
Vote
SQL: Remove / Delete Orphan Users
BPsoftware.com Blog
– As discussed in the post SQL Delete/Drop a User from each Database, when you delete a Login from SQL Server it does not remove them from the databases they have explicit permissions on. If a user login is removed, and they are not removed from the database you would have orphan users with permission ...
0
votes
Vote
SQL Delete/Drop a User from each Database
BPsoftware.com Blog
– Deleting a user from SQL server deletes them from the security system, however it does not remove them from databases they have 'securables' (permissions speficified) for. The following procedure will remove a user from each database and remove their account. 1 USE [master]2 GO3 SET ANSI_NULLS ON4 ...
0
votes
Vote
Is there an 'I' in phone?
BPsoftware.com Blog
– I spend a lot of time reading various news articles to keep up with what is going on in the world of technology. I can't remember the last day that had passed without me reading something about the IPhone. Ironically, a few months ago I was due for a phone and ended up with grabbing an IPhone. ...
0
votes
Vote
SQL Optimization: Am I missing any indexes? - Part I
BPsoftware.com Blog
– Lately, I have been doing a lot with SQL (2005) optimization. Database design plays an important role in the efficiency of a database. A key part of the design is the use of indexes. Indexes significantly affect the performance of a database whether it is during a SELECT, INSERT, UPDATE and ...
0
votes
Vote
Meaningful Signature File Quotes
BPsoftware.com Blog
– There are many entertaining and powerful quotes in circulation. I often find in correspondence that individuals include such quotes as part of their signature file (some applications allow for the rotation of quotes). Here is a list of a few of my favorite quotes, along with the name of who is ...
July 2008
0
votes
Vote
My Shared RSS Items
BPsoftware.com Blog
– I have long been a fan and user of RSS feeds. I have been using Google™ Reader for quite some time. Besides allowing web and mobile access to your feeds, Google™ Reader also allows you to share feed items that you find interesting. Here is a live list of the RSS feed items that I have marked as ...
0
votes
Vote
Edit those XML files
BPsoftware.com Blog
– Wow! It has been a while since my last post. It doesn’t feel like it has been that long. Things have been both hectic and busy (to say the least). I am going to try and make it a point to post more often (again). Over the past few months I have had the need to maintain a number of different XML ...
November 2007
0
votes
Vote
A little System.Diagnostics
BPsoftware.com Blog
– I am not going to get overly verbose here; however the importance of application logging is immeasurable. When applications are deployed, obtaining ‘real life’ application can assist in diagnostic and overall application health situations. Excessive logging can be ineffective (too much to analyze) ...
October 2007
0
votes
Vote
Wi-Fi Detector Shirt
BPsoftware.com Blog
– I have long been an advocate of sites such as ThinkGeek.com. As I had mentioned before, I have purchased a number of items from the site. I think the apparel is hilarious. As I was browsing through the latest duds I came across the Wi-Fi Detector Shirt. The Wi-Fi Detector Shirt is a neat way to ...
0
votes
Vote
Control and List Windows Services
BPsoftware.com Blog
– As I whipped up my file synchronizing service application, to synchronize files between my computer and my NAS), I worked with the System.ServiceProcess Namespace. The System.ServiceProcess Namespace "provides classes that allow you to implement, install, and control Windows service applications". ...
September 2007
0
votes
Vote
Let's Synchronize Some Files
BPsoftware.com Blog
– Recently, I posted about the new addition to my backup strategy; a NAS. My intended use of this device is to have a hot backup of my files. The system I was using before was not capable of storing the amount of data I need backed up, nor was it easy to manage. I modified the set of xCopy batch ...
0
votes
Vote
Compact that Virtual PC
BPsoftware.com Blog
– I have long been a fan of Virtualization. Ever since the early days of Virtual PC, I have been spinning off virtual machines to test and install software applications and code. It has even gotten to the point where I do very little on my host machine. I even do most of my web browsing within a ...
0
votes
Vote
Is it Hammer Time?
BPsoftware.com Blog
– Stop! It almost was hammer time, sledge hammer time, for my new Hammer Storage MyShare™. With all of the data that I have on my machines, the conventional back-up strategy I had didn't really cut it. I decided that I needed to find a solution that had reliability, accessibility, convenience and ...
1
vote
Vote
DSOFile and Summary Properties
BPsoftware.com Blog
– Yesterday I posted about using ShellExecuteEx to display the document properties dialog for a file or folder. Displaying the properties dialog is nice, however I also need to access the OLE document properties (Document Summary Properties), the information that is stored on the Summary and Custom ...
0
votes
Vote
ShellExecuteEX and ShellExecuteInfo Revisited
BPsoftware.com Blog
– Who says history doesn't repeat itself? I am working on a project that needs to display and access file properties. A quick search through the .NET 2.0 Framework didn't yield anything that popped out. I did however, remember our wonderful friend - the SHELL32 API. Previously, I had posted on using ...
