SQL Server, performance, data, analytics
I mentioned the first draft of this free ebook by fellow MVP Granville Barnett and Luca Del Tongo back in August. Well it’s now in its second edition. It is part of an effort to provide all developers with a core understanding of algorithms that operate on various common, and uncommon data structures.
Did you know that the free SQL Server 2008 Express with Advanced Services can run SQL Server Reporting Services reports on data on the local instance? You can use all the report definition features that you find in other editions of Reporting Services. For example, you can create drill-through reports, sub-reports, and parameterized reports that include charts, tables, matrices, and lists.
There are a few differences when compared to the full version of Reporting Services:
Whereas SQL Server 2005 Express Edition had a downloadable Toolkit containing Business Intelligence Development Studio (BIDS), which was required for creating reports for SQL Server Reporting Services, SQL Server Express 2008 with Advanced Services contains BIDS as part of its install. (Note: The Feb 2009 version of Books Online still states that it is a separate install). For more information, see the section “Reporting Services in SQL Server Express with Advanced Services” in Books Online.
The official SQL Server Express installation guide is here. The pre-requisite list is here: Hardware and Software Requirements for Installing SQL Server 2008
For ongoing SQL Express announcements, check out the SQL Express blog.
If you only have the vanilla version of SQL Express installed, there is also an express version of SQL Server Management Studio available for download.
Michael Feathers (Working Effectively with Legacy Code) has posted an interesting read, 10 Papers Every Programmer Should Read (At Least Twice) over at ObjectMentor. He gives a brief synopsis of each and why he thinks programmers should read them. I’ve read 4 of them previously and those were thought provoking. There are some interesting links in the comments as well.
TOPIC: Real World TDD with Rhys Campbell
DATE: Thursday, March 5th, 5:30pm
VENUE: Excom, Ground Floor, 23 Barrack Street, Perth
COST: Free. All welcome
Join us at the Perth .NET Community of Practice, to hear Rhys Campbell present on the essentials of TDD and how it encourages good software design as opposed to just having tests. Rhys will cover the differences between unit, acceptance and integration tests, why conventional unit test examples often do not work in the real world, what to test and what to mock, automating your tests, coding examples of how to use Mocks, Stubs, Fakes, Dummies and Spies… what are they and how do they help me.
The Tech SummerFest roadshow is coming to Perth, the week of 20th April.
What is it?
It’s a mini-TechEd type event, jointly sponsored by Portal Synergy, Wardy IT Solutions, AB Training and Microsoft. It includes a Technology Showcase and three concurrent tracks of training in current and upcoming Microsoft technologies. Here is the week’s schedule. This event is being run by Anthony Borton, Peter Ward, Richard Angus, Dave Glover and Andrew Coates.
I have a free ticket to the Technology Showcase day (Monday, 20th April) to giveaway at Thursday’s User Group meeting, courtesy of the organizers.
I just received a reply to a query I sent to the (Australian) Angus & Robertson online bookstore. Part of the (very quick) response that was unrelated to my query was quite surprising:
“Angus & Robertson is currently in the process of developing a completely new
website. The refreshed Angus & Robertson website will be available in April.
During the transition to the new website, customers will not be able
to purchase items via the Angus & Robertson website.” [my emphasis]
That seems really crazy to me. If losing 5+ weeks worth of online sales was not enough, what happens if their new web site project overruns? They lose more sales! I can only assume they don’t currently sell many books online…
Some excellent advice in this article, My stored procedure “best practices” checklist, posted by Aaron Bertrand.
“When developing stored procedures, there seems to be a lot of emphasis on “get it done fast.” Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out the window.”