SQL 2012 Management Studio hangs clicking Files menu during database restore

I’ve had this nagging issue for months now.   Every time I go to restore a database from a backup file, I cannot click the Files menu in the left sidebar.   This didn’t happen in SQL Server Management Studio 2008.    But it happens every time in SQL Server Management Studio 2012. I enjoy using SSMS, it works well for my needs.  So it got very frustrating that it would lock up when I needed it most. I finally took the time to research and thought maybe a newer version had been released since I downloaded it.  ...

Jul 25, 2014 READ MORE
AbleCommerce Gold How To Clean Up Anonymous Users

Even though Able Gold has a manual cleanup option in the Maintenance page, it doesn’t always work well.  The problem arises from how Able must delete each user individually.  Not such a big deal when you have 500 users to clear out.   It’s a very different story when you have 2,000,000 unwanted users.   A SQL query can delete all of the unwanted records in a single command. Below is the updated query to work with Able Gold schema.  Obviously change the dates to something more recent.  If the queries do not remove ...

Apr 14, 2014 READ MORE
SQL Studio Management Expand Databases Slow

So on my development PC, I’ve noticed that it takes 2-3 minutes for the Databases node to expand in my SQL Server Studio Management 11.0.2100.60 I don’t remember exactly when it started.   But it’s been several months I think.  It was just too easy to ignore since I could alt-tab and do something else while it worked through the delay. Today I decided to research it and determined it’s because some databases have auto_close turned on.   This causes the SQL server to have to start up the database before it can render it in the Databases node...

Apr 14, 2014 READ MORE
NHibernate sub query on Orders filtering by usergroup

A client had a need to filter the Monthly Sales Summary report by group membership.  In other words, restrict the totals to orders placed by users only in a specific user group. The initial NHibernate query is such: ICriteria criteria = NHibernateHelper.CreateCriteria<CommerceBuilder.Orders.Order>("O") .CreateCriteria("Items", "OI", NHibernate.SqlCommand.JoinType.InnerJoin) .Add(Restrictions.Eq("O.Store", AbleContext.Current.Store));   So I added a dropdown t...

Mar 17, 2014 READ MORE
Server 2012 how to set folder permissions ASP.Net application pool

Microsoft tries so hard to make things simple, yet often winds up making them harder.  I needed to set folder permissions with an ASP.Net 4.0 website running on Server 2012.   The problem was the site worked, but certain folders needed Modify rights. To make this happen properly, you have to: 1.  Locate the name of the application pool assigned to your asp.net website.  In my case, we’ll call it BlahAppPool.  You can find which app pool is assigned by using IIS Manager and going to the Basic Settings of the website in question. 2.&...

Mar 05, 2014 READ MORE
AbleCommerce Gold Upgrade errors from 7.0.7

Ran into an odd timeout issue today.  It was disguising itself as an nHibernate problem during the upgrade of an AbleCommerce 7.0.7 store to AbleCommerce Gold R6.   The initial error was complaining about nHibernate null Id issues with Catalog.Webpage.  Which made no sense since the upgrade is converting the data, not adding to it. So I dug into the /install/upgrade.aspx page and saw that indeed new web pages were being added.  And the error was crashing when store.settings.Save() was being called. I eventually noticed an “errorList” string array var...

Feb 14, 2014 READ MORE
ABF shipping gateway base written and working

Spent some time this morning and put together the complete shell for an ABF shipping gateway in AbleCommerce Gold.    It’s only purpose is to provide tracking URL support for ABF shipments when marking orders as shipped. It was interesting how Able has implemented a default provider interface, leveraged embedded resources and connected it all to specific configure and register pages in the admin.  I’ve worked on various shipping gateway pieces several times, but never a brand new AbleCommerce Gold gateway implementation.   Kinda slick h...

Feb 02, 2014 READ MORE
Problem with Jr. Admin security permissions in upgraded AbleCommerce 7 sites

As of Gold R6… After upgrading an AbleCommerce 7.x website to AbleCommerce Gold, you’ll find the Junior Admin permissions do not work as expected. In the Old Able 7.x, the role name was “Jr. Admin”.   However in Able Gold, the role name was changed to “Junior Admin”.  This value is hard-coded in various web.config files as well as the /app_data/adminmenu.xml file. If you upgrade Able 7.x to AbleCommerce Gold, the value does not get updated.  As a result, the new Able Gold install cannot accurately identify a user as an admin user if they are a ...

Jan 28, 2014 READ MORE
How to remove full text catalog index from SQL 2005 database

When moving an older AbleCommerce 7 database from SQL 2005 to a newer SQL server, you might run into errors with the ac_searchcatalog full text index catalog file.   SQL 2008 doesn’t store FTS the same way it was done in SQL 2005. The issue usually appears when you try to restore the database backup from 2005 to 2008 or greater. To fix it, you have to remove the FTS file associated with the database.   But it’s not part of the SQL backup, so you have a problem if you didn’t copy the index file separately.   Here’s how to get rid of...

Jan 23, 2014 READ MORE