Microsoft SQLCAT ISV Program Management Team
SQL Server offers an option to asynchronously populate API created keyset and static server cursors...
Date: 07/29/2009
Recently, an ISV I work with ran into an interesting problem with Filtered Indexes. The application...
Date: 06/29/2009
Recently I worked with a partner who was seeing some interesting behavior. Upon rebuilding their...
Date: 05/18/2009
SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.
An ISV recently found an anomoly in their implementation of a "drop table partition" function which...
Date: 04/10/2009
JDK APIs for Class “java.util.Date” and “java.sql.Timestamp” (subclass of Date) including...
Date: 03/26/2009
In one of our recent lab tests we were surprised to see blocking occur on a table that did not...
Date: 02/02/2009
SQL Server 2008 introduced what we call the Management Data Warehouse. The Management Data Warehouse...
Date: 01/29/2009
Using parameterized queries is a well known SQL Server Best Practice. This technique ensures caching...
Date: 11/26/2008
SQL Server 2008 : new binary – hex string conversion functionality can dramatically improve related query performance by orders of magnitude.
In previous SQL Server releases it wasn’t possible to convert binary data to string characters in...
Date: 10/31/2008
When it comes to creating composite indexes there are two questions I get asked most often by the...
Date: 09/26/2008
I have been asked by many customers and partners, especially those migrating from Oracle, this...
Date: 08/22/2008
NOTE: the code in this BLOG is TSQL instead of ODBC calls. Since ODBC can be hard to understand and...
Date: 07/11/2008
For many ISVs that run into issues at customer sites it is sometimes difficult to isolate underlying...
Date: 06/26/2008
Recently many customers of an ISV I work with, reported intermittent connectivity issues when...
Date: 05/27/2008
In SQL Server 2008 Microsoft has introduced a number of new date and time data types. One of these...
Date: 03/18/2008
You have probably heard many times, from different sources, that as a best practice; avoid using...
Date: 03/18/2008
SQL Server 2008 has a new feature called Filestream, which allows you to save large binary files in...
Date: 03/06/2008
Did you know that SQL Server 2008 is right around the corner, and that the SQL development team has...
Date: 02/25/2008
When SQL Server has an optimal index that satisfies the search predicates of a query the optimizer...
Date: 06/29/2007
Please have a look at four new Best Practices Articles SQL Server 2005 Predeployment I/O best...
Date: 06/05/2007
With 64-bit servers becoming more mainstream and SQL Server customers running more deployments on...
Date: 04/30/2007
Upgrading to SQL Server 2005 has many benefits . As we look back at the past year and the deployment...
Date: 03/23/2007
Did you know there is a great place to get real-world best practices for SQL Server 2005:...
Date: 02/08/2007
Many applications have a functional requirement for the underlying database to have a case-sensitive...
Date: 01/04/2007
Imagine a customer using an ISV application that stores certain product information in a...
Date: 12/01/2006
Many ISVs and ISV customers often have a need to duplicate their database server in entirety onto...
Date: 10/17/2006
ISV applications today often require international support. Migrating an existing non-Unicode...
Date: 07/07/2006
Many ISV applications use ODBC API Server Cursors. One source of developer confusion when coding and...
Date: 06/23/2006
Perils of NULL usage: I know there is a religious war about the use of NULLs and I don’t want to go...
Date: 05/30/2006
A few customers and ISVs who’ve applied SQL Server 2000 Service Pack 4 (SP4) have observed...
Date: 05/18/2006
Problem: When I analyzed a performance problem in an ISV data warehouse solution running on SQL...
Date: 05/11/2006
SQL Optimizations – A well concealed transform that can cut that much needed millisecond out of your query.
SQL Server Optimizer is full of surprises… Optimizer uses many transformations to find the best...
Date: 05/05/2006
SQL Server 2005 SP1 is now generally available for download via the web at:...
Date: 04/20/2006
Problem: When I was design/performance reviewing an ISV ODBC application, I turned on SQL Server...
Date: 03/24/2006
Hi SQL Server Community! Did you know that the SQL Server Product development team has a team of...
Date: 03/15/2006