Infrastructure at your Service

All Posts By

Nathan Courtine

Nathan Courtine

The SQL Server DBA’s essential toolkit list

By | Technology Survey | No Comments

This week, I attended the SQLSaturday 2014 in Paris. During the Pre-Conference on Thursday, I followed Isabelle Van Campenhoudt for her SQL Server Performances Audit session. This conference took the form of an experience sharing between attendees. Indeed, we tried to list together the most important software, tools, features or scripts which will help an SQL Server DBA during his work. In this blog, I want to share our final list with you.   Windows…

Read More
Nathan Courtine

Improving your SharePoint performance using SQL Server settings (part 2)

By | Technology Survey | No Comments

Last week, I attended the SQLSaturday 2014 in Paris and participated in a session on SQL Server optimization for Sharepoint by Serge Luca. This session tried to list the best pratices and recommendations for Database Administrators in order to increase the SharePoint performance. This blog post is based on this session and is meant as a sequel to my previous post on Improving your SharePoint performance using SQL Server settings (part 1). SQL Server instance…

Read More
Nathan Courtine

Deploying a SQL Server database to Azure

By | Database management | One Comment

Deploying an SQL Server database to a Windows Azure virtual machine is a feature introduced with SQL Server 2014. It can be useful for an organization  that wants to reduce its infrastucture management, simplify the deployment, or have a fast virtual machine generation. Concept This new feature is a wizard which allows either to copy or migrate an On-Premise SQL Server database to a Windows Azure virtual machine. The following schema explains the main process…

Read More
Nathan Courtine

Backup a SQL Server database from On-Premise to Azure

By | Hardware & Storage | No Comments

SQL Server database backup & restore from On-Premise to Azure is a feature introduced with SQL Server 2012 SP1 CU2. In the past, it could be used with these three tools: Transact-SQL (T-SQL) PowerShell SQL Server Management Objects (SMO) With SQL Server 2014, backup & restore can also be enabled via SQL Server Management Studio (SSMS). Concept This feature is quite similar to a “classic” backup & restore tool. Indeed, the main different lies in…

Read More
Nathan Courtine

Master Data Services installation for SQL Server 2012

By | Database management | One Comment

This posting is a tutorial for installing Master Data Services on your Windows Server 2012. Microsoft SQL Server Master Data Services (MDS) is a Master Management product from Microsoft, code-named Bulldog. It is the rebranding of the Stratature MDM product, titled +EDM and acquired in June 2007 by Microsoft. Initially, it was integrated for the first time in Microsoft SQL Server 2008 as an additional installer. But since SQL Server 2012, Master Data Services is…

Read More
Nathan Courtine

ESPC 2014: Upgrading To SharePoint 2013

By | Application integration & Middleware | 2 Comments

I have decided to make a resume of the presentation “Upgrading SharePoint 2013” by Sam Hassani that I have followed at the European SharePoint Conference 2014. This is meant for the people who did not have the chance to attend to the event taking place from 5 to 8 May 2014 in Barcelona! For more details on the Conference presentations, have a look at the agenda. History of upgrades in SharePoint Historically, there are three…

Read More
Nathan Courtine

Improving your SharePoint performance using SQL Server settings (part 1)

By | Database management | 4 Comments

SharePoint performance is a recursive problem and preoccupation. As a Database Administrator, we have to deal with SharePoint when configuring SQL Server databases. In this article, I will propose a list of best practices in SQL Server settings aimed to reduce SharePoint performance issues. This article is inspired from the presentation Optimizing SQL Server for Speedy SharePoint by Sahil Malik held at the European SharePoint Conference 2014 in Barcelona. Autogrowth Do not keep the default…

Read More
Nathan Courtine

SQL Server 2014: An overview of the New Features

By | Database management | One Comment

The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1’000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveautés by…

Read More