January 2011

Monday, January 24, 2011

Missildigital 10 X 25 Camera Binoculars Review

Contained in SQL Server Database SQL Denali Denali

databases are not always easy to move from one server to another because there are many agencies such as tempdb, log, collation, among others. To facilitate the operations of moving a database from one server to another SQL Server introduces the concept of Denali Contained Databases. Contained

A database includes all the settings and metadata that are needed to define the database and has no dependencies to an instance of SQL Server in particular. In this way it has isolated the database Database Engine component which makes it easy to move physical server.

To create a database with these characteristics we can use the following script:

USE [master];

GO CREATE DATABASE [ContainedSampleDB1] COLLATE SQL_Latin1_General_CP1_CI_AS;
GO

- Must allow the type of authentication for database

Contained EXEC sp_configure 'show advanced options', 1;

GO RECONFIGURE WITH OVERRIDE;

GO EXEC sp_configure 'container database authentication', 1;
EXEC sp_configure 'show advanced options', 0;

GO RECONFIGURE WITH OVERRIDE;
GO

- Now you must enable such features in the database you just created

ALTER DATABASE [ContainedSampleDB1] Containment = PARTIAL SET, GO

Greetings, Mr. Eduardo Castro

Martinez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http : / / citicr.org / blogs / news / default.aspx

http://sqlserverpedia.blogspot.com/

Thursday, January 6, 2011

AlwaysOn High Availability Event

SQL Server Denali includes new high availability features within them include SQL AlwaysOn.

AlwaysOn has new capabilities that provide high availability for databases for a specific application and also for the entire SQL instance, which provides flexibility to support multiple high availability configurations: AlwaysOn

Availability Group a new capability that helps protect databases offline times planned and unplanned . AlwaysOn
Failover Cluster Instance provides protection for the entire system and is an enhancement to the current features of SQL Server Failover Cluster Instance. Both

AlwaysOn AlwaysOn Availability Failover Cluster Group and Instance using Windows Server Failover Clustering. To learn more about AlwaysOn can use the following resources:

Learning About AlwaysOn:

· main site and download SQL Denali: http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx

· Resource Center SQL Server "Denali" AlwaysOn: http://msdn.microsoft.com/en-us/sqlserver/gg490638 (en-us, MSDN.10)

If you want to

retroalimientación on AlwaysOn can use the following link:

· Microsoft Connect (to report bugs and request improvements): https: / / connect.microsoft.com / sqlserver

· Denali AlwaysOn MSDN Forums: http://social.msdn.microsoft.com/Forums/en-US/sqlhadr/threads

additional feature:

· SQL Server "Denali" Resource Center: http://msdn.microsoft.com/en-us/sqlserver/denali_resource_center.aspx

· CTP1 Release Notes: http://social.technet.microsoft.com/wiki / contents/articles/sql-server-code-named-quot-denali-quot-ctp1-release-notes.aspx

· CTP1 Books Online for AlwaysOn: http://msdn.microsoft.com/en-us / library/ff878484 (SQL.110). aspx

Greetings,