All posts by bryan

GitHub Naming Repositories

As part of our customer engagement, we have defined a naming convention for GitHub repositories. 

We have ideas around what conventions made sense, although the type of work influences these. As we tend to spend some of your engineering time working with different languages, conventions around naming formats make sense to the engineers. These, of course, might not make sense to individuals in other fields. 

Continue reading GitHub Naming Repositories

gists

GISTS – engage in chat or gossip. 
“I need a good friend I can always gist with.” 

It is always good to chat with others, which is how we learn from each other. So why don’t project teams chat with each other? In this day and age of working from home, it is becoming more and more critical to form a social network, which helps not only with mental health but also work-related ideas and time. 

Continue reading gists

SQL Record Count

The fastest way to perform a SQL record count is:

DECLARE @TableName sysname
SET @TableName = 'Log'
 
SELECT TBL.object_id, TBL.name, SUM(PART.rows) AS rows
FROM sys.tables TBL
INNER JOIN sys.partitions PART ON TBL.object_id = PART.object_id
INNER JOIN sys.indexes IDX ON PART.object_id = IDX.object_id
AND PART.index_id = IDX.index_id
WHERE TBL.name = @TableName
AND IDX.index_id < 2
GROUP BY TBL.object_id, TBL.name;