Visual studio feeds

All Visual Studio blogs in one place

Subscribe

Enter your email address:

Delivered by FeedBurner

Increase your website traffic with Attracta.com

Google+

Contact

Email:
Subject:
Message:
Anti-spam: How many eyes has a typical person?

Follow us on FB

Search

Microsoft SQL Server 2005 Builds

AddThis Social Bookmark Button
The following table lists all builds of SQL Server 2005 known hotfixes, service packs and KB articles that have been released by Microsoft.Quick Overview:CodenameRTM/Service PackBuild Number YukonRTM9.00.1399.06SP19.00.2047SP29.00.3042SP39.00.4035SP49.00.5000Microsoft SQL Server 2005 Builds Breakdown:BuildFile versionKB / DescriptionRelease Date9.00.53242005.90.5324.02716427 MS12-070: Description of the security update for SQL Server 2005 Service
Pack 4 QFEOctober 9, 20129.00.52962005.90.5296.02615425 FIX: “Msg 7359? error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updatedOctober 24, 20119.00.52952005.90.5295.0

Microsoft SQL Server 2000 Builds

AddThis Social Bookmark Button
The following table lists all builds of SQL Server 2000 known hotfixes, service packs and KB articles that have been released by Microsoft.Quick Overview:CodenameRTM SP1SP2SP3SP4Shiloh8.00.1948.00.3848.00.5328.00.7608.00.2039Microsoft SQL Server 2000 Builds Breakdown:BuildFile versionKB / DescriptionRelease Date8.00.23052000.80.2305.0983811 MS12-060: Description of the security update for SQL Server 2000 Service Pack 4 QFE: August 14, 2012August 14, 2012

Microsoft SQL Server 7.0 Builds

AddThis Social Bookmark Button
The following table lists all builds of SQL Server 7.0 known hotfixes, service packs and KB articles that have been released by Microsoft.Quick Overview:CodenameRTM SP1SP2SP3SP4Codename Sphinx7.00.6237.00.6997.00.8427.00.9617.00.1063Microsoft SQL Server 7.0 Builds Breakdown:BuildKB / DescriptionRelease Date7.00.1152948113 MS08-040: Description of the security update for SQL Server 7.0: July 8, 2008May 9, 20127.00.1149
may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0" href="http://support.microsoft.com/kb/867763/" target="_blank">867763 FIX: An access violation exception may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0June 1, 20067.00.1143830233 New Connection Events Are Not Recorded in SQL Server TracesOctober 25, 20057.00.1143

Microsoft SQL Server 2008 Builds

AddThis Social Bookmark Button
The following table lists all builds of SQL Server 2008 known hotfixes, service packs and KB articles that have been released by Microsoft.Quick Overview: CodenameRTM/Service PackBuild Number KatmaiRTM10.00.1600.22SP110.00.2531SP210.00.4000SP310.00.5500Microsoft SQL Server 2008 Builds Breakdown:BuildFile versionKB / DescriptionRelease Date10.00.58352007.100.5835.02814783 Cumulative update package 10 (CU10) for SQL Server 2008 Service Pack 3March 18, 201310.00.58292007.100.5829.0
title="2799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3" href="http://support.microsoft.com/kb/2799883" target="_blank">2799883 Cumulative update package 9 (CU9) for SQL Server 2008 Service Pack 3January 23, 201310.00.58282007.100.5828.02771833 Cumulative update package 8 (CU8) for SQL Server 2008 Service Pack 3November 19, 201210.00.58262007.100.5826.02716435 Microsoft Security Bulletin MS12-070October 9, 201210.00.57942007.100.5794.02738350 Cumulative update...(Read whole news on source site)

The 3rd day of the SDP

AddThis Social Bookmark Button
The 3rd day of the SDP was over and I want to thanks all the attendants.
my yesterday session was about C# 5 async and await. today I will have a full day tutorial on Rx and TPL Dataflow.
you can download the demo code and also the presentation for second and third days from here (the link is also having the demo code for today's sessions). anyway, I also want to recommend 2of yesterday session. if you were attend at the conference you should have
an access to the sessions video page.
first I want to recommend Ofir Makmal's session about .NET 4.5 CLR improvements. Ofir was talking about subjects like: Multi-core JIT Managed Profile Guided Optimization Auto-Ngen Background Server GC my favorite subject was Multi-core JIT. the following is a snippet for Multi-core JITing.
Code Snippet
static void Main(string[] args) {     ProfileOptimization.SetProfileRoot(@"C:\MyApplicationFolder");     ProfileOptimization.StartProfile("startup.profile"); }
my second recommendation is Manu Cohen-Yashar's session about...(Read whole news on source site)

Visual Studio 2012.3 (Update 3) “go-live” CTP is now available

AddThis Social Bookmark Button
I know it seems like 2012.2 just released (at least it does to me) but we’re already well into our schedule for 2012.3.  Today, we released the updates for both Visual Studio and Team Foundation Server.  This is the first “go-live” release in the 2012.3 line of CTPs – this means that you we’ve tested it to the point that we think you can install it in your production environment (we have in ours) and get help with any significant issues you encounter.  Our go-live process found 8 or 10 TFS bugs for Update 2.  We were able to
fix those for the final build and ensure everyone had a better experience.  We really appreciate your help finding the last few issues. As I mentioned in my Update 2 availability post – Update 3 is going to be very small compared to Updates 1 and 2.  For the most part it just contains bug fixes that have either been reported by customers or found in our own testing.  You can read the KB article to find a full list of fixes. Installing it should be relatively straight forward – for both VS and TFS, just...(Read whole news on source site)

Dealing With Case Sensitivity in OData Queries

AddThis Social Bookmark Button
If you are calling a OData service whether hosted via WCF or Web API (for us .NET folks, or some other hosting mechanism for other technologies), you will find out quickly that the queries may not be returning the expected results or even no results at all. Hopefully it didn't take you too long to jump over to SQL, run the equivalent TSQL query (that is if you own the service and back end), and realized you have a case sensitivity issue.

The solution is to use either of the following supported OData functions:
string tolower(string p0)


string toupper(string p0)
/>
What you should do to take the case sensitivity out of the equation so that you get all results back is to use either of the functions on the field name in question, similar to the query below:

http://localhost/MyService/api/odata/Locations()?$filter=State eq 'FL' and tolower(City) eq 'ft. myers'

Notice how the 'tolower()' function was used to allow all results to be displayed. This would ensure that results with either 'Ft. Myers' or 'FT. MYERS' or any combination thereof be returned.

For a list of all of the OData functions, see Section 4.5 of the following...(Read whole news on source site)

Home