Develop Robust and Scalable Apps with SQL Server Data Services

submitted by wisemx 1 day, 5 hours ago

msdn2.microsoft.com — The Microsoft data platform is made up of a rich set of products and technologies for all types of data, from unstructured binary data on one end of the spectrum to highly structured online analytical processing (OLAP) cubes on the other. While these technologies address any application scenarios you may have, typically it involves an up-front investment of time and hardware resources before you are able to start coding your solution. read more...

add a comment | category: Database | Views: 6

Efficient Paging in SQL Server 2005

published 8 hours, 3 minutes ago, submitted by justin_etheredge 2 days, 11 hours ago

codethinked.com — Sure, SQL Server 2008 is getting ready to drop, but are you familiar with all of the new features that 2005 gave you? Or maybe you haven't used 2005, well, this is a good article to introduce to you several of the new features in SQL Server 2005. read more...

add a comment | category: Database | Views: 100

SQL Server 2008 to ship next week?

statisticsio.com — "Microsoft has told several large database shops to expect their final SQL Server 2008 bits this week. That means it's possible, in an ideal world, that the company will announce RTM (release to manufacturing) of the new database next week at the Microsoft Worldwide Partner Conference. (Microsoft is holding to its official "it'll ship in Q3" story.)" read more...

1 comment | category: Database | Views: 5

Showing some support for LINQ to SQL

codebetter.com — Great article detailing why LINQ to SQL deserves some attention particularly if you buy into the object oriented style of development or are currently working with an ORM such as NHibernate. read more...

add a comment | category: ADO.NET | Views: 188

How to Track Down Deadlocks Using SQL Server 2005 Profiler

simple-talk.com — It is irritating, sometimes alarming, for the user to be confronted by the 'deadlock message' when a deadlock happens. It can be a tiresome business to prevent them from occurring in applications. Fortunately, the profiler can be used to help DBAs identify how deadlocking problems happen, and indicate the best way of minimising the likelihood of their reappearance. read more...

add a comment | category: Database | Views: 3

New System.Data.SQLite with Experimental Support for LINQ

submitted by myokeeh 4 days, 14 hours ago

xiirus.net — A new version of System.Data.SQLite from sqlite.phxsoftware.com is available. read more...

add a comment | category: ADO.NET | Views: 6

Scale Cheaply - Sharding

codebetter.com — There are a lot of expensive ways to scale your database – all of which are highly touted by the big three database vendors because, well, they want to sell you all types of really expensive stuff. Despite what an “engagement consultant” might tell you though, most of the high-traffic websites on the web (google, digg, facebook) rely on far cheaper and better strategies: the core of which is called sharding. read more...

add a comment | category: Database | Views: 293

71-432 SQL Server 2008, Implementation and Maintenance

statisticsio.com — Good overview of the upcoming 71-432 SQL Server 2008 Implementation and Maintenance exam. With the constant stream of exams being pumped by Microsoft it's great to have an idea of what's coming down the pipeline. read more...

1 comment | category: Database | Views: 20