On MovieTome: See DARK KNIGHT's Wizard World Trailer
91 Resources for

sql server

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

How do I... Configure transactional replication between two SQL Server 2005 systems?
Replication often plays an important part in your database management strategy. An organization may use database replication for load balancing, offline processing, redundancy, and other typical administrative tasks. Microsoft SQL Server has a built-in replication application. This How do I... shows you how to configure replication between two Microsoft SQL...
Tags: Database, Microsoft SQL Server, Microsoft SQL Server 2005, Joshua Hoskins, Gallery, screenshots, how do I, replication, databases, sql server
Image galleries 2007-08-28
Four cool new features slated for SQL Server 2008
SQL Server 2008 code named Katmai is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait to get a sense of what's to come because Microsoft recently released SQL Server 2008...
Tags: sql server
Blog posts 2007-07-30
Installing and Configuring MOM 2005 w/ SQL Server Part II
In my last blog, we discussed, how to configure a virtual environment, install, and begin to configure MOM 2005 to monitor SQL Server. This blog will continue where the last one left off. We will import MOM 2005 Management Packs and Reports andbegin monitoring SQL Server 2005.View my Gallery!LetÂ’s start...
Tags: MOM, databases, data center, sql server
Blog posts 2007-07-23
Partition switching in SQL Server 2005
Last week, I showed how you can use the new table and index partitioning features in SQL Server 2005 to split your table data across one or more filegroups. In this article, I demonstrate how you can modify those defined partitions so that you can easily and efficiently add new...
Tags: sql server, databases
Blog posts 2007-07-23
Installing and Configuring MOM 2005 w/ SQL Server
In this blog series, you will learn the basics of installing Microsoft Operations Manager 2005 as well as how to use MOM to monitor SQL Server. This article takes advantage of virtualization. We will use VMware Workstation 5 to create the lab to introduce you to the basics of installing...
Tags: sql server, SQL, MOM, databases, data center
Blog posts 2007-07-18
Poll: What is the primary database management system (DBMS) in your organization?
Databases are the lifeblood of many of today's most critical applications. Whether you have implemented a database management system DBMS as part of an application deployment or if you have standardized on a single DBMS across the enterprise, TechRepublic would like to know what the primay DBMS is in your...
Tags: Sybase, Sql Server, Oracle, Open Source, Microsoft, Ibm, DBMS, DB2, Databases, Database
Blog posts 2007-07-18
Creating table partitions in SQL Server 2005
In the database world, partitioning is the horizontal splitting of rows in a table or index defined on a table in separate, smaller logical units. In fact, every table in SQL Server 2005 has at least one partition. You are essentially breaking one table or index up into smaller tables...
Tags: sql server, databases
Blog posts 2007-07-16
Moving the Tempdb and Master Database in SQL Server
There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to...
Tags: sql server, SQL, databases
Blog posts 2007-07-13
SQL Backup
I recently had the opportunity to work with a 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...
Tags: sql server, SQL, databases
Blog posts 2007-07-11
How to store word,image files in sql server
Hi! i have one application project, in this i want to store ms word,image files in sql server, using asp.net and jsp. give some idea to do that. plz help me out in this.
Tags: Programming languages, Databases, harish_vece@..., sql server, SQL, server
Discussion threads 2007-07-09
Restore your SQL Server database using transaction logs
Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore...
Tags: sql server, disaster recovery, databases
Blog posts 2007-07-02
How do I... Query foreign data using SQL Server's linked servers?
If you have a magic wand or a special relationship with some data fairy, all of your data is in the same database on the same server. Most of us aren't that lucky. Sometimes, the data we need is a non-database format or resides on a different server. SQL Server...
Tags: sql server, SQL, databases
Blog posts 2007-07-02
CA Erwin Data Modeler (DM) r7.2 released
Computer Associates CA announced late last week the release of its latest effort, called CA Erwin Data Modeler DM. According to CA, they have the first data modeling tool that integrates tightly with Microsoft Visual Studio 2005 Team Edition for Database Professionals. The newest release DM r7.2 is a smaller...
Tags: sql server, SQL, databases
Blog posts 2007-06-27
Defining cascading referential integrity constraints in SQL Server
Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user...
Tags: databases, sql server
Blog posts 2007-06-25
How Do I... Restore a SQL Server database to a new server?
This blog entry is also available as a TechRepublic gallery and as a TechRepublic download.As a DBA, I have been in many situations where I had to move databases to a new server due to old hardware, failed hardware, failed drives, etc. You have two options you could use to...
Tags: Sql Server, sql backup, restore, databases, Data Recovery, Backup
Blog posts 2007-06-20
Tweak SQL Server options to gain functionality
Administering SQL Server 2005 is no easy task. Here are examples of a number of SQL Server options that DBAs can set to enable different functionality by the database engine. Even though you may rarely or ever need to change these options, it's useful to know how if the occasion...
Tags: sql server, databases
Blog posts 2007-06-19
How to register sql server 2000 on client m/c , both 2005 & 2000 r there
Hey i have installed sql server 2005 and sql server 2000 with named instance on 2000 only in the remote m/c.now i cannot register the sql sedrver from the client m/c but 2005 is working wellPlease help me out.
Tags: Programming languages, Databases, sanghamitra.sen@..., SQL, sql server, server
Discussion threads 2007-06-14
Using Dynamic Connection of Crystle Report 8.5 with SQL Server 2000
Hi all,I am using vb 6 with sql server 2000 and generating reports in crystle report 8.5. i want to install my application in deifferent city. please tell me how can i use in crystle report 8.5 reports if i change the server. Either i have to do it manualy...
Tags: Programming languages, Databases, sheeraz_qureshi@..., sql server, server, Microsoft SQL Server 2000, Microsoft SQL Server
Discussion threads 2007-06-13
Crystal report 6.0 connection string for sql server 2000 using vb 6.0
i am developing one application.In which i am using crystal report 6.0 ,sql server 2000 and vb6.0My problem is:Which connection string is used in vb 6.0 to connect crystal report with sql server ?Please help meIt 's an urgentCan any one help me for this?Crystal report 6.0 connection string for...
Tags: Programming languages, meforam@..., sql server, SQL, connection string, server
Discussion threads 2007-05-17
Problem installing SQL Server evaluation copy
I downloaded the sql server evaluation ran the installer which appeared to install correctly but the program is not installed. I checked add remove programs, Start Programs Desktop and cannot see the app to run. My OS is Windows Visa UltimateWhich version of SQL Server did you attempt...
Tags: Microsoft Windows Vista (Longhorn), Databases, michael@..., server, Microsoft Windows Vista, sql server, Microsoft SQL Server, Microsoft Corp.
Discussion threads 2007-05-16


Cisco IOS Command Chart (IOS v.12+)
Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.
Buy Now
Troubleshooting Patch Cables Power Checklist
Call them what you want: patch, Ethernet, category 5, or even cat 5e cables. Regardless of the moniker, Ethernet patch cables perform the bulk of the ...
Buy Now