ProDataMan Blog

Please excuse our dust... We are in the process of migrating the blog content over from the old Office 365 public web where it was previously hosted. Everything should be back to normal a week or so.

ProDataMan Blog »

Last Update: Feb 11, 2020 01:01:16

SQL Server Analysis Services References

Antoine Victor 1/29/2020 6:17:56 PM

SSAS

Detailed Descriptions of each of the built in Data Mining Algorithms
https://docs.microsoft.com/en-us/analysis-services/data-mining/data-mining-algorithms-analysis-services-data-mining

Creating and Managing SubCubes
SubCubes only exist for the duration of a session/connection so use for context not security
https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/building-subcubes-in-mdx-mdx

Cube Security
https://www.mssqltips.com/sqlservertip/2776/configuring-permissions-for-sql-server-analysis-services/
Measure and Dimension Security (14:30)
https://www.youtube.com/watch?v=NlNw3wYbh8E

5 Agile Rules
Antoine Victor 11/19/2019 9:32:17 PM

Sprint Planning: The 60/40 Split2-4 hours of Sprint planning for each week of a Sprint should yield 60% of delivery team tasks necessary to complete a user story defined and documented prior to the SprintThe 80/20 CommitmentThe average agile team incurs 10-30% technical debt in each Sprint. Mature teams closer to 10% newer Agile teams … Continue reading "5 Agile Rules"

Simple Echo App in Eclipse with TDD
Jamal Allen 11/7/2019 2:48:57 AM

In this tutorial, we will walk through creating a basic JUnit test class in Eclipse just to make sure that our environment is set up properly. We will use Test Driven Development (AKA Test First Development) to ensure that we are writing just enough code to pass our test, and not writing our test to … Continue reading "Simple Echo App in Eclipse with TDD"

Acceptance Test Automation with Cucumber / SpecFlow in Visual Studio
Antoine Victor 7/8/2019 10:24:38 PM

SpecFlow
Acceptance Criteria, Test Automation and Gherkin What do Acceptance Criteria, Test Automation and a Cucumber have in common? Well for the uninitiated in may seem that these 3 things have nothing in common however if you are an “Agilist” or Test Automation specialist than you are probably very familiar with the similarities. Let’s start with … Continue reading "Acceptance Test Automation with Cucumber / SpecFlow in Visual Studio"

Add Cucumber Acceptance Tests to a Maven Project
Antoine Victor 6/27/2019 5:39:19 PM

In order to automate acceptance tests with Cucumber in Eclipse we must first load the Cucumber Plugin in Eclipse using the Eclipse Marketplace.  Once the Cucumber Plugin is installed in Eclipse, we can create a Maven Project and add Feature, Step Definition and CucumberRunner classes to integrate our Gherkin Acceptance Criteria statements with our Junit … Continue reading "Add Cucumber Acceptance Tests to a Maven Project"

The Triage Triangle a useful Agile Tool
Antoine Victor 4/23/2019 3:04:49 AM

The Triage Triangle
In traditional Waterfall projects we had to be careful and beware of the dreaded Scope Creep… That evil demon that creeps into your back log as overachieving team members agree to do undocumented change requests that come in after the project planning and budget have already been done. Historically to avoid scope creep organizations have … Continue reading "The Triage Triangle a useful Agile Tool"

Installing Cucumber Plugin for Eclipse
Antoine Victor 4/3/2019 2:08:08 AM

If you are using the Eclipse IDE and want to get started with Behavior Driven Development then you will most likely want to install the Cucumber Eclipse Plugin. With the plugin installed and a couple of supporting files created you can run and review automated acceptance tests. If you don’t already have Eclipse installed it … Continue reading "Installing Cucumber Plugin for Eclipse"

Staging and Committing Changes in Git and GitHub
Antoine Victor 3/1/2019 10:24:47 PM

GitHub
Staging Files As we generate new solution artifacts they need to be added to the repository, integrated with work by other team members and tested to ensure that no defects were introduced by our changes. Until we add the files to the repository they are considered untracked files even though they are present in a … Continue reading "Staging and Committing Changes in Git and GitHub"

Creating a Git Repository
Antoine Victor 2/25/2019 11:35:17 PM

Git Logo
There are a few ways to create a Git Repository but before we talk about How let’s talk about Why. Why do we need a Git Repository or any Repository for that matter? And What is a Git Repository anyway? In its simplest for a Git Repository is simply a folder that contains files that … Continue reading "Creating a Git Repository"

DevOps Case study links
Antoine Victor 2/12/2019 11:47:06 PM

