Editor’s Note: Welcome to SQL Server Magazine’s monthly, Web-only series of SQL Server tips brought to you by the Microsoft SQL Server Most Valuable Professionals (MVPs). Microsoft introduced the MVP program in the 1990s to recognize...
In my July 19 commentary, I discussed Microsoft's Software Assurance (SA) program and how it might impact your ability to upgrade SQL Server (see the URL below). Because the October 1 transition date to SA is looming and Microsoft has made a few...
Have you checked out Microsoft Passport service? Passport is one of the core services for Microsoft .NET technology. Passport simplifies the sign-up and logon process for any of the Web sites that implement Passport technology. Passport works as...
You get what you pay for—usually. Fortunately, this rule has a few exceptions, and free SQL Server online support is one of them. You probably won't find a vendor that will provide free answers to your technical questions, but you can find many...
As Microsoft's latest OS, Windows XP, rolls toward completion, an interesting array of competitors and special-interest groups are attacking the company and its new product in attempts to prevent XP's October release. Also caught up in the turmoil...
What's the easiest way for me to retrieve a list of stored procedures that a named Windows NT login account owns and that Enterprise Manager displays? I want to wrap code around the list, run the code in Query Analyzer, then change the object...
The T-SQL SELECT statement is the primary tool for retrieving data from SQL Server, but SELECT also has several other interesting uses. Here are seven useful things that you can do with SELECT besides returning rowsets to your application...
I'm running SQL Server 7.0 Service Pack 3 (SP3). I developed an interface between Visual Basic (VB) 6.0 and Data Transformation Services (DTS) by using SQLNamespace, and I need to pass parameters between VB 6.0 and DTS. I know that DTS doesn't...