OStress.exe – use it if you aren’t already

I was recently trying to simulate the performance implications of hashing vs encryption and wanted to simulate hundreds of sessions and 1000’s of requested on a username/password table. Most time developers and testers use a test harness for automating this kind of activity or use a load testing tool. I however am not a tester…

IS IT POSSIBLE? Bulk operations in Full recovery model

Here is the reason I am writing this post As per the above entry from MSDN, there cannot be any minimally logged operations in full recovery mode, which is what I have always understood since full recovery model requires point in time recovery. In order to understand my dilemma we need to first define what…

Game Theory and Databases

CASE 1 Two members of a criminal gang are arrested and imprisoned. Each prisoner is in solitary confinement with no means of speaking to or exchanging messages with the other. The police admit they don’t have enough evidence to convict the pair on the principal charge. They plan to sentence both to a year in…

SSAS: – Dimension Hierarchies

Most of the time there will be a relationship between different attributes in the dimension. We saw an example of this kind when we created the date dimension in the previous post. In particular this kind of relationship was a parent child relationship or a hierarchy between Years to Month to Week to Day. Such…

SSAS Create a Cube

Once the data source and the Datasource view have been created the next step will be to create the actual cube. Within BIDs there is a very useful wizard which allows the developer to create the cube in a few simple steps. However as the cube become more complex developers will see that it’s easier…

SSAS: – Implementing Perspectives

A perspective is a very useful feature within SSAS as it allows the designer to mask the underlying complexity of the cube based on the user. The perspective by definition means a point of view and this is what is provided when we implement a perspective within a cube. Say for example a cube consists…

Downloading the SQL 2014 product guide

Today we are going to do a quick post on where you can download the SQL 2104 product guide. http://www.microsoft.com/en-in/download/details.aspx?id=39269   The above link takes you directly to the download file. Once downloaded you need to extract the zip file. You will notice the content is not as extensive as that for 2012 but it…