Stack Overflow
-
When you first start off trying to solve a problem, the first solutions you come up with are very complex, and most people stop there. But if you keep going, and live with the problem and peel more layers of the onion off, you can often times arrive at some very elegant and simple solutions.
– Steve Jobs, 2006They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
– Benjamin Franklin, 1775Homines, dum docent, discunt.
- SenecaTeach, Not Flame
- Kayaker Links
-
Recent Posts
Recent Comments
Archives
- January 2018
- June 2017
- September 2015
- June 2015
- October 2014
- September 2014
- August 2014
- March 2014
- June 2013
- January 2013
- October 2012
- June 2012
- May 2012
- January 2012
- December 2011
- November 2011
- September 2011
- August 2011
- June 2011
- April 2011
- December 2010
- November 2010
- August 2010
- July 2010
- June 2010
- February 2010
- October 2009
- April 2008
- October 2007
Categories
Meta
Tag Archives: sql
Restoring Sharepoint content database from backup
A small script to quickly restore a Sharepoint 2007 content database from backup: USE master GO ALTER DATABASE SITE_WSS_Content SET SINGLE_USER WITH ROLLBACK AFTER 5 GO RESTORE DATABASE SITE_WSS_Content FROM DISK = 'path_to_backup\SITE_WSS_Content_backup_201201122000.bak' WITH REPLACE GO ALTER DATABASE SITE_WSS_Content SET … Continue reading
Listing subcategories for a category in Commerce Server 2007 using a SQL query
As promised, here is the follow-up to the last post. This query gets us the names of all subcategories of a particular category in Commerce Server 2007.
Listing categories for a product in Commerce Server 2007 using a SQL query
Commerce Server API is not exactly known for being lightning-fast, so sometimes you want to skip it altogether and just use plain old SQL to get the data. This time I needed to find all categories (at a particular level) … Continue reading
Script for extracting SQL Server users, roles and role assignments
A nice little script to generate a script for extracting all users. roles and role memberships in a SQL Server database