SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.
Review of the MeasureUp test preparation serivce actually used by the author for the SQL Server 7 Design exam(70-029).
Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.
SQL Server 7 has a number of bugs that occur on multi-processor machines. This article presents a concise listing of these bugs.
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.
By Steve Jones
An interesting AI experiment here with Copilot from GitHub in handling some code I...
SQL is essential for modern businesses and applications that rely on data. It's a...
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers