Why pay for a separate tool when you paid for a product that has a feature you need.

Having said that, any specific Encryption method are you looking at which TDE...

One of the big financial clients who interviewed me in the past used NetApp. It seems NetApp is good with clients having huge storage needs. I would say get as...

I had a similar issue once with SQL server starting before the disks on which the data files were accessible. A reboot did the trick and also I ran dbcc...

Very good morning 😉

1.Index...

You can set up alerts for any failed jobs and get notified by email.

That's correct. You need to identify your facts and dimensions. I guess a Star Schema would be your best bet, as it is the simplest style of dw schema.

You can...

re: #5 - a cube is not necessarily 3 dimensional, it's dimensionality is dictated by the number of dimensions included, so it could be much higher than 3. People often...

Make sure all the services are running properly. Also a DBCC check on the important databases would be good. Suggest reading this article

HTH...

You can create a Datawarehouse...

Can you post the sample query that you are using for this?

Thanks...

Just take out the GO in the query and you should be fine. I have checked it to work correctly without GO.

print '-- dbcc check all databases Except TMEPDB on...

I do not think the forum is having connectivity issues of any kind. Could this be related to your browser then?..

You can save the package at the end of the import export wizard in case you intend to use it later on.

Alerts for services

failed logins

Connectivity issues

tempdb growth etc...

Create job - Alert-LoginFailureDetected

This job executes the stored procedure 'usp_AlertLoginFailed' when the alert is triggered. After calling the stored procedure, the variable @SendAlert returns the value 'YES' when an e-mail...