If you database has no Time or Date table you can use the Dimension Wizard in SQL Server Data Tools (SSDT) to generate your Time Dimension. You can have the tool generate a Time Table either in the data source (if you have permissions) or on the Server. When creating your Time Table using the …
Create a Time Dimension using the SQL Server Data Tools Dimension Wizard Read More »
Looking for the best open source tools for running agile projects. The goal of this little experiment is to create a CI / CD pipeline including planning, task management, source control / versioning, triggered build and test and deployment to the cloud. Today I’m experimenting with Taiga an open source planning and task management tool. …
I have a few smart speakers scattered around my place from both Amazon and Google and both have their strengths and weaknesses. However when it comes to usefulness as a nightstand alarm clock devices from both companies fall short. First the Google home and Google Mini do not have screens to view the current time …
Thinking of using this cake image in future discussions of vertical slicing of user stories. What do you think? https://www.reddit.com/r/creepy/comments/9oidi7/cockroach_cake/?utm_source=reddit-android
Using stored procedures in your Data Access code from ASP.Net applications stops most (not all) SQL Injection Attacks and also ensure that the query is executed with the same parameters in the same order and format each time allowing the query optimizer to use the same query plan on subsequent executions. So it makes good …
This is a great video from the AWS Tutorial Series where they show how to configure multiple Jenkins Build nodes in AWS to support Continuous Integration
What is an Exception An Exception is the object class that is created by .Net when an error or unexpected state is encountered while executing application code. All Exceptions inherit from the System.Exception class. The Exception object that is created when an error occurs contains error details including the stack trace and potentially any underlying …
Custom Errors Series: Part 1 – What is an Exception Read More »
When planning an agile project creating User Stories and estimating their complexity is an important step to provide your customer and delivery team with a clear understanding of the solution being developed. Estimating the complexity of a User Story is something typically done by a Product Owner after or during a meeting with a customer …
Slicing by Roles User stories often involves a number of roles (or groups) that performs parts of that functionality. Take a user story to publish new articles to a public newspaper website: As news organization I want to publish new articles on our homepage, so customers have a reason to return periodically By considering the …
Are your Daily Standups and Sprint Retrospectives taking too long? Do important stakeholders frequently skip your meetings? Do team members question the value of your Standups and Retros? It may be time to reevaluate the priorities of your daily standup and retrospectives. Don’t just hit the bullet points! A retrospective is not just about what you did yesterday …
Scrum Ceremonies Dont just hit the bullet points! (Rant) Read More »