Microsoft has launched the F# Developer Center Here you can learn everything about Microsoft’s functional programming language F# (pronounced F sharp). There are links to forums, blogs, projects on codeplex, code gallery samples, videos and much more. Also check out the Getting Started with F# section, here you can download the latest F# CTP and three sample chapters of the Expert F# book are also available for previewOriginal post blogged on b2evolution.

Posted by SQLDenis at Wed, 03 Sep 2008 20:06:34 -0600 - 10 replies

Yes it is true, Django 1.0 has been released today. Here is a part of the announcement: No, you’re not hallucinating, it’s really here. Around three years ago, Adrian, Simon, Wilson and I released some code to the world. Our plan was to hack quietly on it for a bit, release a solid 1.0 release, and then really get the ball rolling. Well. What happened, of course, was that an amazing community sprung up literally ...

I have decided to do a little blogpost with some stats. These stats are from June 1st until August 31st 2008 Browsers First we will take a look at the browsers. as you can see FireFox is the most used browser with 55%. I wonder how Google Chrome will do, will it take market share from Internet Explorer or from Firefox(or both)? Browser %visits Firefox 55.41% Internet Explorer 39.04% Opera 2.96% Safari 1.84% Mozilla 0.45% ...

Posted by SQLDenis at Sat, 30 Aug 2008 08:37:30 -0600 - 0 replies

You want to quickly find out what the recovery model is for your database but you don’t want to start clicking and right-clicking in SSMS/Enterprise Manager to get that information. This is what you can do, you can use databasepropertyex to get that info. Replace ‘msdb’ with your database name tsqlLine number On/Off | Show/Hide | Select allSELECT DATABASEPROPERTYEX(‘msdb’,‘Recovery’)Code is hidden, SHOW What if you want it for all databases in one shot? No problem ...

Posted by SQLDenis at Fri, 29 Aug 2008 12:56:22 -0600 - 5 replies

Adam Machanic created an item on connect explaining how LINQ to SQL queries involving strings cause SQL Server procedure cache bloat If an application is using LINQ to SQL and the queries involve the use of strings that can be highly variable in length, the SQL Server procedure cache will become bloated with one version of the query for every possible string length. For example, consider the following very simple queries created against the Person.AddressTypes ...

Take a look at this query. tsqlLine number On/Off | Show/Hide | Select allSELECT * FROM ( SELECT customer_id, ‘MTD’ AS record_type, COUNT(*), SUM(…), AVG(…) FROM payment_table WHERE YEAR(payment_dt) = YEAR(GETDATE()) and MONTH(payment_dt) = MONTH(GETDATE()) GROUP BY customer_id) MTD_payments UNION ALL ( SELECT customer_id, ‘YTD’ AS record_type, COUNT(*), SUM(…), AVG(…) FROM payment_table WHERE WHERE YEAR(payment_dt) = YEAR(GETDATE()) GROUP BY customer_id) YTD_payments UNION ALL ( SELECT customer_id, ‘LTD’ AS record_type, COUNT(*), SUM(…), AVG(…) FROM payment_table) LTD_payments ...

Posted by SQLDenis at Wed, 13 Aug 2008 08:25:06 -0600 - 4 replies

Which books should you read/buy when you are a programmer? I have listed 5 books that have helped me a lot. The books that I have chosen are not specific to any language although some of the books have examples in one language only. Design Patterns has examples in smalltalk and C++ but since the code is not very complicated you should have no problem converting it to your language of choice. I have included ...

Posted by SQLDenis at Fri, 18 Jul 2008 20:11:03 -0600 - 0 replies

Posted by SQLDenis at Thu, 17 Jul 2008 04:13:03 -0600 - 4 replies