All content and news on InfoQ about SQL Server 2005
News about SQL Server 2005
- .NET
- Topics
- SQL Server
Version 1.0 of the Microsoft SQL Server 2005 Driver for PHP has been released, allowing greater interoperability between PHP and MS SQL 2005. The driver is available for download on MSDN, and the source code for the driver is available on Code Plex.
-
By Al Tenhundfeld
on Aug 05, 2008,
- .NET
- Topics
- Data Access
Scott Hanselman recently posted a really useful article on his blog covering the NOLOCK hint when using LINQ to SQL and LINQ to Entities. The problem is actually how to get the SQL generated by LINQ queries to use the NOLOCK hint as SQL developers are accustomed.
-
By Robert Bazinet
on Mar 21, 2008,
- .NET,
- SOA
- Topics
- SaaS
Microsoft has announced SQL Server Data Services (SSDS) at MIX08. Being a storage service on the web, SSDS is Microsoft's Amazon S3 competitor.
-
By Hartmut Wilms
on Mar 06, 2008,
- .NET,
- Architecture
- Topics
- Virtualization,
- Data Warehousing
Hosting server applications inside VM images is all the rage today. The ability to quickly move a virtual server from one machine to another as needs change is a big win for IT departments. But can this be applied to heavyweight systems like SQL Server? Conor Cunningham says no.
-
By Jonathan Allen
on Feb 12, 2008,
- .NET
- Topics
- Code Analysis,
- Data Access
Microsoft is looking to change how SQL Server is managed by incorporating the SQL Server Best Practices Analyzer into the core of SQL Server 2008. This new feature, known as the Declarative Management Framework, allows for proactive enforcement of database policies.
-
By Jonathan Allen
on Jan 23, 2008,
- .NET
- Topics
- .NET Framework
Today, Shyam Pather, Principal Development Lead on the Data Programmability Team at Microsoft, is giving a presentation on LINQ to XML: Visual Studio 2008, Silverlight, and Beyond at the XML 2007 Conference in Boston. He talks about the current and future technologies surrounding LINQ to XML.
-
By Hartmut Wilms
on Dec 05, 2007,
- .NET
- Topics
- Web Frameworks
PHP is a cornerstone of LAMP development. In an attempt to lure PHP developers off Linux and MySQL, Microsoft is beginning to offer deep support for PHP in IIS 7 and SQL Server.
-
By Jonathan Allen
on Nov 27, 2007,
- .NET
- Topics
- Data Access,
- SQL Server
Relational databases are great for storing most forms of structured data. The most notable exception is recursive data. Tree-like structures, essential for menus, normally require awkward stored procedures to efficiently return. SQL Server 2005 does have an answer though.
-
By Jonathan Allen
on Oct 05, 2007,