Infrastructure at your Service
In a previous blog post called Backup a SQL Server database from On-Premise to Azure, I presented the different tools to backup your on-premise databases on Azure Storage. SQL Server Managed Backup to Windows Azure was one of these tools. In my opinion, Managed Backup is a great tool. That is why I decided to dedicate an entire blog to this feature. Understanding Managed Backup Managed Backup is a new feature introduced in SQL Server…
The end of the year approachs and soon it will be time to celebrate Christmas with your family and friends. At dbi services, we wish you a merry christmas via SQL Server with the following script, to execute in your SQL Server Management Studio for example (supported only by SQL Server 2012 and SQL Server 2014). You will find a suprise in the result pane 🙂 SET NOCOUNT ON; IF EXISTS(SELECT * FROM…
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…
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….
