In this post, I am going to attempt to write a guide to using Team Foundation Server to act as a source control system for BI developers, including data warehouse development and BI application development (SSRS/SSAS). Join me after the jump to see how I do!
Hello everyone! I’d like to start hosting regular blog carnivals on a monthly interval and this post will start off the first one. For those that don’t know, a blog carnival is where one blogger posts a topic, and other bloggers respond and link back to the original blogger to create a pingback. Some bloggers then collect the responses and post a list of links to each blogger that responded to the carnival. Join me after the break to see this month’s topic.
So the downside of being active with the SQL Server community on Twitter is that occasionally you stumble into drama best left for community members with more time in the community and more smarts than I have. However, opinionated me just doesn’t listen to good advice like that. Jump below the break to see what’s going on and exactly what I think of it.
SQL Server 2016 is just around the corner. One of the big features is in memory analysis of OLTP databases. At first glance, it seems that traditional data warehousing and dimensional modeling of data would be severely threatened, especially with tools like PowerBI and SQL Server Analysis Services making it so easy for analysts to work with data.
Oh boy… I just noticed that FOXPass just posted their June meeting announcement the other day at http://fox.sqlpass.org/Home.aspx. You’ll notice that I am presenting at this user group meeting. Me. A wide-eyed newbie is going to talk to these pros about dimensional modeling and why they need to know about it.
Never mind that dimensional modeling was introduced a long time ago by Ralph Kimball. Never mind that this audience might have known about dimensional modeling for a lot longer that I have. No. Despite these things, I still had the audacity to say, sure, I’ll give a talk. What’s the worse that can happen?
With the pending release of SQL Server 2016, it’s time for me to refresh and update my environment. One of the biggest issues I have with my current environment and workflow is that I am not well positioned for an eventual expansion of my team. Right now, I am the sole BI developer so I can leave all my development code on my laptop (unless something happens to it).
With the new environment I want to utilize Team Foundation Server for version control. The primary reason for TFS is that it’s a Microsoft product, it’s easier to maintain (at least in my mind it is), and I can use the community edition and not have to license it. Continue reading Source Control Woes
So today I don’t have any posts for Road to Insight series. I’ve been busy at work and with bowling season wrapping up I’ve been getting my tournament appearances in. However, today, I do have a story to tell. Catch me after the jump to hear it.
Good morning everyone!
I hope you all have had a good week so far, and if you are reading this on a Monday, I’m sorry. I am going to take a break on the Road to Insight series and talk about why data warehouses won’t be replaced by cloud-based BI solutions like PowerBI. Now, I know that PowerBI isn’t positioning itself to replace traditional data warehouses but if I had the thought that it might, I am sure others have so I want to present my reasons why I don’t believe that cloud BI will replace a traditional warehouse.
Good morning everyone (while it’s morning as I right this, so pretend its morning when you read this)! I hope everyone had an excellent Easter. Even if you are not religious or your faith doesn’t celebrate Easter, it’s still a great time for personal renewal and reflection, as well as spending time with friends and family. In this post in the on-going series of The Road to Insight, we tackle building the data warehouse itself. Join me after the jump to figuratively see this build in action.
Welcome to part 3 of my road to insight series in which I build an entire BI solution from start to finish. In parts 1 and 2 we setup a test server and brought the AdventureWorks database online. In this post, we discuss the project requirements and data model for the data warehouse. Let’s hop to it!