Searching and Sorting Strings in Oracle11/20 Steve Callan discusses what takes place inside the Oracle database when you're searching for something "LIKE" the value of interest. How does Oracle approach the problem of determining if the string 'ABCD' appears in the string 'ABCABDABCDAB' and if it does, how many times?
Preparing To Upgrade Access Tables to SQL Server 2005/200811/19 Garry Robinson discusses some of the subtleties that you can apply to your database tables prior to upsizing your tables to SQL Server. In this article, I will show you how to fix up some of your Access backend before you make the conversion.
Microsoft Windows PowerShell and SQL Server 2008 AMO11/18 The first installment of this series illustrating the power of Windows PowerShell in conjunction with SQL Server 2008 demonstrates how to install and use a simple PowerShell command and a simple AMO command.
WF SQL Tracking Service By Jeffrey Juday
Published November 14, 2008
Learn how to incorporate the SQL Tracking Service into your WF development.
Intro to VSTS-DB Edition By Jeffrey Juday
Published June 26, 2008
See how Microsoft Visual Studio 2008 Team System - Database Edition makes creating and using database functionality easy for .NET developers!
Intro to Databases By Bill Hatfield
Published July 2, 2008
New to databases? Start by learning the basic terminology.
Access Database By Helen Bradley
Published June 2, 2008
Learn how to create a database as well as a report and query to go along with it.
Microsoft to let DBAs manage pools of SQL Server databases11/20 At a conference for users of its SQL Server database on Wednesday, Microsoft Corp. officials demonstrated an upcoming tool that will puportedly enable database administrators to manage hundreds of database servers at a time.
Microsoft Demos New SQL Server Features at PASS11/19 Microsoft today previewed the ability to centrally manage applications and resources in the planned upgrade of SQL Server, code-named "Kilimanjaro."
Quick Table and Index Size Script This script quickly returns table and index disk space and row counts for all tables in the current database.
Script to Display Current SQL Activity A simple stored procedure for SQL Server 2000 (should work on SQL 7 as well) that lists users (like sp_who), locks (like sp_lock), and the input buffers of blocked and blocking users.
BETWEEN VALUES While using between operator, only values in ascending order are accepted. If values
in descending order are given, you get no rows. However, if you use >= and <= operators, you have the privilege to use the range of values either in ascending order or descending order.
