InfoQ Homepage SQL Server 2005 Content on InfoQ
-
Implementing NOLOCK with LINQ to SQL and LINQ to Entities
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.
-
SQL Server Data Services: Microsoft's Answer to Amazon S3
Microsoft has announced SQL Server Data Services (SSDS) at MIX08. Being a storage service on the web, SSDS is Microsoft's Amazon S3 competitor.
-
Database Virtualization - Is it worth it?
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.
-
SQL Server Best Practices Analyzer to be Integrated into SQL Server 2008
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.
-
Post-VS 2008-Technology: LINQ to XSD and LINQ to Stored XML
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.
-
Microsoft Ups Their Support for PHP
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.
-
Recursive Selects using Common Table Expressions
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.
-
Book Excerpt and Review: Hitchhiker's Guide to Visual Studio and SQL Server
With SQL Server 2000's hitting its end of life date next April, many shops that have been delaying the upgrade to SQL Server 2005 need to start looking at it seriously. This is why we have chosen to review the seventh edition of William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server.
-
Using SSIS in a Team Setting
Jamie Tomson talks about his experiences trying to use SQL Server Integration Services in a team environment.
-
SQL Server Best Practices Analyzer No Longer Tied to Service Packs
According to Paul Mestemaker, the SQL Server Best Practices Analyzer is no longer being tied to SQL Server Service Pack releases. This announcement is being made in conjunction with the first production release of the tool.
-
Deny Execute on Assembly Doesn't
According to Microsoft's SQL Programmability & API Development Team Blog, the Execute permission for CLR assemblies actually has no effect. To reduce confusion over this, the ability to grant execute permissions to assemblies has be removed from SQL Server 2005 SP 2.
-
SQL Server 2005 SP 2 Upgrade Warning
According to the SQL Server Manageability Team, there is a bug in the maintenance plan engine that may cause it to delete historical information too soon.
-
SQL Server 2005 Best Practices Analyzer Preview
A CTP of the SQL Server 2005 Best Practices Analyzer is now available. This tool can be thought of as FXCop for SQL Server.
-
SQL Server Now Supports Vista
With the release of Service Pack 2, SQL Server 2005 finally has full support on Vista. This includes SQL Server Express, which had serious difficulties running on the new operating system. Several new features are also included in this release.
-
Visual Studio for Database Professionals Released
Microsoft has developed what they call "tools for building SQL databases in a managed project environment with support for versioning, deployment, unit testing, refactoring, and off-line SQL development." These tools, released under the name Visual Studio for Database Professionals, claim to offer a way to develop databases in the same off-line fashion as traditional applications.