Johan Åhlén

Johan Åhlén's blog about life, universe and everything.

Browse by Tags

All Tags » SQL Server (RSS)
SQL Azure new user interface - Project Houston
"Project Houston" is the new user interface for SQL Azure. If you have tried SQL Azure you know that the user interface on the web portal is very brief. You can't do almost anything from there (except create new database and setup security...
Try your SQL optimizing skills and win great honor
As winner of the previous round, I’ve been given the honor to write the problem for Phil Factor Speed Phreak Challenge #6. This problem is from the real world (algorithmic trading) and the sample data is real. The challenge is to reproduce highest buy...
Exploring SQL Server under the hood using undocumented DBCC commands
Have you ever wanted to see the details on how data is organised in a SQL Server database? Exactly how tables, indexes, blogs, etc are stored. How SQL Server can find a specific row in a table. This is possible through two undocumented DBCC commands:...
My StreamInsight samples have been moved
I've decided to move my samples to the "official" StreamInsight sample site on Codeplex, http://streaminsight.codeplex.com . The advantage is that there they will be co-located with other useful StreamInsight samples. My currently published...
Posted: Jun 27 2010, 10:02 PM by jahlen | with no comments
Filed under:
Performance optimization - T-SQL, SSIS, SQL CLR, etc what is fastest?
Ever wondered what is the fastest technology for your queries? One way to find out is to let a couple of SQL Server optimization freaks compete who can write the fastest solution. This is what the Phil Factor SQL Speed Phreak Competition is about. Below...
A volcano presentation at Microsoft BI Conference
Sometimes things turn out in a quite different way than expected. I looked forward to visit the Microsoft BI Conference in Stockholm and listen to Rafal Lukawiecki, but ended up doing a presentation there myself... The background is that Rafal is doing...
InstantCube - building a SQL Server Modeling DSL application for quick cube development
Introduction This article describes how to build a tool , InstantCube, that uses SQL Server Modeling Services that drastically reduces the development time of simple Analysis Services cubes. Using the tool you can accomplish with a few lines of DSL (Domain...
SQL Server Modeling - the new name for Oslo
As expected, Microsoft has announced the real name for the Oslo platform during the PDC. It has been named SQL Server Modeling . They also have announced they will release a new CTP, called SQL Server Modeling CTP . However the components ( "M"...
Article published on SQLServerCentral.com
Welcome to read my article, Improving Cube Performance with Precalculated Aggregations , on SQLServerCentral.com. http://www.sqlservercentral.com/articles/SSAS/68309/ More articles will be coming when I have the time to write.
PowerPivot announced as real name for project Gemini
Microsoft just announced the real name for the BI Self Service component (project "Gemini" ) of SQL Server 2008 R2 . According to the new web site, PowerPivot is: "PowerPivot provides business users with BI at their fingertips while enabling...
Installing Reporting Services on Windows 7, Vista or Windows Server 2008
I recently had to reinstall Reporting Services 2008, and had to remind myself how to set it up correctly. Installing Reporting Services on Vista, and later operating systems, can be tricky. I've seen several forum posts of people spending days on...
A first look at SQL Server 2008 R2 - StreamInsight
Background A couple of weeks ago, the second CTP for SQL Server 2008 R2 was released. I downloaded it immediately. Still the product is far from finished, and the CTP didn't contain any preview of the "Gemini" component, but I could at least...
Unleashing the power of SQL Server ENTERPRISE EDITION - Part 1
Background Having seen a number of MS SQL Server Business Intelligence implementations, I have noticed that surprisingly few consultants know the difference between SQL Server Enterprise Edition and SQL Server Standard Edition, and even fewer use the...