April 2006 - Posts

• SQL 2005 Reporting Services - Date parameter problem

  So I have been developing using SQL reporting services for a while now no real problems per se until my IT pro built my new report server. He forgot to set the regional settings to English (Australia) so when it came time to enter any date parameters, it defaulted to US style  (MM/DD/YYYY). I think I tried every thing possible to get back to Australian (including all the registry mods), and was at a loss. It took me weeks to get him to build the server initially, so getting a rebuild was going to be painful. One of my design guidelines I have set is that the report language should be set to Australian, so I was getting the parameters entered in US fromat, but the report was displaying correctly. And I generally show the inputted parameters on the report. Then late one night it dawned upon me... the main report form is an aspx page, so why dont i set the LCID on it. On my dev pc, the report.aspx page can be found in "C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\Pages" I modified the page directive to include LCID="3081" and voila, suddenly I had an answer that google could not give me. Posted Apr 28 2006, 06:44 AM by alastair with no comments

• SQL Server 2005 Books Online April Release

  This week saw the release of SQL Server 2005 Books Online - April 2006. Download it here "Beginning with the April 2006 update, SQL Server 2005 Books Online reflects product upgrades included in SQL Server 2005 Service Pack 1"     Posted Apr 27 2006, 06:12 AM by alastair with 1 comment(s)

• SQL 2005 Service patch released

  Service Pack 1 for Microsoft SQL Server 2005 has been released. Download it here Somethings to note - It stops the services first, and then asks to authenticate against them. It took about 40 minutes to install.   Alastair     Posted Apr 23 2006, 11:02 PM by alastair with no comments

• Code from Perth DotNet user group session - CACHING

  In the latest instalment of the ASP.NET 2.0 presentations I have been giving, and will continue to do, for the Perth DotNet user group, the topic was CACHING.   I covered Page level caching, Partial Page caching, Database caching and the cache API.   We had a good turnout and there were many who walked away with some great ideas on how they can improve their sites performance. Interestingly I was surprised at how few realised caching applies to Web services as well.   I have posted the source code from the night HERE for all. I have used the Northwind database, and in particular, the customers table for the database caching section. Posted Apr 19 2006, 12:01 AM by alastair with no comments

• Atlas - My first steps

  I was starting to put together my content for the next presentation at the Perth .Net user group (www.perthdotnet.org), when I stumbled across Atlas (http://atlas.asp.net/Default.aspx?tabid=47). It is amazing how this team has simplified AJAX,and within minutes (well less than 30) I had a demo running, which consumes a webservice with each key press inside a text box, and returns the results. I thought I would put the demo (http://www.softteq.com/demo/ajax) up to make explaining  AJAX easier. If you check out the docs on the ATLAS site, you see all the code to make this happen. Al Posted Apr 10 2006, 06:35 AM by alastair with no comments