Editorials

Mock Interview, Part II. The Technical Interview

SQLonCall
Mock Interview, Part II. The Technical Interview: Go through the interview process, questions, answers and interpreting the responses. Learn About Questions, Answers and Tips for a Great Experience.

> Watch the show here

Also, don’t miss:
Watch: Microsoft’s Matt Nunn on SQL Server, Visual Studio, features, roles and disciplines.
Watch: Handling a DBA interview. A Mock interview with questions, answers and more.

Featured Article(s)
Troubleshooting SQL Server 2005 Bulk Copy Problems
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 bulk copy. He also tells how you can resolve these problems.

Don’t Spin Your Wheels Getting Up to Speed with SharePoint
You can start learning the ins and outs of SharePoint right away with free training from AppDev. AppDev is offering a free learning module so you can get started immediately, and at the same time see how great it can be to have help as you get things going. Check out the free download or CD-ROM by mail here – and stop wasting time guessing at the next steps to get your SharePoint up and going ASAP.

Today’s Webcast – Managing Change with SQL Server
In today’s webcast we’re going through documenting your system and understanding how you can control change, document change and even triggers and how they can work to give you added information when changes are made to data and schemas. It’s really important to know what’s happening with your servers – even if you’re the only person that needs to work on them, it’s still easy to "skip" that important step of documenting things so someone else can also maintain it.

In the webcast, we’ll be going into what the native tools are within SQL Server 2000 AND 2005 for managing internal additional information about tables and structures and also what you can do with the information once you’ve saved it so you can see the differences.

> Register here for the show
> Dec 5 2007 12:00pm Noon Pacific

Virtual Conference Update
(Thanks for all of the feedback!)
We’ve started posting our first pass at sessions – take a look! If you’d like to be involved in reviewing and commenting on the sessions and other aspects of the virtual conference, get signed up today and we’ll be sure you’re included. Remember, 3 days of outstanding content, from your computer – NO travel, NO out of office time. You can’t lose.

The conference for the rest of us – the core things you need to know about when working with SQL Server. We’ll get you going!

> Take a look here.

Featured White Paper(s)
Common Table Expressions
Common Table Expressions(CTEs) are new to SQL Server 2005. CTEs are defined in the ANSI SQL-99 standard. We need to begin lea… (read more)

Migrate, Manage, Monitor: Top 10 Tips for a Successful Move to SQL Server 2005
Effective planning and management enables a smooth migration and ensures that your new SQL Server 2005 environment will be ru… (read more)

Solving Key Management and Archiving Problems in Microsoft Exchange Environments
PST files continue to be an area of concern for many Exchange Administrators. To satisfy legal discovery, regulatory complian… (read more)

SQL Injection: What it is and how to prevent it
SQL injection is the hacking technique which attempts to pass SQL commands through a web application for execution by a backe… (read more)