tag:blogger.com,1999:blog-57066548346121088752024-03-21T15:18:15.398+02:00EOH: Microsoft BI and Development A technical blog, from the minds of the Microsoft BI and Custom Dev teams at EOH. Anonymoushttp://www.blogger.com/profile/14855339893003672250noreply@blogger.comBlogger103125tag:blogger.com,1999:blog-5706654834612108875.post-14871797955425395862015-02-13T09:53:00.000+02:002015-02-13T10:01:47.162+02:00The Effect of Incorrect SQL Data Types
On taking
over an existing data transfer and comparison system I was intrigued to notice
that a seemingly simple SSIS process was taking over four hours to run - on a
daily basis. Something didn’t seem right,
and on investigation it turned out there were lots of improvements to be
made. This blog is covering only one of
them: the importance of choosing the correct SQL data types.
Anonymoushttp://www.blogger.com/profile/10320356567014764990noreply@blogger.com72tag:blogger.com,1999:blog-5706654834612108875.post-16767755981358285662015-02-10T10:18:00.001+02:002015-02-10T11:54:26.575+02:00My first SSIS project: Part 1
Helping myself and other beginners gain a better understanding of SSIS
I want to show my understanding and the methods I found from
the Internet and colleagues to explain the concepts of SSIS. The reason I am
doing this blog is because I want to leave a little bit of a guide for myself.
If this blog sheds some light on the functionality of SSIS for you as the
reader then that is greatAnonymoushttp://www.blogger.com/profile/15956256160919461008noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-86468466824963795102015-02-10T10:07:00.005+02:002015-02-10T11:56:44.609+02:00Converting a SAS application into a working SSIS project
My journey
began with unveiling my new mission that was given to me by the SQL Secret Services:
To unravel if it was possible to convert a current SAS application that was run
manually by a user once a week. I was to help the poor unfortunate soul get rid of this burden.
So I began my
destined journey to complete the difficult
but possible mission.
What was I to
do???
The design
Anonymoushttp://www.blogger.com/profile/00948523954231482835noreply@blogger.com3tag:blogger.com,1999:blog-5706654834612108875.post-48466294037587487132015-02-09T15:26:00.000+02:002015-02-09T15:27:53.253+02:00PowerBI Update There have been a few rumblings in the PowerBI (Microsoft`s cloud BI solution) world of late.
With the visual analytics and self-service BI world as competitive as it is, this is good news for anyone who has a strategy built on the Microsoft BI toolset.
Here are the highlights:
New version of PowerBI on the horizon.
Although this is relatively old news by now, It is still Anonymoushttp://www.blogger.com/profile/14633077345849515325noreply@blogger.com3tag:blogger.com,1999:blog-5706654834612108875.post-73435976380612164582015-01-15T11:19:00.001+02:002015-01-15T11:19:27.611+02:00GIF Animations in Internet ExplorerInternet Explorer(IE) has an inherent problem with animating .gif images which are originally hidden.
The reason is that IE loads the .gif but does not start the animation when it is hidden.
Unfortunately the animation does not start when it made visible thus appearing to be frozen.
A small workaround for this issue is to reset the images source to itself after it has been displayed on the page.Anonymoushttp://www.blogger.com/profile/06640377169040088180noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-57566734276775405732014-12-02T14:42:00.000+02:002015-01-15T12:14:05.388+02:00
Choosing the Right BI Platform
In any business
environment the critical mission is staying ahead of your competitors and ahead
of the economy, choosing the right business intelligence (BI) platform can give
you the competitive advantage you need for success. Taking time up front to
evaluate your current environment and to define your goals and objectives are
key in identifying a solution Anonymoushttp://www.blogger.com/profile/06376976028277930427noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-44194279909943052132014-11-28T10:01:00.005+02:002014-11-28T10:01:53.153+02:00Can someone give me a Template please?
Can
someone give me a Template please?
In this post I’m going to explain how to create a
custom template that you can add to your Report Server and it will then appear
in the Visual Studio installed templates list when you add a new report to your
project.
Introduction
- Why use a Template?
As consultant we create reports at enterprise level
and this means that we need to ensure that Anonymoushttp://www.blogger.com/profile/09142479169633574716noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-59862827962808130282014-11-28T09:17:00.001+02:002014-11-28T09:17:39.394+02:00SSIS variables: DateTime data type has no milliseconds
Everyone who has written more than few SQL queries is well
aware of the issues that can occur when dealing with dates and times. After a while you develop methods for getting
around different date formats and eventually feel pretty confident that you are on top of
the situation. It’s always good to be
aware that there are lots of places in the development world that can trip you
up.
Anonymoushttp://www.blogger.com/profile/10320356567014764990noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-66884697545463180842014-11-13T11:40:00.001+02:002014-11-13T11:40:48.983+02:00Validation in Stored proc or CodeI believe validating data in a stored proc is better:
-IF you have more than one app looking at that stored proc, the validation is done only once.
-When rules need to be changed, they only changed at one central point.Anonymoushttp://www.blogger.com/profile/14767959622318193140noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-17663204565914342702014-11-12T17:09:00.001+02:002014-11-12T17:12:46.921+02:00Data Modelling Made EasyChallenged
with the typical time and resources constraints at an entrepreneurial client
where rapid LOB system changes are eminent, modelling their data had to be fast
and to the point. In order to focus on the business needs with only pockets of
time available with decision makers, we needed a tool that is easy to understand
and use but comprehensive enough to build the core data warehouse
Martin Verweyhttp://www.blogger.com/profile/13501707865397367547noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-72144281116803172452014-11-10T14:36:00.000+02:002014-11-12T11:19:20.886+02:00
What is SDLC?
SDLC is a process followed for a software project,
within a software organisation. It consists of a detailed plan describing how
to develop, maintain, replace and alter or enhance specific software. The life
cycle defines a methodology for improving the quality of software and the
overall development process.
The following figure is a graphical representation
of the various Anonymoushttp://www.blogger.com/profile/14855339893003672250noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-26526105879845052472014-11-10T11:12:00.000+02:002014-11-12T11:16:07.882+02:00Customizing Report Manager Home Page
Customizing Report Manager Home Page
Reporting Services provides default cascading style sheets (.css) files that define styles for the report toolbar in HTML Viewer and for Report Manager’s homepage. In this post we are going to modify the default styles to change the colours, fonts, and layout of the tool bar or Report Manager.
1. &Anonymoushttp://www.blogger.com/profile/09142479169633574716noreply@blogger.com7tag:blogger.com,1999:blog-5706654834612108875.post-51128236454869883732014-09-26T10:26:00.003+02:002014-09-29T06:55:28.503+02:00Simple ASP.NET MVC 4 explanationThis post is mainly to assist developers to understand how ASP.NET MVC 4 works and how it fits together to create one AWESOME solution.
I was sceptic at first about ASP.NET MVC (coming from a drag drop ASP.NET Web Forms background) and thought it was just another way of trying to complicate the life of a developer until I started researching ASP.NET MVC.
This example project does not have LjCodehttp://www.blogger.com/profile/00460053295387439683noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-13813764098657488632014-09-09T17:20:00.001+02:002014-09-09T17:22:53.833+02:00New Virtual Labs for Power BI and SQL Server 2014I am sure I am not the only one with the dilemma of testing out the new functionality released in the latest versions of the Microsoft SQL Server Stack.
Many times I don`t have the Software handy or I simply don`t have the time/space/willpower to install and configure the toolsets required.
In comes the Microsoft TechNet Virtual Labs.
On this page you will find a gallery Anonymoushttp://www.blogger.com/profile/14633077345849515325noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-48577144773389737532013-07-12T13:42:00.001+02:002014-08-26T17:05:13.604+02:00Phone 8 & Azure Mobile Services - Toast NotificationsPlugging in notification services for Windows8, using azure was easy. So it should be the same for phone 8 right? Well we were wrong. A day later we got it waxed, but for the life of me i cant figure out why it has to be like this - perhaps i missed something.
Anyway we configured a notification table in Azure mobile services with an insert java script trigger. using the push.mpns libraryMark Biagiohttp://www.blogger.com/profile/08126172267771016761noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-75895982976747913322013-07-10T17:27:00.002+02:002014-08-26T17:05:30.511+02:00Performance on large tables
Data volumes are exploding in every
business where a Database or BI professional might find himself. Subsequently
data warehouse and decision support systems to keep up with this growth, and are expected to perform at the same
levels while offering even deeper insights into what the data is actually
saying.
When working with large tables, there are
certain strategies to consider in Anonymoushttp://www.blogger.com/profile/14633077345849515325noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-80989791724113972852013-05-21T08:27:00.000+02:002013-05-21T10:39:34.945+02:00ToExcel() Extension Method
I recently had a migraine inducing problem where I needed to save an
object to an Excel file which, at first glance I thought would be something
easy and simple to do... However Nu-Get's Excel libraries are not as abundant
as one would think. After doing some research I finally found a library worth
its salt, presenting ExtremeML.
ExtremeML is a comprehensive and
fully-supported libraryUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-43466670177465149832013-03-10T16:44:00.000+02:002013-03-10T16:44:03.073+02:00ASP.NET Web API <#= Proxy to T4 #>
One of the coolest new features of ASP.NET is Web API, which allows you to build powerful RESTful services exposed over HTTP. HTTP is not just for serving up web pages, but it provides a platform for building APIs that expose services and data. It is simple, flexible, and ubiquitous.
ASP.NET Web API is all about REST HTTP Services. Unlike Web Services, it does not expose an end-point for Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5706654834612108875.post-35258404829004433352013-02-17T18:12:00.002+02:002013-02-17T18:15:36.202+02:00Some API "best suggestions"
In today’s modern world of computing it’s a no-brainer to expose some kind of service for the outside world to access your enterprise platform in a controlled fashion. Because of good old legacy systems, we all know that “the perfect world” never exists in any of our clients’ current environment. There are always compatibility issues regarding unified communication between these systems and we Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-48043609341840462502013-02-04T14:54:00.000+02:002014-09-09T18:10:45.713+02:00Train yourself, yourself Getting skilled up is the only way to stay alive in the IT
services business, and the best way to do that is hands-on experience. But it isn’t always easy to explore a new tech
or skill if you are not working on a project that it is being used on, apart
from time constraints the hardware and software you need may be lacking. So I
decided to post a couple of things I`ve come across to help Anonymoushttp://www.blogger.com/profile/14633077345849515325noreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-70067111286145231602013-01-21T16:30:00.000+02:002013-01-21T16:30:47.742+02:00It Sounds Like...Imagine a world where everyone had the spelling capability of a High School English teacher... Now snap out of it, because that's slightly delusional. Everybody makes the odd spelling mistake, especially when it comes to names, luckily there's a way in SQL to get around this...
Let's take a name.... Carin for instance can be spelled multiple ways: Carin, Caren, Karin, Karen... So there we see Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5706654834612108875.post-55501666120052063002013-01-17T11:04:00.000+02:002013-01-17T13:17:12.222+02:00Google Doodles Hacked... Well kind of...When the Google Doodles were initially released during the Olympics I played every single game up to the point of absolute boredom. Then yesterday I was a bit bored and started going on a random Google spree and came across the games again and once again I decided to play them, then I thought... Why not try to automate this...
So I started searching for ways to simulate Keyboard input, I found Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5706654834612108875.post-53921239807327902862012-12-13T16:41:00.002+02:002012-12-13T16:49:38.822+02:00How to use CTE's
What is a CTE?
Basically a common table expression is a table that gets created and only lasts for the duration of that query. Once the query is executed, the table doesn't exist anymore. It can be self referenced and can be referenced multiple times in the same query.
The syntax
The syntax of a CTE is as follows
WITH CTE-NAME(optional-distinct-name-1, Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5706654834612108875.post-54577812534411870132012-12-13T16:23:00.000+02:002012-12-13T16:33:35.997+02:00Copy and paste programming
Copy and paste programming by Boipelo Rathebe
A couple a of weeks ago I had a very interesting chat with a
java software developer friend of mine, who had just recently started the job
and us just having a friendly chat around how he’s finding it, and to my
surprise, or not, because I am quite
convinced that we all have found ourselves doing “it”. He tells me it is very
hectic and thisUnknownnoreply@blogger.com1tag:blogger.com,1999:blog-5706654834612108875.post-9508919861010673982012-12-13T14:25:00.001+02:002012-12-13T14:25:54.217+02:00Database vs Data Warehouse
What is a data warehouse?
A
data warehouse is a repository of an organization's electronically
stored data. Data warehouses are designed to facilitate reporting and
analysis. Often designed as OLAP (On-Line Analytical Processing)
systems, these databases contain read-only data that can be queried and
analysed far more efficiently as compared to your regular OLTP (On-Line
Transaction Unknownnoreply@blogger.com3