Microsoft made a number of improvements on this new release “Denali“. These are some of the key improvements

Manageability

==========

Contained Databases

Availability Groups (HADR)

Changed Startup Options

Security

---------

New Role Management

Added New Encryption...

I just tested Contained Databases, anew feature of DENALI in my test virtual Setup.

Here is Video and Screenshots, which I captured during configuration.

http://sqlserver-training.com/video-sql-server-contained-database/-

Suggest me some good test scenarios to test...

Hi,

I just implemented HADR (Availability Groups) in my test virtual Setup.

I used the following Infrastructure To implement HADR / High Availability Group

1) Domain Controller for Authentication

2) Two Virtual Machines with...

Hi,

I just implemented HADR (Availability Groups) a new feature in SQL Server Denali CTP1, in my test virtual Setup.

I used the following Infrastructure To implement HADR / High Availability Group

1)...

A Good upgrade case study for SQL upgrade from SQL Server 2000 to 2008 is posted here

http://sqlserver-training.com/migrating-sql-server-2000-to-sql-server-2008

Thanks <br />DBATAG <br />

http://sqlserver-training.com

<br />info@sqlserver-training.com<br />

Now Sure, how this post is being included in daily news letters that too after two years. Old post should not republished.

Thanks

DBATAG

http://sqlserver-training.com

info@sqlserver-training.com

SQL Server Error Log.....

Trace flags, after they are enabled, remain enabled in the server until disabled by executing a DBCC TRACEOFF statement.

Thanks

DBATAG

Website : http://sqlserver-training.com

Email : info@sqlServer-Training.com

SQLServer-Training, have been providing Online and Classroom Trainings. We undertake interactive and quality trainings with real-time orientation on SQL Development (DEV), Database Administration (DBA) and Business Intelligence (MSBI) modules.

Certifactions...

Looks like a side by side install issue known with SQL2000 tools which has been fixed for SQL2008 R2. The issue is that for sql80 there are registry keys missing...

Looks like a side by side install issue known with SQL2000 tools which has been fixed for SQL2008 R2. The issue is that for sql80 there are registry keys missing...