Creating Comma Separated List in SQL
Often times you might need to extract data from SQL into a comma-separated listing of values. This seemingly simple task is not quite as simple as you expect.
Read Full ArticleMitch's Blog
Filter Posts By
Creating DotNetNuke SqlDataProvider Files Using SSMS
DotNetNuke requires that any SQL Script include special additional items to ensure compatibility with the underlying development.
Read Full ArticleAvoiding File Locks and Cannot Access File Exceptions
Sometimes when we try to access files we can encounter file locks, or other access exceptions that throw a wrench into the works. I came up with a simple workaround to resolve these issues.
Read Full ArticleCreating Dynamic Where Clauses with SQL
Sometimes you just don't know what you want to query until it comes time to execute the query, this post explores options for creating dynamic where clauses.
Read Full ArticleHow I Get My DotNetNuke Sites to Run So Fast
Performance is a key pet-peeve of mine, it has to be fast because it can be fast! This post shares some of my favorite DNN Performance Improvement Tips.
Read Full ArticleWhich Module Package Should You Purchase?
Purchasing solutions from third-party vendors can accelerate the development of your project, however, there are strings attached. Based on the common models available for purchase, which is best for your business?
Read Full ArticleCreating a DotNetNuke User Account From Code
Creating a user account via C# code is not exactly straight forward in DNN this post includes a helpful snippet illustrating how to complete this task.
Read Full ArticleShared, Virtual Private Server, Dedicated or Cloud Hosting
The type of hosting can have more than just a monthly financial impact on your business, it can hurt your reputation and cause other issues.
Read Full ArticleWhy Dynamically Attached Databases Cause Problems
Dynamically attached databases seem incredibly helpful at first glance, however, with anything easy there is always a gotcha, and dynamically attached databases are no different.
Read Full ArticleNotice
Content provided in this blog is provided "AS-IS" and the information should be used at your own discretion. The thoughts and opinions expressed are the personal thoughts of Mitchel Sellers and do not reflect the opinions of his employer or any other affiliated company.
This blog’s content is copyright protected. Re-publishing on other websites is allowed as long as proper credit and backlink to the article is provided. Any other re-publishing or distribution of this content is prohibited without written permission from Mitchel Sellers.