SQL Server RANK, ROW_NUMBER, and Partition
Rank, ROW_NUMBER, and Partition are incredibly powerful SQL statements but often misunderstood. This post outlines example usages to illustrate their effectiveness.
Read Full ArticleMitch's Blog
Filter Posts By
Backing Up A DNN Site
Taking proper backups of your DNN based website is critical as if you miss anything you can be left without a working backup.
Read Full ArticleCreating Random SQL Server Test Data
To fully test your database-driven applications you need test data, it can be tedious to populate, so let us explore a few quick ways to add data.
Read Full ArticleExposing a Development Installation of DotNetNuke
You have a great website in development, how do you let others see it using the DotNetNuke platform?
Read Full ArticleUsing the IN Clause With Stored Procedures
The IN clause is a helpful SQL query item, however, using it inside of stored procedures can be complicated
Read Full ArticleSQL Server Table Size Calculation
Revisiting the concept of SQL Table Size Calculation using new SQL features
Read Full ArticleSelecting a DotNetNuke Hosting Provider Revisisted
A few months ago I wrote an article discussing the selection of a DNN Hosting provider, after much feedback, I revisit this topic.
Read Full ArticleExporting a DataGrid to Excel The Easy Way
There are many ways to create an Excel export from a DataGrid, this is a very simple method to create an excel file without any third-party libraries.
Read Full ArticleModules, Compatibility, and Developer Responsibility
As developers in a larger ecosystem, we are responsible for doing the ethical thing to ensure our solutions don't break others. Part of this responsibility is properly identifying what environments we support.
Read Full ArticleDotNetNuke Performance Settings Explained
DotNetNuke out of the box has a number of configuration settings that can impact performance, and by default, they are not configured correctly. Let's improve your website performance.
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.