Infrastructure at your Service

SQL Server 2014 Archives - Page 3 of 7 - Blog dbi services

Nathan Courtine

How to store SQL Server data files in Azure Storage

By | Database management | One Comment

A new functionality, introduced with SQL Server 2014, enables to store data files from a SQL Server database in Windows Azure Storage. In this posting, I will show how it works.   Accessing Azure Storage The Azure Storage account is named “dbiservices”, and is composed of the “datafiles” container. This container does not contain blobs yet. If you are not familiar with the Windows Azure Storage terms, you should read this Introduction to Microsoft Azure…

 
Read More
David Barbarin

SQL Server 2014 : sortie du livre “Développer et administrer pour la performance”

By | Technology Survey | No Comments

Un billet en cette fin d’année qui approche à grand pas pour vous annoncer la sortie prochaine (fin décembre 2014) du livre SQL Server 2014 : Développer et administrer pour la performance en français et auquel j’ai eu l’immense plaisir de participer avec Frédéric Brouard (alias SQLPro – MVP SQL Server), Nicolas Souquet (alias Elsuket – MVP SQL Server) et Christian Soutou. Ce livre est destiné aussi bien aux développeurs qu’aux administrateurs débutants ou confirmés…

 
Read More
Stéphane Haby

SQL Server tips: how to list orphaned logins

By | Database management | No Comments

I read a lot of about orphaned database users in SQL Server, but I have almost never read about orphaned logins. Many of my customers migrate or remove databases in SQL Server. They forget – not every time but often – to remove the logins and jobs associated with these databases. I have created a script – without any cursors, YES, it is possible – allowing to search all logins who are not “attached” to…

 
Read More
David Barbarin

Journées SQL Server 2014: il n’est pas trop tard pour vous inscrire

By | Technology Survey | No Comments

Le plus grand événement français va bientôt avoir lieu (1 et 2 décembre) à Paris et il vous reste  encore une semaine pour vous y inscrire! Pensez également à commander votre lunch box, ce qui peut être pratique si vous voulez manger     Pour ma part j’aurai l’occasion d’ouvrir le bal et de vous retrouver au cours d’une session sur SQL Server et les groupes de disponibilité (cela devient presque une habitude) lundi matin à…

 
Read More
David Barbarin

SQL Server 2014: buffer pool extension & corruption

By | Database management | No Comments

I had the opportunity to attend Paul Randal’s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension (BPE). As you probably know, BPE only deals with clean pages. Paul hesitated a lot and asked us to test and this is exactly what I will do in the blog post. First, let’s start…

 
Read More
David Barbarin

Pass summit 2014: My favorite sessions of this great event

By | Technology Survey | No Comments

The Pass Summit 2014 is now over and it’s time for us to go back home. I want to share my favorite sessions with you in this post.   Pass Summit was really an amazing event regardless of the expertise area (BI or SQL Server engine). This was also a good opportunity to meet SQL Server guys in others countries as well as the French SQL Server community. We attended a lot of interesting sessions…

 
Read More
David Barbarin

Pass Summit 2014: the beginning

By | Technology Survey | No Comments

This is our first time with Stéphane Haby at this amazing SQLServer community event. At 7:30 am, we were already in the conference center at the registration desk. They gave us a funny badge     So, after breakfast time, we went to the keynote session.     During this session we listened to a speech of SQL Pass President Thomas Larock. The SQLPass community is growing over time. The following picture gives you a…

 
Read More
Stéphane Haby

Les journées SQL Server 2014 – un event qui devrait vous intéresser!

By | Technology Survey | No Comments

Comme vous le savez peut-être déjà, le plus grand événement SQL Server francophone arrive bientôt. Les journées SQL Server 2014, organisées par le GUSS, (Groupement des Utilisateurs SQL Server) sont à Paris les 1 et 2 décembre 2014. dbi services y est aussi – et vous?   Les journées SQL Server 2014 Voici le site de l’event: http://guss.pro/2014/12/01/journees-sql-server-2014/ Les 2 jours traitent aussi bien de l’administration, du développement que de la BI SQL Server 2014….

 
Read More
Stéphane Haby

SQL Server 2014 Tips: Create indexes directly via CREATE TABLE

By | Application integration & Middleware | 2 Comments

This week, I discovered a new enhancement which is not hidden but not really visible in SQL Server 2014. Among Hekaton and other new features in SQL Server 2014, a little option appears in table creation.8-O On the msdn website, we can see a new section in the “CREATE TABLE” code:   We can directly create an index in the “CREATE TABLE” query. Ok, then let’s go! In my example, I create a diver table with…

 
Read More
David Barbarin

SQL Server 2014: classic commit vs commit with delayed durability & I/Os

By | Application integration & Middleware | 4 Comments

When you learn about SQL Server, you will often hear that a commit transaction is a synchronous operation and that you can trust it. In this blog post, I will provide some details about what we mean by synchronous behavior. The reason is that sometimes, when I talk about the new delayed durability feature provided by SQL Server 2014, there are some confusions. If you want more details on this new feature, please read the…

 
Read More