December 17, 2008

SQL Server versions

Posted in SQL Server at 11:11 by Niklas

This post is an attempt to summarize the available versions of SQL Server with Service Packs, Cumulative updates, etc.

SQL Server 2008 R2
 10.50.1092  Microsoft SQL Server 2008 R2 CTP2 (aug)
10.50.1352  Microsoft SQL Server 2008 R2 CTP3 (nov)
10.50.1600  Microsoft SQL Server 2008 R2

SQL Server 2008 (Codename: Katmai)
10.0.1075    Microsoft SQL Server 2008 CTP4 (nov)
10.0.1300    Microsoft SQL Server 2008 CTP5 (feb)
10.0.1442    Microsoft SQL Server 2008 RC0
10.0.1600    Microsoft SQL Server 2008
10.0.1763    Microsoft SQL Server 2008 CU1
10.0.1779    Microsoft SQL Server 2008 CU2
10.0.1787    Microsoft SQL Server 2008 CU3
10.0.1798    Microsoft SQL Server 2008 CU4
10.0.2531    Microsoft SQL Server 2008 SP1
10.0.2710    Microsoft SQL Server 2008 SP1 CU1
10.0.2714    Microsoft SQL Server 2008 SP1 CU2
10.0.2723    Microsoft SQL Server 2008 SP1 CU3
10.0.2734    Microsoft SQL Server 2008 SP1 CU4
10.0.2746    Microsoft SQL Server 2008 SP1 CU5

SQL Server 2005 (Codename: Yukon)
9.00.608      Microsoft SQL Server 2005 Beta 1
9.00.852      Microsoft SQL Server 2005 Beta 2
9.00.1399    Microsoft SQL Server 2005
9.00.2029    Microsoft SQL Server 2005 SP1 Beta
9.00.2047    Microsoft SQL Server 2005 SP1
9.00.2153    Microsoft SQL Server 2005 SP1 rollup
9.00.3042    Microsoft SQL Server 2005 SP2
9.00.3050    Microsoft SQL Server 2005 SP2 GDR
9.00.3152    Microsoft SQL Server 2005 SP2 CU1
9.00.3175    Microsoft SQL Server 2005 SP2 CU2
9.00.3186    Microsoft SQL Server 2005 SP2 CU3
9.00.3200    Microsoft SQL Server 2005 SP2 CU4
9.00.3215    Microsoft SQL Server 2005 SP2 CU5
9.00.3228    Microsoft SQL Server 2005 SP2 CU6
9.00.3239    Microsoft SQL Server 2005 SP2 CU7
9.00.3257    Microsoft SQL Server 2005 SP2 CU8
9.00.3282    Microsoft SQL Server 2005 SP2 CU9
9.00.4035    Microsoft SQL Server 2005 SP3

SQL Server 2000 (Codename: Shiloh)
8.00.194     Microsoft SQL Server 2000
8.00.384     Microsoft SQL Server 2000 SP1
8.00.534     Microsoft SQL Server 2000 SP2
8.00.760     Microsoft SQL Server 2000 SP3
8.00.760     Microsoft SQL Server 2000 SP3a
8.00.818     Microsoft SQL Server 2000 SP3 w/ Cumulative Patch MS03-031
8.00.2039  Microsoft SQL Server 2000 SP4

SQL Server 7.0 (Codename: Sphinx)
7.00.623     Microsoft SQL Server 7.0
7.00.699     Microsoft SQL Server 7.0 SP1
7.00.842     Microsoft SQL Server 7.0 SP2
7.00.961     Microsoft SQL Server 7.0 SP3
7.00.1063  Microsoft SQL Server 7.0 SP4

SQL Server 6.5 (Codename: Hydra)
6.50.201     Microsoft SQL Server 6.5
6.50.213     Microsoft SQL Server 6.5 SP1
6.50.240     Microsoft SQL Server 6.5 SP2
6.50.258     Microsoft SQL Server 6.5 SP3
6.50.281     Microsoft SQL Server 6.5 SP4
6.50.415     Microsoft SQL Server 6.5 SP5
6.50.416     Microsoft SQL Server 6.5 SP5a
6.50.479     Microsoft SQL Server 6.5 SP5a Update

SQL Server 6.0 (Codename: SQL95)
6.00.121  Microsoft SQL Server 6.0
6.00.124  Microsoft SQL Server 6.0 SP1
6.00.139  Microsoft SQL Server 6.0 SP2
6.00.151  Microsoft SQL Server 6.0 SP3

