Now that the new year has started, it’s time for the “resolutions/looking forward to” type of post.
Resolutions
Resolution #1
I will continue to write articles. Looking at my statistics and the number of comments, I know that the articles are being appreciated. Which is good to know because they take quite some time to write.
It’s been a while since I’ve written one, because I’ve been occupied on other tasks. Such as the following. I’m cooperating in the creation of a book on Master Data Services, as Technical Reviewer. If you’re interested in that subject, keep an eye on this blog. Once it’s published I’ll make a post about it!
To finish this resolution, here are the most popular articles in my Top 10 of 2010. At number one, still an article that I wrote back in 2008: Calling a web service from SQL Server 2005. I have a feeling that this will be different next year, because two other posts have pushed it to the third spot when looking at “last month” statistics.
A lot of people seem to struggle with the Windows Authentication in IIS 7.5, because that one is at number two.
At number three finally the first real article written in 2010: Retrieving Data From Excel.
Can you guess what posts are pushing the web services article from its number one position?
Other posts that I have in the top 10 are my script to list all SSIS packages deployed on the Integration Server, my post about SSRS 2008 and SSL, and my article showing some Pie Chart Techniques.
Resolution #2
Erm, wasn’t the first one enough? Well, besides writing articles and shorter blog posts I’ll also keep helping you guys out on the online forums, I will keep posting answers to every question that I get on my blog, and I will even keep answering the occasional personal email that I receive.
Resolution #3
Last but not least: as a Core Member of the Belgian SQL Server User Group, I’ll keep participating in the organization of great events, such as SQL Server Day!
Looking Forward To
SQL Server 2011
I’m definitely looking forward to the next release of SQL Server, currently known as Denali!
Integration Services has gotten some nice improvements to make the developer’s life easier. Finally CTRL-Z actually does something!! If you weren’t aware yet, you can already try this out by downloading the first CTP.
What I’m also quite interested in is known as Apollo, a column-based query accelerator. I’m curious to see if the queries will perform ten times faster, as claimed.
What else? Well, the BI Semantic Model (BISM) seems to be quite promising as well. The SSAS team has used the Vertipaq technology, which you may already have heard of when reading about PowerPivot, and integrated it into a new engine for SSAS databases. So in 2011 you can actually install two different instances of SSAS: one running in the old OLAP mode, and one running in BISM mode. The OLAP engine still receives MDX queries, and the new server understands DAX!
And the last feature to which I’m looking forward to is Data Quality Services! I’m quite sure that it will be useful in the context of loading data warehouses.
Conclusion
Happy New Year to all of you out there!!!
References
Top 9 New Features of SQL Server "Denali"
Analysis Services – Roadmap for SQL Server “Denali” and Beyond