Case Study
•GE Case Study •AWS Sydney Australia https://aws.amazon.com/blogs/aws/ge-oil-gas-digital-transformation-in-the-cloud/ •GE Oil and Gas Presentation https://www.youtube.com/watch?v=DFGFaJZFtuk •GE, AWS adoption http://www.slideshare.net/AmazonWebServices/ism209-acceleration-of-aws-enterprise-adoption-in-ge??Microsoft Developer Division Case Study •Interview with Sam Guckenheimer on Microsoft’s Journey to Cloud Cadence http://www.infoq.com/articles/agile2014-guckenheimer •ALM Devops features https://www.visualstudio.com/en-us/features/alm-devops-vs.aspx •Microsoft Continuous Delivery Discussion https://www.youtube.com/watch?v=caM0DojhV7w •Rakuten and Microsoft talk Devops in Real World http://www.slideshare.net/TsuyoshiUshio/rakuten-and-microsoft-talk-devops-in-real-world •Detailed retrospectivehttp://blogs.msdn.com/b/bharry/archive/2013/11/25/a-rough-patch.aspx? • Knight Capital … Continue reading "DevOps Case study links"

Open Source Development: Installing Java, Maven, Git and Gnome on Ubuntu
Antoine Victor 1/25/2019 7:56:58 PM

Before you can begin building that groundbreaking new app you have been dreaming about you first need to get your development environment setup. The following steps represent the path of least resistance to get a development environment setup and begin development of your new killer app. The tools mentioned will also allow your new software … Continue reading "Open Source Development: Installing Java, Maven, Git and Gnome on Ubuntu"

Technical Debt Pay It Forward
Antoine Victor 12/17/2018 4:48:15 PM

Technical Debt
Pay it Forward You can pay now or pay later but trust me you’re gonna pay! I’m talking about Technical Debt… Technical Debt like any other Debt has Interest, so you can pay now or pay later but if you pay later it will be much more expensive. See this post on the Increasing cost … Continue reading "Technical Debt Pay It Forward"

Follow ProDataMan on Facebook, YouTube and Twitter
Antoine Victor 12/6/2018 8:59:34 PM

Follow Us: @ProDataMan
We geek out with no limits on Facebook @ProDataMan there will be posts about underwater hotels that have nothing to do with Programming, SQL Sever or DevOps but it will always be cool High Tech stuff… Follow us on Twitter @ProDataMan to be notified when we add a new video to a Playlist on the … Continue reading "Follow ProDataMan on Facebook, YouTube and Twitter"

Blockchain Part 4: Decentralized Applications (Dapps)
Charles Obong 11/30/2018 4:00:45 PM

Blockchain
While cryptocurrencies in general and Bitcoin in particular are the primary application that brought blockchain into the limelight, the potential of blockchain in the enterprise extends far beyond cryptocurrencies. As we’ll see in subsequent blogs, companies in financial, energy, medical, supply chain management, logistics, cloud computing, etc. are now investing in and launching proof of … Continue reading "Blockchain Part 4: Decentralized Applications (Dapps)"

Blockchain Part 3: Why Blockchain is the Next Platform for Applications
Charles Obong 11/28/2018 7:00:07 AM

Blockchain
Blockchains are comprised of single blocks chained together to form a single chain or single main chain and multiple side chains. Single (Main) Chain As the name implies is a single on the main chain in the blockchain. Here, the main chain validates and processes all blocks and transactions. Multi (Side) Chain Because all transaction … Continue reading "Blockchain Part 3: Why Blockchain is the Next Platform for Applications"

Blockchain Part 2: What is Blockchain?
Charles Obong 11/27/2018 7:00:42 PM

Blockchain
Blockchain is an append-only electronic distributed ledger database technology. The protocol ensures that each block of data is tamper proof, secure, decentralized, verified and fingerprinted (or hashed) before it is appended to the chain. For example: Currently, most enterprise companies like Facebook, Amazon and Microsoft run a data monopoly, meaning that all user data that … Continue reading "Blockchain Part 2: What is Blockchain?"

Blockchain Part 1: Difference Between Blockchain vs Bitcoin (08/06/2018)
Charles Obong 11/26/2018 1:06:15 AM

Blockchain
Edit: Interesting how much has changed in just 3 short months Bitcoin is trading today 08/06/2018 at $7,632 ($3,941.67 11/25/2018) compared to August 16th, 2010, when it was trading at $0.07 per coin. Bitcoin actually went up to $15,825 per coin on December 2017. The meteoric rise in Bitcoin value and other cryptocurrencies has led … Continue reading "Blockchain Part 1: Difference Between Blockchain vs Bitcoin (08/06/2018)"

Best Agile / DevOps Open Source Tool Chain
Antoine Victor 11/1/2018 9:40:59 PM

Historically I have been a Microsoft C# guy but the more I work with non-Microsoft shops with Hybrid environments and Java guys running around everywhere the more curious I have become about open source tool chains for Agile and DevOps. We use Team Foundation Services for Work Item Tracking, Planning, Continuous Integration, and Continuous Deployment … Continue reading "Best Agile / DevOps Open Source Tool Chain"

Create a Time Dimension using the SQL Server Data Tools Dimension Wizard
Antoine Victor 10/24/2018 8:27:17 PM

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 … Continue reading "Create a Time Dimension using the SQL Server Data Tools Dimension Wizard"

Currently Reviewing Open Source Agile Tools
Antoine Victor 10/19/2018 3:14:52 AM

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.  … Continue reading "Currently Reviewing Open Source Agile Tools"

More Posts »