Firstly I would like to recommend you to watch the SQL Server 2005 videos (free):

https://www.microsoft.com/Sqlserver/2005/en/us/demos.aspx#express

Next, what you need looks like a method to hide some data during a specific time,...

SYSDTSLOG90 logs are usually used to debug purposes, but if your SSIS packages log all steps for each execution, you need to implement an export (recommended) and purge steps.

You could...

I recommend you to learn about the concepts first and next learn about how to implement this kind of environment.

Windows 2003 Clustering

http://technet.microsoft.com/en-us/library/cc783714.aspx

Windows 2008 Clustering

http://www.microsoft.com/windowsserver2008/en/us/failover-clustering-overview.aspx

Pro SQL Server 2005 High Availability

http://www.amazon.com/Pro-Server-2005-High-Availability/dp/159059780X/ref=sr_1_1?ie=UTF8&s=books&qid=1240679522&sr=1-1

This is...

Another option is to check the SYSJOBHISTORY system table, but there is a trick to use it.

The sysjobhistory record is created only when a job STEP finish, so you can...

opss...I guess the information above is not correct.

It's possible to create more than one DATAFILE per DATABASE:...

There are some methods to do this, take a look at this article:

Changing a Non-IDENTITY column to IDENTITY and vice versa

http://www.sqlservercentral.com/articles/T-SQL/61979/

Hi,

I'm happy with my profession.

I believe that I have a profession and not just a job.

I've been working hard to improve my skills in English, Operating System, and Databases.

I don't...

Hi,

I've been faced this problem sometimes.

The good news: there isn't rollback process still running. "real rollback"

The bad news: in all cases we needed to restart the MSSQL engine service to...

few coins...very good...:)

Well, I would like to have a Debugger feature with no sysadmin requirements, but to read and access some MSSQL resources sysadmin is required to debug.

Hi Jerry,

SQL Server Express, don't give us the opportunity to test High Availability features, for example.

They could talk about CTP's too, but the main goal is to test the product...

I've been hearing about this topic for some years, and in my experience the companies still want to see you sit down in a chair inside the company.

This is a...

Hello guys,

I'm included in this list too.

I'd practiced Brazilian Jiu-Jitsu for some years.

This martial art was good in my case, because I became more self-confident, calm, and it's a good...

Hi guys,

I've been using Windows Vista Ultimate for 1 year, because I bought a new laptop powered by Vista, and for while it's everything ok. But I didn't upgrade my...

Hello guys,

Thank you for your comments, I my opinion this is a great way to improve our experience.

But let me explain something that I think was not clear in my...

Hi everybody,

I'm a little bit late in this posting, but I'd like to share with you my similar case.

Some months ago I was fired, don't worry, I got a new...