A few of you have been asking what IT Camps still have spaces, here’s the list of Windows 8 Camps that have spaces. We don’t have any spaces on the Windows Server 2012 Camps at the moment or the Windows Azure IT Pro Camps.
12th Feb 2013 - Windows 8 IT Pro Camp - Glasgow
14th Feb 2013 – Windows 8 IT Pro Camp - Glasgow
17th April 2013 – Windows 8 IT Pro Camp - Southampton
As well as the in real life events we did run an online series called TechDays Online. We recorded each of the sessions and these are now available for you to view at your leisure.
Here are the session video’s for each of the sessions from TechDays Online 2012.
Session 1 - Introduction to Windows Server 2012
We start by taking a look into the Next Generation File Server that is built into Windows Server 2012. We have lots of features powered by SMB3 which we will also take a look at.
Session 2 – Multi Server Management
Andrew and Simon take a look at the ability to manage lots of different servers as if they are the same server.
Session 3 - Virtual Machine Mobility
We see how Andrew and Simon showed lived and in action how to move virtual machines around inside an environment.
Session 4 - Networking Enhancements
In this session we explore new ways to ensure availability and uptime with features like Hyper-V replica and DHCP failover. We also take a look at how to manage the quality of service that is available to particular network connections inside of our organisations and inside of virtual environment and also inside our physical environment!
Session 5 - Windows Azure for the IT Pro
This session puts some context behind terms like IaaS, PaaS and SaaS. It then heads in to the IaaS territory with a discussion of the specific features of VMs in Azure.
Session 6 - Virtual Networks and Active Directory
To deploy AD Domain Controllers in Azure, you need a Virtual Network, so that's what we cover here and then head off in to what specifics you need to configure to get a DC running.
Session 7 - DIT and Azure AD
We just finished off the Domain Controller section here with a discussion of where to place the DIT. Then we head off in to a new preview feature called Windows Azure Active Directory and highlight how it's different to a Domain Controller in the cloud.
Session 8: Deployment, VM Availability & SharePoint in the Cloud
We finish the afternoon with a discussion about the high availability features, service level agreements and ways of deploying a complete SharePoint infrastructure in the cloud.
Session 1 - Windows 8 and VDI
Understand how changes to VDI, Direct Access and VPN make your admin life easier.
Session 2 - Delivering Windows 8 Apps
The ability to deploy applications and Windows 8 as an Operating System.
Session 3 - Virtualisation Inside Windows 8
We take a look at Hyper-v inside Windows 8 and what the requirements are, the benefits of App-V and User Experience Virtualisation.
Session 4 - Windows To Go
Explore new anywhere working possibilities with Windows To Go.
Session 5 - Private Cloud in the Afternoon
Understand what it takes to build a private cloud that can automatically scale, self-provision and ensure quality of service through user-centric request management process.
Session 6 - Operations Manager
How to automate everything and anything using Orchestrator and how to monitor this completely, right down to the application level, with Operations Manager.
Session 7 - App Controller and Data Protection Manager
Klout wanted to give consumers, brands, and partners faster, more detailed insight into hundreds of terabytes of social-network data. It also wanted to boost efficiency. To do so, Klout deployed a business intelligence solution based on Microsoft SQL Server 2012 Enterprise and Apache Hadoop. As a result, Klout processes data queries in near real time, minimizes costs, boosts efficiency, increases insight, and facilitates innovation.
Below is a video with more information.
You can also download the full Case Study or visit the Case Study website to find more information and case studies similar to this one.
Try SQL Server 2012 Now
Angela Cataldo works for Firebrand Training as a subject matter expert and instructor for SQL Server and System Centre. For over 10 years Angela specialized in SQL Server, delivering training and consultancy services to a number of companies throughout the UK and Europe guiding and mentoring customers to follow Microsoft Best Practice and assist in their understanding and adoption of SQL innovative features.
Before SQL Server 2012, databases have always had a degree of portability. But with SQL Server 2012 we can now embrace the powerful new manageability and security features of Contained Databases - which make a database much more portable.
Why do we need Contained Databases?
SQL Server security has always been managed at two levels:
Logins are managed at Server level, and users are managed at Database level. This means permissions for SQL Server have to be defined in two or more locations, and this can cause confusion.
Also, having to manage logins and users separately can cause problems when it comes to maintaining high availability and disaster recovery solutions. And the need to regularly synchronise logins against failover and secondary servers; to avoid problems such as orphaned users.
So with the introduction of containment and the concept of boundaries in SQL Server 2012; a database can become free of external dependencies, server level metadata, settings and security logins.
For a Database Administrator this can also potentially help with the problem we have all faced after recovering a database: repairing a large numbers of logins using the sp_change_users_login stored procedure.
What is a Contained Database?
In simple terms it is a database that is isolated from other databases, and isolated from the instance of SQL Server that is hosting the database.
There are four ways that SQL Server 2012 helps to isolate databases from the instance:
How to create a Contained Database
In this example I am going to demonstrate - in four steps - how to create and authenticate against a Contained Database:
First I need to enable contained database authentication, by executing the following code as a New Query in SQL Server Management Studio (SSMS) against the master database:
The first sp_configure line reports on the current setting and the second sp_configure line enables the server-level setting. This allows SQL Server to defer authentication to the database, provided that we have configured the users correctly with the right authentication.
Now I can create a contained database, executing the following code as a New Query in SSMS:
If we take a look at the Database properties of this database we can see on the Options Select a Page the menu option for Containment Type:
You can also use SSMS to configure containment for databases.
Now we have a contained database we next need to create a user by executing the following code as a New Query in SSMS:
For further syntax of Create User see SQL Server Books Online: CREATE USER, examples cover:
You can also use SSMS to create a contained user, for User Type selecting SQL User with password:
We can also take an existing user and convert it to a contained user executing stored procedure sp_migrate_user_to_contained.
For an explanation of syntax see SQL Server Books Online: sp_migrate_user_to_contained
Now we can take the final step and login in as a Contained Database user, ensuring that in the Connection Properties, under Connect to database, is our Contained Database AdventureWorks2012.
When connecting to a contained database, if the user does not have a login in the master database, the connection string must include the contained database name as the initial catalog. The initial catalog parameter is always required for a contained database user with password.
In four simple steps I have enabled database level authentication, created a contained database and contained user then logged into SQL Server Management Studio as the new user.
What else do I need to know?
As a Database Administrator, security is a major concern and there are unique threats when using Contained Databases that must be considered. Thankfully SQL Server Books Online has a dedicated page on these implications: Security Best Practices with Contained Databases.
An example is passwords in a database require to be strong, complex passwords - and cannot be protected by domain password policies. Therefore, wherever possible create contained users for domain logins and take advantage of Windows Authentication.
Contained databases are set to be one of the top new features for DBAs. Plus AlwaysOn Availability Groups are also new to SQL Server 2012 - helping to simplify environmental and failover concerns, to ensure a highly available disaster recovery solution. SQL Server 2012 Database Containment is simply one of the best things to have happened to SQL Server.
HDInsight is Microsoft’s 100% Apache compatible Hadoop distribution, supported by Microsoft. HDInsight, available both on Windows Server or as an Windows Azure service, empowers organizations with new insights on previously untouched unstructured data, while connecting to the most widely used Business Intelligence (BI) tools on the planet.
Please visit the Microsoft Big Data home page here for more details, to download HDInsight for Windows Server, or to sign up for HDInsight on Azure.
Have you heard Microsoft talking about the System Center 2012 Orchestrator IT Process Automation solution? Do you wish you knew...
· What Orchestrator is?
· How Orchestrator has helped companies reduced their datacenter operational costs by 20‐40%?
· How to find out where Orchestrator can help in your business?
Kelverion are System Center 2012 Orchestrator experts. We have more than 5 years’ experience in building large, complex automation solutions using Orchestrator and Opalis and over the years have faced virtually every challenge thrown up when implementing Orchestrator.
Attend this valuable webcast System Center 2012 Orchestrator Overview, Wednesday, November 7th at 11:00 am Greenwich Mean Time. Learn ...
Join Kelverion for System Center 2012 Orchestrator Overview, Wednesday, November 7th at 11:00 am Greenwich Mean Time.
Last week Andrew and I presented a number of sessions at TechDays Online in the UK and we received numerous requests during the day to publish the decks so that people can peruse them at their leisure. Well those decks are now here available for you to click through and download if you so wish.
Windows Server 2012