MVP Erland Explores SQL Server Performance Concepts

by Roopesh Shenoy Follow 0 Followers on  Jul 13, 2011

In "Slow in the Application, Fast in SSMS?", SQL Server MVP, Erland Sommarskog, explores the various things that affect Query Plan, compilation of Dynamic SQL and other things that ultimately affect your SQL Server Database Performance. He covers various concepts and scenarios like parameter sniffing, query plan caching, Blocking, saved settings, issues with linked servers and more.


DbFit 1.0 With Enhanced Querying Capabilities and User Docs

by Mike Bria Follow 0 Followers on  Mar 17, 2008 2

Gojko Adzic has recently announced the version 1.0 release of DbFit, his popular FIT/FitNesse extension used for practicing TDD on database code.


Microsoft Ups Their Support for PHP

by Jonathan Allen Follow 611 Followers on  Nov 27, 2007

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.


SQL Server 2005 Best Practices Analyzer Preview

by Jonathan Allen Follow 611 Followers on  Feb 28, 2007

A CTP of the SQL Server 2005 Best Practices Analyzer is now available. This tool can be thought of as FXCop for SQL Server.


Visual Studio for Database Professionals Released

by Jonathan Allen Follow 611 Followers on  Dec 07, 2006

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.


SQL Server Hosting Toolkit CTP 1 Released

by Jonathan Allen Follow 611 Followers on  Oct 30, 2006

Microsoft has released the first CTP of its SQL Server Hosting Toolkit. This toolkit is designed to provide support for companies using a hosted SQL Server.


Upgrading SQL Server - xp_execresultset

by Jonathan Allen Follow 611 Followers on  Oct 21, 2006

SQL Server 2000 had a useful, though undocumented, function called xp_execresultset. Unfortunately for those currently using it, SQL Server 2005 has dropped this feature.


English Query Discontinued in VS 2005

by Jonathan Allen Follow 611 Followers on  Oct 10, 2006 1

English Query, a tool that translated queries written in English into SQL queries, has been discontinued.

Login to InfoQ to interact with what matters most to you.

Recover your password...


Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.


More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.


Stay up-to-date

Set up your notifications and don't miss out on content that matters to you