Skip to content

Instantly share code, notes, and snippets.

Avatar

Brent Maxwell brentmaxwell

View GitHub Profile
View keybase.md

Keybase proof

I hereby claim:

  • I am brentmaxwell on github.
  • I am brentmaxwell (https://keybase.io/brentmaxwell) on keybase.
  • I have a public key whose fingerprint is 48FC FD01 403C F2AD 5B24 2924 755D 8989 5912 D6FA

To claim this, I am signing this object:

View GpsTimeExtensions.cs
namespace System
{
public static class GpsTime
{
public static int ToGpsTimeWeekNumber(this DateTime datetime)
{
DateTime datum = new DateTime(1980, 1, 6, 0, 0, 0);
TimeSpan difference = datetime.Subtract(datum);
return (int)(difference.TotalDays / 7);
}
@brentmaxwell
brentmaxwell / BinaryIPfunctions.sql
Created Mar 30, 2015
IP Address conversions in SQL
View BinaryIPfunctions.sql
CREATE FUNCTION [StringIpToBin]
(
@StringIp VARCHAR(15)
)
RETURNS BINARY(4)
AS
BEGIN
RETURN
CAST(CAST(PARSENAME(@StringIp,4) AS INT) AS BINARY(1)) +
CAST(CAST(PARSENAME(@StringIp,3) AS INT) AS BINARY(1)) +
@brentmaxwell
brentmaxwell / DelimitedStringToTable.sql
Last active Apr 5, 2017
Delimited string to table
View DelimitedStringToTable.sql
CREATE FUNCTION [dbo].[DelimitedStringToTable]
(
        @String nvarchar(MAX),
        @Delimiter nvarchar(1)
)
RETURNS @Items TABLE
(
        Item nvarchar(50)
)
AS
@brentmaxwell
brentmaxwell / AutoMapperConfig.cs
Last active Dec 6, 2017
Put automapper configs in model classes NOTE THIS DOES NOT WORK WITH THE LATEST VERSION OF AUTOMAPPER
View AutoMapperConfig.cs
public class AutoMapperConfig
{
/// <summary>
/// Function that is called in the Global.asax file
/// Runs through and calls each of the functions below, registering the various mappings
/// </summary>
public static void Execute()
{
RegisterOtherMaps();
RegisterMapperHelpers();
@brentmaxwell
brentmaxwell / rowcounts.sql
Created Mar 17, 2015
Get *approximate* row counts of all tables in a db
View rowcounts.sql
SELECT
[TableName] = so.name,
[RowCount] = MAX(si.ROWS)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U' AND
si.id = OBJECT_ID(so.name)
GROUP BY so.name ORDER BY so.name
@brentmaxwell
brentmaxwell / UnixTimeExtensions.cs
Created Mar 17, 2015
Extensions to convert Unix time to DateTime
View UnixTimeExtensions.cs
namespace System
{
public static class UnixTimeExtensions
{
public static long ToUnixTime(this DateTime datetime)
{
return (long)(datetime.ToUniversalTime() - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds;
}
public static DateTime FromUnixTime(long time)
You can’t perform that action at this time.