I also failed 70-458 last week, passing the admin section but failing the SSIS section (which is a greater challenge to me because I've had little need to use SSIS...

The last class my company paid to send me to was essentially a workstation in a quiet room, a one-month supscription to CBTNuggets, and a VM to play around on.

Since...

I have noticed that Excel stores dates in a numberic format. For example if you enter 3/26/2014 in Excel and then format it for numeric you get 41724. I...

The Excel file contains data going back several years and I'm only looking for data entered in the past few weeks. (Honestly it is a personal project...

After the previous Second Shot promotion ended, about six months passed before they started it again. Microsoft may do another, but there's no guarantee.

My recomendatation would be...

Good point. As I read more I see that CDC can also be configured to track and capture multiple changed to the same rows between SSIS job runs. ...

I am not suggesting installing a new instance of SQL Server. I suggested installing the 2008 R2 version of SSMS (or Management Tools). Then you should fully...

When I've had errors like this, it was usually due to Exchange security policies designed to prevent servers from being hijacked for sending spam. If you use Microsoft...

On shrinking databases, sometimes you see the advice "Never do it." My feeling is that there's virtually no feature in SQL that should NEVER be used, but there are...

Apparently cloud data can evaporate just like clouds in the sky.

Are the higher-ups aware that the now have an employee in-house with the applicable skills to install and maintain "the database"? They may not understand technology, but...

Is it not possible to upgrade or make a new installation of SQL Management Studio verision 2008 R2? That would seem to be a much better solution than...

It is also common for the Recovery Model to be temporarly changed for large data imports. Could that be happening?

If one of your clients will allow you to have a downtime, you can move their MDF and LDF files to a different drive by following the instructions in the...

If I understand your question, I would think that all SQL2012 system DBs are created at compatibility level 110, which rules out hosting on older versions of SQL.