Always remain updated about current software development trends

Articles by PIEBALDCONSULT

The Elegant Art of Programming

By PIEBALDconsult

This is an alternative for "The Elegant Art of Programming"

The Elegant Art of Programming

By PIEBALDconsult

This is an alternative for "The Elegant Art of Programming"

From one number system to another

By PIEBALDconsult

This is an alternative for "From one number system to another"

List SQL Server table column name as rows

By PIEBALDconsult

This is an alternative for "List SQL Server table column name as rows"

Getting a list of SQL Server modules to refresh

By PIEBALDconsult

Here it is wrapped in a procedure:CREATE PROCEDURE [dbo].[RefeshAllModules]ASBEGIN DECLARE @Name NVARCHAR(128) DECLARE @Stmt NVARCHAR(128) DECLARE ModuleList CURSOR FOR WITH cte AS ( SELECT DISTINCT lft.referenced_id [object_id] , 0 [Rank]...

Validating gender dynamically using REGEX

By PIEBALDconsult

This is an alternative for "Validating gender dynamically using REGEX"

Sorting 'Total' after data values

By PIEBALDconsult

Interspersing 'Total' rows among summarized data rows in the correct order

Bitwise OR aggregate

By PIEBALDconsult

Performing a bitwise OR aggregate in SQL Server

LPAD and RPAD functions in SQL

By PIEBALDconsult

This is an alternative for "LPAD and RPAD functions in SQL"

A String.StartsWith that uses a StringComparer

By PIEBALDconsult

An Extension Method that is similar to String.StartsWith, but uses a StringComparer