Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Part I: Configuring SQL Mail
- As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail. SQL Mail is a component of SQL Server that allows you to...
- Tags: Microsoft SQL Server, MSSQLServer, server, SQL, SQL Mail, SQLServerAgent
- Blog posts 2006-07-10
- Set up SQL Mail to send SQL Server alerts
- As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail.SQL Mail is a component of SQL Server that allows you to send...
- Tags: Mail, Microsoft SQL Server, server, SQL, SQL Mail, SQLServerAgent, Steven Warren MCSE, MCDBA
- Technical articles 2003-11-04
Additional Resources
- After upgrading to Server 2003, ODBC clients don't connect to System DSN
- After upgrading to Windows Server 2003 Standard from W2k Server, I can not get the clients to connect via ODBC System DSN to the SQL 2000 MSDE. I can however connect and run my application at the Server.Error at the client-Connection failed:SQLState: '01000'SQL Server Err0r: 11001[Microsoft][ODBC SQL Server Driver][TCP/IP...
- Tags: matterofacts@..., Microsoft Corp., Microsoft SQL Server, ODBC, registry, server, software, SQL
- Discussion threads 2005-03-14
- How do I configure SQL mail in SQL Server 2000?
- As a database administrator, I like automation. When it comes to my backups, I like to automate as much as possible. SQL Mail gives me the ability to know when my backups are successful and when they fail. SQL Mail is a component of SQL Server that...
- Tags: Microsoft Outlook, Microsoft SQL Server, Microsoft SQL Server 2000, Server, SQL, E-mail, SQL Mail, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Steven Warren
- Blog posts 2008-05-21
- Changing the name of your SQL Server
- Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to perform the change. 1. Open SQL...
- Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren
- Blog posts 2007-09-22
- High Availability with SQL Server and Double-Take Part II
- In Part I of High Availability with SQL Server and Double-Take, we discussed how to configure replication and mirroring of SQL Server data via Double-Take. Once you have properly configured your replication sets, you can configure failover and begin monitoring and testing. In this article, we will discuss how to...
- Tags: Steven Warren, failover, server, Double-Take, Microsoft SQL Server
- Blog posts 2006-04-11
- How to rebuild/restore the master database in sql 2005
- Hi, I'm testing my recovery on a sql server 2005 database. The server has been restored, which includes the OS and sql server 2005 installation (binaries, full tape restore). The tape restore didn't put back the master.mdf and other .mdf files (can't be backed up when open), so...
- Tags: Databases, Storage, michael.parry.ctr@..., sql server 2005, database, Microsoft SQL Server, SQL
- Discussion threads 2007-08-23
- Office Accounting 2007 for multi-user access using SQL 2005
- I'm trying to use MS Office Accounting Pro 2007 in an Server 2003 AD environment with multi-user access by 2 users XP Pro. I want to use SQL 2005 which I already have installed on my file server/DC. I have successfully installed Accounting 2007 on the server and moved my...
- Tags: Programming languages, Databases, Microsoft Office, dennis-c@..., SQL, server, data file
- Discussion threads 2007-09-14
- sqlstate = 08S01 [microsoft][odbc sqlserver]communication link failure
- we are using mssql server 6.5 and just recently, the application we used to run started giving communication link failure error alerts... could anyone please give me details why we are experiencing this kind of error. could it be from the application or from the mssqlserver itself or from network....
- Tags: Microsoft Corp., MS-SQL, naiomie_asks@..., network, ODBC
- Discussion threads 2007-03-03
- Obtain your database's location within a stored procedure
- There may be times when your application needs to know the specific directory where your database resides. If you need this information within a stored procedure, find out two ways to obtain the location. Sometimes your application needs to know the specific directory where your database...
- Tags: Microsoft SQL Server, SQL, Databases, Arthur Fuller, SQLDataRoot, database, SQL Server Newsletter, TechRepublic Inc., Procedure, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware
- Technical articles 2005-07-22
- Build Your Skills: SQL Server survival skills for non-DBAs
- It's not uncommon, especially in smaller organizations, to find network administrators who are responsible for administering Microsoft SQL Server and its databases. The problem is that database administration has very little to do with the role of network administration. Database administration is a highly specialized IT skill that requires training...
- Tags: Allen V. Rouse MCSE, MCDBA, CCNA, database, Microsoft SQL Server, server
- Technical articles 2003-07-17
- cannot access share
- I am having some problems with a windows 2003 server and share. I cant seem to access the share via the use of \servernameshare. I can however get to the share by the use of the IP address. Now I know most of you will think DNS...
- Tags: Servers, server
- Discussion threads 2005-06-15
- High Availability with SQL Server and Double-Take Part III
- In Part II of High Availability with SQL Server and Double-Take, we discussed how to configure and test a typical failover scenario using Double-Take. At this point, you should now be able to create a replication set and configure replication and mirroring. In the final article of this...
- Tags: Steven Warren, replication set, Double-Take, server, failover, Microsoft SQL Server, replication
- Blog posts 2006-04-17
- Discover the benefits of using MSDE with SQL
- You're mis-informed about the Jet database engine.> Given a query that pulls 100 rows from a table, >Access sends the entire table (or tables where >joins are involved)This is not always true. If the database is properly designed with appropriate indexes on primary and foreign key fields Access sends only...
- Tags: access, benefit, database, Jet Database Engine, jet engine, Microsoft Data Engine, Microsoft SQL Server, rkc, software, SQL, SQL Express
- Discussion threads 2005-08-20
- High Availability with SQL Server and Double-Take
- I have been doing a lot of work with SQL Server and Disaster Recovery. Many of my clients are particularly fond of Double-Take. In this three part blog series, I will go over the fundamentals of configuring Double-Take. Note: All screen shots are located a the bottom...
- Tags: Double-Take, Microsoft SQL Server, High Availability, Replication, Databases, Servers, Enterprise Software, Software, Data Management, Hardware, Steven Warren
- Blog posts 2008-04-23
- High Availability with SQL Server and Double-Take
- I have been doing a lot of work with SQL Server and Disaster Recovery. Many of my clients are particularly fond of Double-Take. In this two part blog series, I will go over the fundamentals of configuring Double-Take.Note: All screen shots are located a the bottom of the blog or...
- Tags: software, Steven Warren, Double-Take, server, Source ServerThe, Microsoft SQL Server
- Blog posts 2006-04-06
- Gain extended functionality by writing your own JDBC connection pool
- Using a connection pool can make database access much more efficient. In this article, you won't just learn more about connection pools; you'll actually make one. Follow along, gain some insights, and get a working application as a bonus.A recent Java tip recommended that developers use a JDBC connection pool...
- Tags: Java, Databases, Programming languages, Kevin Brown, JDBC, connection pool
- Technical articles 2001-12-12
- Do you need a network connection for an Access project to work with an SQL Server Database?
- Rick Dobson examines the Microsoft Data Engine MSDE, a free version of the Microsoft SQL Server.The Microsoft Data Engine MSDE is a free version of the Microsoft SQL Server. As of this writing, MSDE ships exclusively with Microsoft Office 2000 and Access 2000. In this article, we'll compare MSDE with...
- Tags: Databases, Rick Dobson, Microsoft Access, network connection, database, network, Microsoft Data Engine, Microsoft SQL Server
- Technical articles 2000-02-21
- << Previous
- page 1 of 1
- Next >>
