By Joe Lax – When I started using SQL Server in version 4.2, backups were relatively simple. There were only two possibilities: a full backup or a transaction log backup. Starting with SQL Server 7, additional choices have proliferated. You now have four ways to back up your database.
Tag: sql server
Best SQL Server Performance Tuning Tips
As you can imagine, it is not always easy to know which tips might help boost your server’s performance the most, as each database and application is different.But there are some basic performance tips that generally can be considered critical to the performance of all database applications,
Tips from the SQL Server MVPs, September 2001
The SQL Server MVPs offer tips about detecting connection blocks, using sp_depends versus Enterprise Manager Display Depandencies windows, using SQL Server to manage resultset paging, and more.
Embedded Windows and CE .NET Subject of Workshop
At a workshop last month in San Jose, California, Microsoft unveiled the next generation of Microsoft’s Embedded Windows strategy, featuring both Windows XP Embedded (XPe) and a revised version of the Windows CE OS called CE .NET. XPe replaces both Windows NT 4.0 Embedded and a version of Win
Accessing Data From SQL Server
By Subhagata Swarnakar – Among the many things that are changing with .NET is data access. Under the .NET Framework, data access is handled by a set of classes called ADO.NET which are essentially an augmentation of the existing ActiveX Data Objects (ADO).
Meta Data Services Architecture
Microsoft® SQL Server™ 2000 Meta Data Services architecture is based on a set of integrated components. Key components are summarized in the following list and presented in a subsequent diagram.
SQL Commands
by James Crowley – SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly, MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access or anything else, at some stage you will need to know SQL. SQL, or Structured Query Language gives you complete control ov
Upsize Jet Crosstab Queries
by Roger Jennings – Crosstab queries have been a primary selling point for Access since Microsoft released version 1.0 in 1993. A multitude of Visual Basic developers depend on Access’ Crosstab Query Wizard to create persistent QueryDef objects or as a helper for generating Jet crosstab SQL statemen
Flawed Patch Pulled by Microsoft
By Thor Olavsrud – Microsoft Corp. pulled a patch to a security vulnerability off its public Web site after system administrators reported errors loading the patch onto their systems. After receiving reports of the flawed patch, the Microsoft Security Response Center said it would work to cor
Saving on SQL script time
IT-Map International of Wheeling, Ill., launched its dbPAL toolkit at the Borland Conference in Long Beach, Calif. The dbPAL technology provides a suite of tools linked by a user interface that uses a drag-and-drop, icon-based approach instead of having to write SQL scripts, IT-Map said.