In the next month I’ll be speaking at two conferences, one in London, the DevWeek and another one at Neuss, the PASS European Summit.
At the DevWeek I’ll deliver a session created explicitly to give developers some insight on SQL Server development, so that when they have to deal with a database they can do the right thing just from the beginning. As a developer I learned at my expenses (looooong ago, in the around-2K golden years) that application performances are strictly related to database performance. And since a database can be (IMHO) seen as the fundaments of an application, the more it can be done correctly at the beginning, the more your application will be solid and fast.
SQL Server best practices for developers
http://www.devweek.com/sessions/conference1.asp
In Italy we created a specific course (from 2 to 4 days) upon this idea, and I can tell you that right from the start it was a big big big success, so we'll try to replicate that success in this session. I’m sure developers will love it!
After DevWeek, the month after, in April, I’ll also speak at PASS. One spotlight session will dedicated to SQL Server Development again, but in this case the focus will only be on how we approach the solution to a problem and how we write the query to solve it. I’ll show that “just” changing that approach – and thus also changing the query – we can make the query run at much higher speeds! It’s all about our mind, not the code.
Blazing Fast Queries: When Indexes Are Not Enough
http://www.sqlpass.org/summit/eu2010/Agenda/Spotlights/BlazingFastQueriesWhenIndexesAreNotEnough.aspx
The other session is specific for the BI guys, where I’ll not discuss architectures but I’ll focus engineering. Yes, I’ll try to make some order, defining some rules regardless the architecture and the methodology you want to follow, rules that will help to have a solid yet flexible (“adaptive”) solution:
Adaptive BI Best Practices
http://www.sqlpass.org/summit/eu2010/Agenda/ProgramSessions/AdaptiveBIBestPratices.aspx
So, see you there!