15,747,637 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View Javascript questions
View C++ questions
View Python questions
View Java questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Artificial Intelligence
Artificial Intelligence
Neural Networks
Machine Learning
Deep Learning
ML.Net
Big Data
Data Science
Tensorflow
ChatGPT
Internet of Things
Internet of Things
Arduino
Edge Device
Raspberry-Pi
Wearables
IoT Edge
Industrial IoT
DevOps
DevOps
Agile
Automation
Continuous Build
Continuous Delivery
Continuous Deployment
Continuous Integration
Deployment
Git
Installation
Integration Testing
Load Testing
Quality Assurance
TFS
Unit Testing
Testing
Containers
Containers
Docker
Kubernetes
Virtual Machine
High Performance Computing
High Performance Computing
GPU
Parallel Processing
Parallelization
Vectorization
Hosted Services
Hosted Services
AWS
Cordova
ExtJS
Google Cloud
Microservices
PhoneGap
Serverless
Storage
Web Hosting
WordPress
Azure
Security
Security
Blockchain
Cryptography
Encryption
Identity
Identity Server
Web Development
Web Development
Blazor
CSS3
Flask
HTML5
Kestrel
LESS
Nginx
Node.js
React
SCSS
Spring
Vue.js
ASP.NET
CSS
Apache
HTML
IIS
XHTML
Mobile Apps
Mobile Apps
Flutter
Ionic
iOS
Nativescript
React Native
Xamarin
Windows Mobile
Android
Desktop Programming
Desktop Programming
Cocoa
Electron
QT
Universal Windows Platform
X11
Windows Forms
ATL
MFC
Swing
Win32
WTL
WPF
XAML
System
Database Development
Database Development
Data Visualization
Elasticsearch
Lucene
MariaDB
MongoDB
NoSQL
PostgreSQL
Redis
MySQL
SQL Server
Productivity Apps and Services
Productivity Apps and Services
LibreOffice
OpenOffice
Sharepoint
Team Communication Tools
Biztalk
Microsoft Office
SAP
Game Development
Game Development
Doom
Kinect
Playstation 4
Playstation 5
Unity
Unreal
XBox
Multimedia
Multimedia
Audio
Image Processing
Video
Audio Video
DirectX
GDI
GDI+
OpenGL
General Programming
General Programming
Algorithms
Compression
Computational Geometry
Emulation
Exceptions
File
Internet
Localization
Memory Management
Optimization
Parser
Performance
Regular Expressions
Sorting
State Machines
Architecture
Design / Graphics
Printing
String
Threads
Usability
Programming Languages
Programming Languages
ASM
Bash
Basic
COBOL
Dart
Go
Haskell
Kotlin
Lua
Pascal
R
Razor
Rust
Scala
Swift
Typescript
Objective C
Visual Basic
VBScript
C++
C#
F#
FORTRAN
Java
Javascript
Perl
Python
Ruby
SQL
PHP
PowerShell
XML
Articles by Daniel Miller (Articles: 6, Technical Blogs: 3, Tip/Tricks: 5)
Articles: 6, Technical Blogs: 3, Tip/Tricks: 5
Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects
Average article rating: 4.95
Database Development
SQL Server
Configuring SQL Server Accent-Insensitivity
4 Jan 2012 Updated:
21 Feb 2012
Rating: 5.00/5 Votes: 9 Popularity: 4.77
Licence: CPOL Views: 55,818
Bookmarked: 9
Downloaded: 388
Please
Sign up or sign in
to vote.
This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.
SQL Server Table and Column Naming Conventions
17 Dec 2015 Updated:
30 Dec 2015
Rating: 4.80/5 Votes: 54 Popularity: 8.24
Licence: CPOL Views: 221,689
Bookmarked: 85
Downloaded: 752
Please
Sign up or sign in
to vote.
This article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to visualize dependencies and automatically validate and generate foreign key constraints.
A Fast and Lightweight Solution for CQRS and Event Sourcing
8 Apr 2020 Updated:
8 Apr 2020
Rating: 4.98/5 Votes: 40 Popularity: 7.98
Licence: CPOL Views: 58,021
Bookmarked: 46
Downloaded: 1,635
Please
Sign up or sign in
to vote.
Describes a fast, lightweight implementation of the CQRS+ES pattern using C#
Web Development
HTML
ASP.NET Application Error Handling
31 May 2013 Updated:
26 Jan 2015
Rating: 4.96/5 Votes: 38 Popularity: 7.83
Licence: CPOL Views: 192,823
Bookmarked: 94
Downloaded: 3,200
Please
Sign up or sign in
to vote.
Application error handling in ASP.NET
Lightning-Fast Nested User Groups in C#
5 Dec 2015 Updated:
5 Dec 2015
Rating: 5.00/5 Votes: 28 Popularity: 7.24
Licence: CPOL Views: 37,161
Bookmarked: 59
Downloaded: 787
Please
Sign up or sign in
to vote.
This article describes the C# implementation for a high-performance user/role security principal hierarchy.
LESS
Lightning-Fast Access Control Lists in C#
18 Nov 2015 Updated:
10 Dec 2015
Rating: 4.97/5 Votes: 88 Popularity: 9.67
Licence: CPOL Views: 127,351
Bookmarked: 151
Downloaded: 3,823
Please
Sign up or sign in
to vote.
This article describes the C# implementation for a high-performance role-based access control list.
Average blogs rating: 4.80
All Topics
The High Cost of Low Software Estimates [Technical Blog]
13 Oct 2015 Updated:
13 Oct 2015
Rating: 4.60/5 Votes: 6 Popularity: 3.58
Licence: CPOL Views: 8,152
Bookmarked: 0
Downloaded: 0
Please
Sign up or sign in
to vote.
Estimating too low on a software development project can destroy your budget and ruin your project schedule. Here's the reason why.
Code of Ethics and Professional Practice [Technical Blog]
20 Oct 2015 Updated:
20 Oct 2015
Rating: 5.00/5 Votes: 1 Popularity: 0.00
Licence: CPOL Views: 8,230
Bookmarked: 1
Downloaded: 0
Please
Sign up or sign in
to vote.
In 1999, a task force was created by IEEE and ACM to author a code of ethics for our profession; it stands the test of time as an excellent statement of the ideals that we (as developers) strive to uphold. I have posted the summary version here for the benefit of anyone who has not yet read it.
Programming Languages
C#
How to Download Messages from an IMAP Server Using C# [Technical Blog]
5 Jan 2016 Updated:
5 Jan 2016
Rating: 0.00/5 Votes: 0 Popularity: 0.00
Licence: CPOL Views: 16,012
Bookmarked: 5
Downloaded: 0
Please
Sign up or sign in
to vote.
How to download messages from an IMAP server using C#
Average tips rating: 4.75
Database Development
SQL Server
Concatenating Strings with a Custom SQL Aggregate Function [Tip/Trick]
27 Jul 2015 Updated:
27 Jul 2015
Rating: 4.88/5 Votes: 6 Popularity: 3.80
Licence: CPOL Views: 25,642
Bookmarked: 5
Downloaded: 289
Please
Sign up or sign in
to vote.
This tip describes the code to create a custom SQL Server aggregate function that concatenates multiple string values into a single delimited value.
Entity and Mapping Class Generator for EF [Tip/Trick]
29 Dec 2015 Updated:
29 Dec 2015
Rating: 5.00/5 Votes: 3 Popularity: 2.39
Licence: CPOL Views: 13,201
Bookmarked: 11
Downloaded: 492
Please
Sign up or sign in
to vote.
This tip provides a simple solution to automate the generation of entity and mapping classes for Entity Framework.
DevOps
How to Install gacutil.exe on a Windows Server [Tip/Trick]
21 Oct 2015 Updated:
21 Oct 2015
Rating: 4.29/5 Votes: 5 Popularity: 3.00
Licence: CPOL Views: 112,555
Bookmarked: 4
Downloaded: 0
Please
Sign up or sign in
to vote.
This article outlines the steps for installing the Global Assembly Cache Tool on Windows Server 2008.
How to Count All Tables, Rows, and Rows Per Table [Tip/Trick]
21 Nov 2015 Updated:
22 Nov 2015
Rating: 4.60/5 Votes: 11 Popularity: 4.79
Licence: CPOL Views: 10,581
Bookmarked: 13
Downloaded: 0
Please
Sign up or sign in
to vote.
This code snippet shows how to count all the tables and rows in a SQL Server database
Programming Languages
T-SQL
How to Calculate the Length of the Largest Text Value in Every Table Column [Tip/Trick]
23 Oct 2015 Updated:
22 Nov 2015
Rating: 5.00/5 Votes: 4 Popularity: 3.01
Licence: CPOL Views: 17,562
Bookmarked: 13
Downloaded: 0
Please
Sign up or sign in
to vote.
This tip shows how to display the length of the longest string value in every table and column in your database.
Average reference rating:
No reference articles have been posted.
Average project rating:
No projects have been posted.
Daniel Miller
Chief Technology Officer
Shift iQ
Canada
I have been building software systems for more than 20 years, working for organizations that range from small non-profit associations in my local community to global Fortune 500 enterprises.
I specialize in the design and implementation of online database solutions. My work-related research interests include software design patterns and information architecture.
Submit an article or tip