|
|
-
|
|
I am getting back to continuing writing on SQL Server 2012 – Tabular Projects. A series that I started back in September 2011 and then dropped off. If you are new to Tabular Projects I encourage you to read my earlier posts about them here.
This blo...
|
|
-
|
|
Ever wondered how does a start schema really work? I did, when I was new to BI and Data warehousing. It is really important to understand how a star schema is actually used. The basic understanding allows a dimensional designer to make intelligent choices....
|
|
-
|
|
SharePoint is undoubtedly a very established product for corporate intranets/extranets and for some internet sites as well. It is a great collaborative platform for information management (both structured and unstructured) and tight integration with Window...
|
|
-
|
|
Some time ago, I was asked by a client if they could use indexed views in a staging environment and what are the things that they should consider before doing so? Would that affect data loads? It was an interesting question and it took me a few seconds to ...
|
|
-
|
|
A very common problem that has plagued both the DBAs and developers for a long time is migrating databases to different SQL Server instances for application development and testing purposes OR for various failover conditions. Databases are not really indep...
|
|
-
|
|
When I was thinking about writing this post this morning a very interesting analogy came to my mind. I live in Sweden and both my kids are born here. When children are vaccinated in Sweden, before giving them the vaccination, the nurse makes them drink sug...
|
|
-
|
|
A data warehouse is a large repository of historical data which supports an organization’s decision-making process. The use of a data warehousing system is very different from an operational system or an Online Transaction Processing System. The tabl...
|
|
-
|
|
This is a very quick post about installing the Azure SDK. If you are trying to install the Azure SDK using the Microsoft Web Platform Installer and have run into an error that says that the following four dependencies could not be installed.
IIS: HTTP Red...
|
|
-
|
|
I have thought of putting together some of my favorite MDX tricks for a while now. Here is the first set of some basic tricks. All of the code examples have been tested on SQL Server 2008 R2 Analysis Services and on Adventure Works DW 2008 R2 sample databa...
|
|
-
|
|
As almost everyone out there is aware of the launch of SQL Server 2012 last week. Along with the launch Microsoft announced xVelocity in-memory technologies. This is an umbrella name for all the in-memory technologies. This includes re-branding of the Vert...
|
|