How about this: News that your product has reached $1 billion in annual sales? Now that's a milestone worth celebrating. Ask Steve Murchie he's Microsoft's group product manager for SQL Server Marketing, and Microsoft SQL Server has joined the ranks of products that rake in more than $1
Tag: sql server
Stored Procedures
The use of stored procedures is the one area where the Command object comes into its own. A stored procedure (or stored query as it’s sometimes called) is a predefined SQL query stored on the database. So why should we create and use a stored procedure instead of just creating a SQL string on the fl
SQL Server 7.0 Undocumented Stored Procedures
by Alexander Chigrik – In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 7.0.
MySQL vs. itself
Companies at loggerheads over MySQL envision future partnership. The dispute between the creator of MySQL and a MySQL vendor has escalated into a legal battle. Still, both say they are so committed to the technology that they are open to reconciliation.
Inserting records into the Database with Java Servlets
An article on inserting records into the database with Java Servlets. Every step from establishing a Connection to executing the SQL query is explained in detail.
MS poised to switch Windows file systems with Blackcomb
By Jon Honeyball – From a technical perspective, the changes are quite profound. They focus on four main areas: Active Directory, SQL Server, Exchange Server and then the file system itself. As you will see, there is a clear interweaving of the changes to both BackOffice products, and to the base OS
Using VB and ADO to return and update Record Set based XML
By Sean Grimaldi – This article is about making the most of ADO and XML until the complete Visual Basic.net, including ADO.net, becomes available. This article is focused on how you, as a developer, can use ADO and XML today; and get valuable skills that apply to Visual Basic.net.
SQLClean™
If database object bloat is the problem, SQLClean is the solution. Your database may have many stored procedures, tables and views that aren't being used anymore but unless you determine which of your objects fall into this category you will be stuck with them forever.
A True .NET Server?
By Michael Otey – The Microsoft Servers Web site (http://www.microsoft.net/servers) lists SQL Server 2000 as one of the company's new .NET Enterprise Servers. How can this be, considering that Microsoft developed and released this latest version of SQL Server before it launched its recent .NET c
Sample chapter from Beginning SQL Programming
This introductory chapter covers topics that students usually ask in the first hour of classes; essentially, just what do we mean by SQL? We start by explaining what SQL is and also what it is not, and we provide a brief overview of the history of the language. We'll also clarify some confusing