BT
rss

MVP Erland Explores SQL Server Performance Concepts

by Roopesh Shenoy 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 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 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 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 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 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 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 on  Oct 10, 2006 1

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

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2013 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT