Johan Åhlén

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

Browse by Tags

All Tags » SQL Server (RSS)
SQL Server Trace Flags - why and how to use them
Trace flags are very powerful settings that allow you to customize SQL Server behaviour. Most of the trace flags are undocumented in Books Online and there does not exist any official list of them. Some have been mentioned in Knowledge Base articles and...
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...
SQL Azure - why use it and what makes it different from SQL Server?
I've so far not seen any article on why anyone should use SQL Azure so I thought it is time someone writes about that. This article is an introduction to why you might be interested in a cloud database and a summary of the differences compared to...
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!
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
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...
More Posts Next page »