Like TechNet UK on Facebook
TechNet Team Blogs
<a href="https://saraallison.wufoo.com/forms/m7p7a7/">Fill out my Wufoo form!</a>
Microsoft recently introduced System Center 2012, a tightly integrated management solution built from the ground up for automated private cloud application and infrastructure management. IDC interviewed a range of System Center 2012 early-adopter customers about their private cloud strategies and the role that System Center 2012 is playing in support of those programs. This white paper discusses IDC's industry-wide views on private cloud management trends and priorities, describes how System Center 2012 is addressing these needs, and highlights System Center 2012 customer experiences and lessons learned. The goal of this paper is to equip IT decision makers with a context for designing their own private cloud management evaluations and pilot projects.
Download the WhitePaper
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.
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
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
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.
Mark ‘Fitz’ Fitzgerald is the principle technologist for business intelligence, covering SQL, PerformancePoint and ProClarity at QA. He is a twenty-year veteran of the IT industry, with experience that ranges from mainframes, help desk and MIS systems. Mark has experience developing business applications in a range of products which enhance and distribute accurate, timely information within organisations. Mark has been with QA since 2000, and in 2003 & 2006 he won QA’s Trainer of the Year Award. Mark’s enthusiasm knows no bounds and training sessions often spill into breaks, lunch times and early evenings if not interrupted!
Business Diagrams using SSRS Map Control
Many businesses need to be able to produce business-oriented diagrams using SQL Server data. This can pose a problem for the SQL Server user, many of whom rely on Visio services or third party tools to be able to produce the reports which the business demands.
However, it is possible to use spatial maps within the reporting services element of Microsoft SQL Server 2008 R2, to create diagrams for use within business reports – whether this is from data stored in SQL Server as geometry/geography data types, embedded within the control itself (US only) or by using an ESRI shapefile. The diagrams below illustrate the level of reporting capability possible using this technique. All of the diagrams below are calculated from a standard parent and child relational source.
Below is a list of types of diagrams typically requested by the business:
Making these available using SSRS will allow clients to visualise the data better and give the developers additional options for display. It is not likely to replace the common chart types available within the product, but with a little thought and effort most diagrams are possible.
All of the diagrams below are possible using standard TSQL objects (user defined table data types, user defined functions and stored procedures). No CLRs are used in creating the diagrams and each performs adequately.
Chart Type and description
Hierarchy : hierarchical view of items dependent upon parent and child arrangement - organisation chart, hierarchical KPI, viewing a decision tree
Multiple proportional pies : growth of sales over time with the proportion of each sector
Nightingale Rose : changing sizes and proportions over time
Geometric map with Sparkline pies included : proportion of sales by category split regionally
Gantt Chart : tasks to the performed with dates
Network : tasks and dependencies between them
The exceptional European SharePoint Conference Programme 2013 is now available to view!
It’s Here. It’s Fantastic. And You Knew it Would Be! The 2013 Programme Team have put together an exceptional conference programme covering all the hot SharePoint topics. It delivers new and interesting sessions mainly focusing on SharePoint 2013, covering Search, Apps, Social, Cloud, Project, Migration & Upgrade, Governance, and much more.
This conference will showcase lessons and experiences from Microsoft speakers and the best minds in the SharePoint industry. This fantastic programme has been designed and structured to ensure that SharePoint developers, IT professionals, end users and business decision makers can maximise their experience during the conference and return to their workplace motivated, inspired and informed to be the best at what they do.
This four day event will start on Monday 4th February 2013 with Pre-conference Tutorials (full day) followed by 3 days of conference sessions on Tuesday 5th, Wednesday 6th and Thursday 7th.
Remember to forward on the Microsoft UK Discount code to your friends and colleagues so they don’t miss out!!
Exclusive Discount Code: UK13MSFT
Six Steps to Windows Azure launched last week with over 160 attendees over the 2 days at our London kick off events which were run in partnership with the UK Windows Azure User Group. Our first event Azure in the Real World showcased some fantastic real life solutions. Our second day focused on Advanced Topics in Windows Azure which included Windows Azure Media Services and Web Services. Overall the feedback has been fantastic.(#sixstepsazure) The audience was a real mix of those who have just started with Windows Azure to those considering it in the coming year.
Here is the content that was delivered by a great line up of speakers on the 8th and 9th November.
Hitting the Limits of Azure Storage presented by Richard Wadsworth
Drillboard:A sports app case study presented by IQ Cloud
Sheffield University: Environmental Projects on Azure presented by Shaping Cloud
Bootstrapping a start-up with Windows Azure presented by Labtrac Solutions -
How SaaS Changes an ISV’s Business Model presented by David Chappell
Hitting the Limits of Azure Storage. Richard Wadsworth, Amido
Drillboard: A Sports App Case Study. Matt Quinn, IQCloud
Sheffield University: Environmental Projects on Azure. Carlos Oliveira, Shaping
Bootstrapping a Start-Up with Windows Azure. Damian Otway, Labtrac Solutions
Exploring the Micro: .NET MicroFramework and Windows Azure. Andy Cross, Elastacloud.
How the Cloud Changes Financial Services. George Kaye, Derivitec and Andy Cross, Elastacloud.
David Gristwood talk to David Chappell.
Windows Azure Media Services presented by Nuno Filipe Godinho
Windows Azure and Active Directory presented by Steve Plank, Microsoft.
What’s next in Six steps to Azure?
Step 2: Architecture and Design for Windows Azure - Join us online on 26th November:
· Windows Azure Architecture for Developers - 10:00am
· Windows Azure Architecture for IT Professionals – 12:00pm
Step 3: Integration with Mobile and the New World of Apps – Join us online on 4th December
· Integration with Mobile and the New World of Apps Part 1 – 10:00am
· Integration with Mobile and the New World of Apps Part 2 – 12.15pm
We also have a number of Windows Azure Developer camps, which will take attendees from knowing nothing about the cloud to actually having deployed a simple application, and made it available on the public internet.
Other steps to follow but you can find out about the entire programme here.
IPD Guide for System Center 2012 - Operations Manager now available!
The Infrastructure Planning and Design (IPD) Guide for System Center 2012 - Operations Manager outlines the infrastructure design elements that are crucial to a successful implementation of Operations Manager. It guides you through the process of designing components, layout, and connectivity in a logical, sequential order. You’ll find easy-to-follow steps on identification and design of the required management groups, helping you to optimize the management infrastructure.
· Download the IPD Guide for System Center 2012 - Operations Manager.
· Learn more about the IPD Guide Series.
Determine Windows Server 2012 Readiness with MAP 8.0 Beta
Accelerate your Windows Server 2012 migration with Microsoft Assessment and Planning (MAP) Toolkit 8.0 Beta. This latest version of MAP adds new scenarios to help plan your environment with agility and focus while lowering the cost of delivering IT. Included in MAP 8.0 Beta are hardware and infrastructure readiness assessments to assist you in planning the deployment of Windows 8 and Windows Server 2012, preparing your migration to Windows Azure Virtual Machines, readying your environment for Office 2013 and Office 365, and tracking your usage of Lync.
· Download the MAP Toolkit.
· Learn more
· Join the beta.
Secure your environment with new SCM 3.0 Beta!
Secure your environment with new product baselines for Windows Server 2012, Windows 8, and Internet Explorer 10. The latest version of SCM offers all the same great features as before, plus an enhanced setting library for Windows 7 SP1 and Windows 2008 R2 and bug fixes. The updated setting library gives you the ability to further customize baselines, and also improves GPO Import feature affinity. SCM 3.0 provides a single location for creating, managing, analyzing, and customizing baselines to secure your environment quicker and more efficiently.
· Download SCM.
· Learn more about Security Compliance Manager.
· Join the SCM 3.0 Beta.