SQL Server 4.21a
SQL Server 4.21a Service Pack 4

November 16, 2008

SQL8r at Øredev

Posted in Fun, SQL Server, WinForms at 21:40 by Niklas

SQL8r takes you upwards

The new database andministration and performance tool SQL8r (”Escalator”) is now available for download.

Check the homepage, sql8r.se, for more information.

And don’t miss it at Øredev.

January 1, 2007

New take on SQL Server assemblies

Posted in SQL Server at 20:39 by Niklas

Once upon a time I wrote about a problem I had with SQLCLR. After I installed SP1 the problem was kind of solved, at least I got a better and relevant error message. The problem was that my DLL could not find System.Web which I accidentally had a reference to. After load System.web and it’s dependencies into SQL Server (which was possible), of removing the dependency (better solution :) ) the code runs. Now I shall continue working with it and see what happens.
Speaking of SQL Server, it pleasing to see all the thing that are happening around it, SQL Server Mobile Edition, Feature Pack, Report Pack, SP2 already on its way etc. Is it somehow leading towards WinFS?

Cert summary 2006

Posted in SQL Server, WinForms at 17:37 by Niklas

During 2006 I took 4 Microsoft certs. It all started when I started to work as a consultant in the Microsoft Dynamics team in Denmark, on the Dynamics NAV product, which was previously named Navision and was developed by a danish company that was acquired by Microsoft some years ago. Therefor I had to start commute every day from Sweden, giving me a lot of free time on the train. So I started to read Andrew Troelsen’s book Pro C# 2005 and the .NET 2.0 Platform, Third Edition, a rather talkative book that covers quite a lot of ground for the Application Development Foundation cert and some of the Windows-Based Client Development cert, and some more I guess. After checking the study guide and reading up on MSDN I was set to become a Technology Specialist, the step before Professional Developer. To become a PD you need one additional exam that two of my co-workers said the took without additional studying , so I tried as well and can confirm that I don’t know how to study for it, if you don’t have the required experience.

And after the exams are completed you get the rewards: a welcome kit and the right to use these images from the MCP site :)

Once you get into the habit of studying for exams, and gain some knowledge of how the tests work it’s just to continue…

March 12, 2006

SQLCLR behaviour

Posted in SQL Server at 21:33 by Niklas

After reading a bit in Pro SQL Server 2005 I got the idea to try Keith Brown’s AppDomain snooping demo from PDC in SQL Server 2005. The demo demonstrates how you can use a little managed C++ code to enable one ASP.NET application running in IIS to look into other AppDomains in the server and for example dump the cache of any other ASP.NET application running on the server.

I know it’s not supposed to work in .NET 2.0, but I thought it would be fun and educational to try, both security wise and SQLCLR wise. The demo relies on two assemblies, one in C++ (AppDomLooker) that uses operations that prevents it from being compiled to CIL (or MSIL as the SQL Server calls it), and one in C# (PilferHelper) that references the C++ assembly. If I try to ”CREATE ASSEMBLY PilferHelper ... ” SQL Server tries to locate the referenced assembly automatically, but fails. If I manually ”CREATE ASSEMBLY AppDomLooker ... ” that works great, but when I look in sys.assemblies it has ”processorarchitecture=x86” as opposed to regular C# assembles that has ”processorarchitecture=msil”. I guess that is why SQL Server cannot recognize it as the referenced assembly.

I’m not sure how it’s supposed to work, but I think it’s strange that I can load the assembly and then not reference it. The potential reason for it not to work should be security, but then the error message should mention it…

Feel free to download my sample and try.

Maybe some SQL Server dude can enlighten me?

February 13, 2006

Analysis Services 2005

Posted in SQL Server at 23:27 by Niklas

The coverWhile between projects I got the chance to study Analysis Services 2005 for a while and bought this book: Applied Microsoft Analysis Services 2005 : And Microsoft Business Intelligence Platform. One of the few book that are (were) actually out, but it a good, thick and heavy book in many ways. I haven’t gotten through it yet but it seems to cover everything in lots of detail. Sample chapters, source code and more is available at this page. Check out the author and his own publisher (self-owned)

Free SQL Server training

Posted in SQL Server at 22:45 by Niklas

Check out the Microsoft Learning course catalog for some free courses. But hurry, they will probably not be free for long… probably just until the labs are updated.