databasejournal.com databasejournal.com

SQL Server DTS Designer

Prior to SQL Server 2000, the only way to back up or export databases from SQL Server to other databases was to use the bulk copy program. We all spent hours configuring scripts to do miraculous things using this cumbersome method. Then, when we finally mastered the art, SQL 7.0 was released with a GUI to accomplish automation that was both intuitive and simple to use. Microsoft called this interface Data Transformation Services...

databasejournal.com databasejournal.com

Restoring your Data 101

Now that your data is backed up, you will need to learn how to restore your data when it is applicable. You might want to restore your data because of a hardware failure or restore data to a backup or standby server. The reasons are endless but the most important thing is to be prepared. Remember that if you are recovering a database using the Simple Recovery Model, you can only restore to the last full backup. If you are using the...

databasejournal.com databasejournal.com

Backing up and Restoring Databases in SQL 2000

If you are a Database Administrator (DBA), I have no doubt in my mind that you have been called away from home, dinner, or just plain in the middle of the night to answer a page on a disaster with your database(s). In this field, it is the nature of the beast to get called away at the most inappropriate time. Aren't you glad you backed up your database(s)? Or, did you? In this article, we will introduce you to the different types of...

databasejournal.com databasejournal.com

Red Gate Software's SQL Backup

I recently had the opportunity to work with a new piece of software for my SQL Server backups. The product is called SQL Backup and it is made by Red Gate Software. With SQL Backup, you can perform the following: Compressed backups Perform faster online backups Encrypt SQL Server backups with 128 bit Rijndael encryption Command line interface Installing the tool is a snap. Simply run the SQLBackupSetup.exe and the Welcome...

databasejournal.com databasejournal.com

SQL Server Performance Monitor - Page 2

To start logging information: 1.  Expand Performance Logs And Alerts. 2.  Highlight Counter Logs. 3.  Right-click on Counter Logs and select New Log Settings, as shown in Figure C. Click for larger image Figure C. 1.  Enter a name and click OK. 2.  In the General tab, add your counters, as shown in Figure D. Click for larger image Figure D. 1.  Click the Log Files tab to...

databasejournal.com databasejournal.com

Creating databases in SQL Server 2000 - Page 2

Creating your first database With SQL Server 2000, you can create databases using one of these three methods: The Create Database Wizard The SQL Server Enterprise Manager console Transact SQL (T-SQL) About the Create Database Wizard If you are new to SQL Server, the best way to create a new database is to use the Create Database Wizard. Once you are comfortable with using SQL Server Enterprise Manager and/or T-SQL, you...

databasejournal.com databasejournal.com

The SQL Server Web Data Administrator - Page 2

Creating a new database In order to create a new database, simply click the Create New Database link and enter the name of your new database. For example, create a database called Databasejournal, as shown in Figure D. Once the database is created, you can manage the objects by choosing the appropriate task, as shown in Figure E. Click for larger image Figure D Click for larger image Figure E You can also view the objects...

databasejournal.com databasejournal.com

SQL Server 2005 - Interface Overview

In my last article, we went over how to install SQL Server 2005 and what it entailed. In this article, we will continue by giving you an overview of what the new interface looks like. Let's begin by exploring the menu bar as shown in Figure A. Click for larger image Figure A. SQL Server 2005 Menu Bar SQL Server Books Online SQL Server has a better look. It feels like a cleaner design and seems easy to navigate. Figure B....

databasejournal.com databasejournal.com

SQL Server 2005 - Interface Overview - Page 2

DTS Import/Export Wizard This Data Transformation Services Import/Export Wizard allows you to Import, Export, and/or transforms data between many popular formats. Click for larger image Figure E. Data Transformation Services Import/Export Wizard Database Tuning Advisor This tool is an automated physical database design tool that provides recommendations for indexes, views and horizontal partitioning. Figure F. show you an...

databasejournal.com databasejournal.com

SQL Server 2005: Day to Day DBA - Part I - Page 2

On the Authentication mode window (Figure I), choose whether you want to configure SQL Server 2005 as Windows Authentication only or Mixed Mode. If you choose Mixed Mode, you must assign a strong sa password as shown in Figure I. On the Collation Settings window, accept the defaults unless you have specific collation requirements for your company (Figure J). Click for larger image Figure I. Click for larger image Figure...