Johan Åhlén

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

Browse by Tags

All Tags » T-SQL (RSS)
SQLug.se challenge 2010 - the Swedish national championship for SQL Server developers
The Swedish national championship for SQL Server developers, SQLug.se challenge 2010 , is now finished. The competition has been running on the Swedish SQL Server User Group's website, but I publish the competition problem also on my blog in case...
Minesweeper in T-SQL
Who said that coding T-SQL should not be fun? Minesweeper is a real old classic (that's still being shipped with Windows). Truly creative of Auke Teeninga to implement Minesweeper in T-SQL... Keep on playing!
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:...
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...
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...
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.
99 bottles of beer
The website 99 bottles of beer shows how to write the lyrics of the song, with the same name, in about 1300 different programming languages. I've now made a contribution written in SQL. Here's the lyrics of the song: 99 bottles of beer on the...
Posted: Oct 09 2009, 03:45 PM by jahlen
Filed under: , ,
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...