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