Infrastructure at your Service
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…
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…
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…
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 à…
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…
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…
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…
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….
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…
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…
