Angry DBA

Database Articles:

Access to SQL Server Replication

In a recent forum message, ICCLEARLY wrote: "We are looking for a way to set up replication between several remote MS Access databases and a central MS SQL Server database. ...

Oracle 11g Certification Programs

In this article, we'll take a brief look at the Database Administrator track and the three possible certifications you can earn on your way to Master status. Our next article...

SQL Server 2008 is Here!

Earlier this month, Microsoft announced the release to manufacturing (RTM) of SQL Server 2008. You can download a 180-day evaluation edition of SQL Server 2008 from the Microsoft website...

Help with the MAX() function

In a recent forum posting, aoneistheman wrote: "I'm a SQL newbie, and am creating this crazy view of other views. I need help using the MAX() function. I have a table that...

Microsoft Certified Application Specialist (MCAS) Program Requirements

If you use Microsoft Access 2007 as a regular part of your job, or you hope to gain employment in the field of user-level databases, you may wish to consider...

Creating a Mailing List in Microsoft Access

One of the most common uses of a Microsoft Access database is generating labels for mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft...

PDF Reports from an Access Database

Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database. The instructions vary slightly depending...

Upsizing from Access to SQL Server

In a recent forum posting, Data Analyst wrote: "I am trying to use the upsizing wizard to upsize an Access database to an SQL Server database. However, the new database...

Sorting out SMALLDATETIME, DATETIME and TIMESTAMP in SQL Server

SQL Server 2005 offers three different data types that all sound like likely candidates for storing time values: DATETIME, SMALLDATETIME, and TIMESTAMP. Here's a quick rundown on each: DATETIME is...

Database Certifications

Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Perhaps you're just getting started in database administration and you'd like to...