Useful tools, tips & resource for IT professionals including daily news, downloads, how-to info and practical advice from the Microsoft UK TechNet team, partners and MVP's
Day in the Life
Internet Explorer 9
Meet the Team
Microsoft Virtual Academy
Simon on strategy
SQL Server 2008 R2
SQL Server 2012
System Center 2012
system center 2012 sp1
System Center Configuration Manager 2012
System Center Virtual Machine Manager 2012
weekly wrap up
Windows 7 deployment
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Windows Small Business Server
Browse by Tags
sql server 2012
Tagged Content List
Lab Ops 2–The Lee-Robinson Script
In my last post I mentioned how Marcus Robinson & had adapted PowerShell scripts by Thomas Lee to build a set of VMs to run a course in a reliable and repeatable way. With Marcus’s permission I have put that Setup Script on SkyDrive, however he has a proper day job running his gold partnership...
20 Sep 2013
Microsoft Valuable Penguin
I sometimes think the IT industry is a bit like a load of penguins on the pack ice, each one checking the others out to see who going to brave the ocean first. In IT it’s nervousness about when to jump onto a new technology and if there is one technology that makes IT professionals really nervous...
13 Aug 2013
SQL Server Spruce up
Landrovers, will take a lot of pounding and neglect, but when my wife drove hers to Australia she made very sure it was properly set up for 2 years on the road Similarly SQL Server is also often out in the wild far from DBA’s and inspection from maintenance tools, like System Center . However now...
8 Aug 2013
Installing SQL Server in a Virtual World
I do get occasional feedback that SQL Server is hard to install, all those screens all those checkboxes etc. etc. This is simply a reflection that there is so much in SQL Server aside form the database engine, however if you know what you want and you are doing this regularly then script it, if...
29 Jul 2013
Virtualizing Tier 1 SQL Server
A while back I published a couple of posts on virtualizing SQL Server, and in the light of developments in both the virtualization platform out there and SQL Server itself I feel the need to do a complete rewrite. The traditional approach to implementing high availability (HA) in SQL Server has...
22 Jul 2013
Server 4024 part 3 - Networking
Databases are typically bound either by networking or IO and actually this can be two sides of the same coin if you are using remote storage. So what’s new in Windows Server to improve networking both to improve access to shared storage and access to database workloads from another tier in a service...
9 Jul 2013
Server 4024 part 2 - Management
In the second post in this series I wanted to look at how changes to the way you manage things in Windows Server 2012 (WS 2012) affects your management of SQL Server 2012 (SQL 2012). Multi Server Management Traditionally to manage the OS we used to remote desktop onto every server we managed and applied...
12 Jun 2013
Server 4024 part 1 – Virtualisation
A database is only as good as the operating system it resides on. SQL Server only runs on Windows and given that Windows Server 2012 (WS2012) is a huge change from what there was in Server 2008 R2 what does this new OS mean for the DBA. The reference to Server 4012 is because that would be WS2012...
29 May 2013
The TechEd Challenge - It's still not too late to enter if you've not done so - a sneak preview of what you could win!
Have you entered the Tech Ed Challenge yet? If not, why not? Just by entering you could win a ticket to TechEd Europe , that's right, just by completing a form and downloading one of the products, you are entered into the draw. If you download/sign up for all three then you've got three times the...
7 May 2013
SQL Server 2012 Common Criteria Certification
By SQL Server Team UK In February 2013 Microsoft received the Common Criteria (CC) certificate for SQL Server 2012 SP1 Enterprise Edition (English) x64 (Version 11.0.3000.0) at EAL4+ and compliant with U.S. Government Protection Profile for Database Management Systems, Version 1.3, 24 December 2010....
15 Apr 2013
Event: SQL Relay 2013 Announced
For those of you who are focused on SQL Server I thought it would be good to let you know that following on from SQL Bits in May is SQL Relay in June . You will find all the details in the flier below:
5 Apr 2013
A SQL Server DBA walks into a Parallel Universe
By Michael Sullivan, SQL Product Manager, Microsoft UK We all know some pretty bad SQL jokes (the language that is). Well I do anyway. Like, a DBA walks up to two tables in a bar and says 'may I join you'? Enough. But imagine that same DBA walking into a restaurant and finding no tables or chairs...
28 Mar 2013
Evaluate This – Storage Spaces
So far in this series I have used the new storage features of Windows Server 2012 as a place to run VMs from, but there’s more to it than that. Shared storage used to mean presenting SAN storage inside a cluster, and you relied on your SAN experts to provision the storage you needed. ...
6 Feb 2013
Tech.Days Online is Back! 24th/25th/26th April
New years resolution: must blog more! It's only taken me to the end of January to start my resolution but I'm going to try one blog article per month. We're bringing back Tech.Days Online on the 24th/25th & 26th of April. This time with more days and more topics. Simon and Andrew will be back...
30 Jan 2013
Case Study: EMI Exploits 'New World of Data' for Single View of Music Across 25 Countries
Record company EMI Music wanted to integrate the large amount of information it uses—including massive consumer surveys, demographic, and partner data from companies such as iTunes—to gain a single global view for its artists. By deploying Microsoft SQL Server 2012 Fast Track Data Warehouse technology...
11 Dec 2012
Event: SQLSanta 2012
On Friday 14 th December 2012, the SQLSanta team is proud to present a free one-day technical community event at the Microsoft Offices in Cardinal Place, Victoria, London. The day will consist of two concurrent tracks: a Business Intelligence Track, and a DBA/Dev Track. Business Intelligence sample session...
3 Dec 2012
Guest Post: Top Tips from QA - Creating business diagrams from within SQL Server without using Visio services or third party tools
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...
12 Nov 2012
Case Study: Data Services Firm Uses Microsoft BI and Hadoop to Boost Insight into Big Data
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...
6 Nov 2012
Guest Post: How to use Contained Databases in SQL Server 2012
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...
6 Nov 2012
Training Partner: Windows Server 2012 Hands On Labs
Microsoft Training Partner Pearson in Practice is currently offering you the opportunity to attend Microsoft First Look Clinics and Hands on Labs completely FREE of charge. All training is delivered by experienced Microsoft Certified Trainers, using newly released Microsoft Official Curriculum. The training...
11 Sep 2012
MCSE for SQL Server
I have to be honest I gave up getting certified before I joined Microsoft mainly because the exams didn’t keep up with the release of SQL Server specifically the Business intelligence exams. I then had the same problem as an evangelist I was working on the next release of the SQL or Windows Server. However...
31 Aug 2012
A database is only as good as the operating system it runs on
Simon and the rest of my division regularly rag me about how I go on about databases all the time so when Sarah asked me for a post on virtualisation I decided to ignore her and talk about SQL Server instead! Databases are one of the last things to be virtualised especially the larger ones and this is...
28 Aug 2012
New for BI in Excel 2013, SharePoint 2013 and SQL Server 2012 SP1
Empower all users to gain breakthrough insights as a natural part of their day-to-day activities using PowerPivot and PowerView, now in Excel. Analyse data ranging from a few rows to hundreds of millions of rows with extreme analytical performance on your desktop using Excel data models powered...
31 Jul 2012
Book of the Fortnight: Microsoft® SQL Server® 2012 High-Performance T-SQL Using Window Functions
Apply powerful window functions in T-SQL-and increase the performance and speed of your queries. Optimize your queries-and obtain simple and elegant solutions to a variety of problems-using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you'll learn how to apply calculations against...
6 Jun 2012
Get Trained and Certified in SQL Server 2012
The data explosion is happening at every level of the business: across devices, applications, and individual roles. Become certified on Microsoft SQL Server 2012 and prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions...
5 Jun 2012
Page 1 of 2 (44 items)
© 2013 Microsoft Corporation.
Privacy & Cookies
See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support by product
Forefront Edge Security
Forefront Server Security
Other support links
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums