Browse by Tags
All Tags »
SQL Server (
RSS)
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...
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...
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...
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!
"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...
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...
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:...
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...
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...
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...
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...
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"...
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.
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...
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 »