Microsoft Team

Join transitive closure and query simplification considerations

Yesterday, I had a discussion with one of my friend who works with Oracle about some different behaviours between each query optimizer against one particular query. You can read his blog post and get the repro script here. I(…)

SQL Server AlwaysOn and availability groups : how to isolate the replication traffic from other networks?

A couple of days ago, I was involved in a project about implementing availability groups with SQL Server 2014. My customer wanted to isolate the replication traffic from the public network. The idea behind was to get a better control(…)

sp_cursor_fetch and performance considerations

A couple of weeks ago, I performed a SQL Server audit and my customer talked me about a performance issue he faced only during the login phase of its application. After various exchange of information between my customer and the(…)

SQL Saturday Paris le 05 septembre 2015

Durant les prochains SQLSaturday à Paris le 05 septembre 2015, j’aurais l’occasion de co-animer les 2 sessions suivantes: SQL Server 2016 et nouveautés du moteur SQL (avec Christophe Laporte MVP / MCM SQL Server) Optimisation de requêtes sur(…)

SharePoint migration tools

Migration projects are generally complicated. It takes time to complete the project, sometimes involve moving content between incompatible systems, and 100% satisfaction of the stakeholders is hard to get. It’s going the same way with SharePoint Migration(…)

New search capabilities in SharePoint Server 2013-2016

For the ones who have not migrated their environment on SharePoint 2013, or the novices, here is an article in which we will discover the new search capabilities in SharePoint Server 2013. We will have an overview(…)

BEEZY: Social Network for SharePoint 2013

Social Networking.. Everybody is actually “connected”: professional network, private social network… There is so many solutions around as of today. Which one should I use? What are the differences? Regarding the use of  a social work,(…)

SharePoint 2013 – Office 365 & Power BI

Quick reminder of what is SharePoint 2013 and Office 365 SharePoint 2013 SharePoint 2013 is a collaborative platform that allows organizations to increase the efficiency of their business processes. link: https://technet.microsoft.com/en-us/library/cc303422.aspx Office 365 with SharePoint 2013 This is(…)

Dealing with SSRS subscription schedules in AlwaysOn environment

A couple of days ago, I had the opportunity to work with AlwaysOn 2014 infrastructure that included a report server (SSRS) in native and scale-out mode. As you know, dealing with SSRS and availability groups is not an easy task(…)

Don’t use the default database file autogrow settings !

I often noticed default values for database file autogrow settings during my audits. You don’t trust me? Let me talk about a funny story about an incredible (and extreme) situation that concerns a transaction log file and its default settings.