KB321185 explains a number of different methods to determine the version and edition (Developer, Standard, Enterprise,…) of SQL Server. The easiest in my opinion is method 4:
Connect to the instance of SQL Server, and then run the following query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')If you want to manually configure a connection to Lync Online – select Tools > Options in the Lync Client. Next select the Personal category on the left hand-side. You will see a screen which lists your sign-in address – click on the Advanced button next to it and select the Manual Configuration option. Fill in the following settings:
JQuery UI Tabs allows you to create HTML tabs in a very simple fashion. Listed below are the different steps you need to take:
Finally your code should look this
Some interesting references:
One of the new features in SharePoint 2013 is continuous crawling which allows your SharePoint search results to be be as fresh as possible. Continuous crawls run every 15 minutes by default but you can change the interval. This might sound similar to incremental crawling but there are some important differences:
References:
When you delete items in your mailbox, the size of the Outlook data file (.pst or .ost file – it is an ost file if you are using Microsoft Exchange Server) might not decrease as much as you expected. You can free more space by doing a compact of your mailbox – check out How to compact PST and OST files to eliminate deleted file spaces in Outlook. This is especially useful after you have done a complete cleanup of your mailbox since this probably grew your .ost file because the deleted items are also kept in this same .ost file.
Apps for Office are a new type of apps which allow you to extend Office 2013 client applications using a combination of web technologies (Javascript, CSS and HTML) and the new Javascript API for Office. If you are new to this I recommend that you check out these apps for Office and SharePoint 90 second videos.
Afterwards you can immediately dive in and check out Build apps for Office. In this series of blog posts I will explain how I learned to built an Excel Content app and issues I faced when trying to built this type of app. There are different types of Office 2013 apps – check out.
A good place to start building a task pane app is Sample task pane and content app walkthroughs – which shows you how to build a Bing Maps content app.
The Excel content app I will build is a variant of the Bing Finance apps – which is basically aimed at integrating stock data into Excel. Where the Excel 2013 app which I will illustrate will differ in a first version:
Usage scenario is the following:
In the sample code from the Bing Maps content app - you notice that you need to create bindings to interact with specific sections of your Office apps – see Binding to regions in a document or spreadsheet . This is something I will need as well for the Excel table with stocks.
There are 3 types of bindings which you can create and from which you can read data ( see BindingType enumeration) – in this case I want to use Office.BindingType.Table and read information from that binding afterwards. First create the binding:
Office.context.document.bindings.addFromSelectionAsync(Office.BindingType.Table, { id: 'stockdata' }, function (asyncResult) {if (asyncResult.status == Office.AsyncResultStatus.Failed) {write('Action failed. Error: ' + asyncResult.error.message);} else {write('Added new binding for table with' asyncResult.value.columnCount + ' columns');}});
Afterwards you can retrieve the binding again and read data from that binding. Unfortunately the sample code in the MSDN article only showed how to read data from a text binding – so it took me some time to find out how to read it from TableData object.
//Retrieve binding - if no binding - provide warningOffice.context.document.bindings.getByIdAsync("stockdata", function (asyncResult) {if (asyncResult.status == Office.AsyncResultStatus.Succeeded){//Loop over table rowsasyncResult.value.getDataAsync({coerciontype:Office.CoercionType.Table},function(asyncResult2){if (asyncResult2.status == Office.AsyncResultStatus.Succeeded){var rows = asyncResult2.value.rows;for (i = 0; i < rows.length; i++){write(rows[i][1]);}}});}});
In a next blog post I will explain how you can you use events in combination with the binding object.
After installing the Windows Phone 8 SDK I got an error stating that hardware virtualization was not supported on my machine therefore I could not use the emulator.
Apparently there are two requirements for your machine to meet to support the Windows Phone 8 emulator:
This is caused by the fact that the Windows Phone 8 Emulator is using the client version of Hyper-V (which ships with Windows 8 client OS) which requires SLAT. The Hyper-V server does not.
Because I don’t have a Windows Phone 8 device on hand – I’m pretty much stuck building Windows Phone 7.1 apps.
TechDays 2013 will take place on 5,6 and 7 March at Kinepolis Antwerp – the agenda is slowly filling up. For SharePoint developers there is an interesting pre-conference deep dive track with sessions by Dan Holme, Serge Luca and Lieven Iliano.
SharePoint sessions:
During the main conference no SharePoint sessions seem to be scheduled which is quite strange because the goal of the new SharePoint app model was to open up SharePoint to the average .NET developer.
Ever wondered what’s the difference between the Office 365 dedicated and multi-tenant environments? Check out Microsoft Office 365 Service Descriptions and Service Level Agreements for Dedicated Subscription Plans.
If you install Windows 8 Enterprise Edition from MSDN you probably notice that you don’t need to enter a key. But after installation you are required to activate the software and this doesn’t work without entering a key. If you want to enter the key you have to go to command prompt (remember to run with elevated administrator privileges) and type the following slmgr.vbs -ipk "YOUR_PRODUCT_KEY".
Unfortunately the next BIWUG event is already fully booked but if you add yourself to the waitlist we might try to get you in when cancellations come in. Topics on the agenda are:
This event aims to help you get up to speed with the new and improved features in SharePoint 2013, explain what they mean to your organization and how you can benefit from these enhanced features. Register now on http://eu.avepoint.com/sharepoint-day-brussels/
I will be presenting a session on the new search features in SharePoint Server 2013. Other speakers include Jeremy Thake (AvePoint) , Mike Bueltmann (Knowledgelake, Adam Castle (K2) and Abi Onifade (AvePoint).
For a full overview check out the SQL Server 2012 What’s new whitepaper
I just got the news that I have been renewed as SharePoint Server MVP. I became a SharePoint MVP in 2005 – so this is my 8th year in a row as SharePoint MVP – back in 2005 there were only a handful of SharePoint MVPs and I’m forever grateful to Patrick Tisseghem for introducing me into the wonderful world of SharePoint – without him there wouldn’t be such a vibrant SharePoint community here in Belgium.
There’s a lot of buzz out there with the re-launch of the Belux Information Worker User group – BIWUG – don’t forget to register on www.biwug.be to stay up to date with the latest SharePoint information – there are a lot of interesting sessions planned in the coming months.
There will be 2 coding sessions, 1 for Day Birds from 10am – 4pm and one for Night Owls from 6pm – 12am. You can join us for one or both sessions. Build an app, have fun and go home with a fantastic prize!
Don’t forget to register.
In SharePoint 2007 you had two options when you needed to create a new template for a SharePoint site:
In SharePoint 2010, there is a new replacement and improved framework for handling site templates. When you save a site as template it will create a normal SharePoint Solution Package (a wsp file – if this is new for you take a look at WSP – SharePoint Solution Files). The new webtemplate feature allows you to build a “site definition” which is scoped to a site collection – this way you can built templates of a site and still deploy them to the SharePoint solution gallery in sandbox mode.
Every webtemplate is based on an existing site definition – listed below is a code sample using the minimal set of attributes that you have to use when creating a new webtemplate.
<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<WebTemplate
BaseTemplateID="1"
BaseTemplateName="STS"
BaseConfigurationID="1"
Name="JOPX"
Title="JOPX WebTemplate"
>
</WebTemplate>
</Elements>
The WebTemplate has to reference the Template (BaseTemplateName) and the configuration of the site definition (BaseConfigurationId) the template is based on.
The example on MSDN How to: Create a webtemplate starts from importing an existing saved webtemplate but in some cases it is easier to start from an empty SharePoint project and manually adding a elements.xml incorporating the webtemplate feature as well as the ONET.XML from the site definition from which you want to start.
References:
After having installed Visual Studio 2012 together with the Microsoft Office Dev Tools which are distributed with the Web Platform Installer 4.0 (Just search for Office within Web PI) you can start building your first SharePoint 2013 apps. There is only one project type for building SharePoint 2013 apps.
After having selected the SharePoint 2013 app template, you will need to decide what type of app you want to build.
Let’s start with exploring what is included in the Visual Studio 2012 project after you have selected SharePoint hosted app.
Visual Studio 2012 SharePoint 2013 App structure:
If you take a look at default.aspx you will notice the following javascript snippet added in to the page – this is quite important – and provides the binding with the business logic which is added into app.js
1: <script type="text/javascript">
2: $(document).ready(function () {
3: SP.SOD.executeFunc('sp.js', 'SP.ClientContext', function () { sharePointReady(); });
4: }); 5: </script>The snippet above uses the jQuery document ready event handler – “ $(document).ready(function())” to call SP.SOD.ExecuteFunc(). This is an example of a common pattern in Javascript called anonymous function calls. SP.SOD.ExecuteFunc(key,functionname,fn) ensures that the specified file - sp.js - that contains the specified function – SP.ClientContext - is loaded and then runs the specified callback.
So when both the DOM and SP.js are loaded and the ClientContext object is initialized the code will call the sharePointReady() function which is located in App.js.
If you look at the code in App.js – you will notice that the general way of working with the Javascript Client Object Model hasn’t changed a lot in SharePoint 2013.
1: // The code creates a context object which is needed to use the SharePoint object model
2: function sharePointReady() {
3: context = new SP.ClientContext.get_current();
4: web = context.get_web(); 5: 6: getUserName(); 7: }References: