Infrastructure at your Service

All Posts By

Microsoft Team

Microsoft Team

SQL Server 2014: Hekaton memory optimized tables, hash indexes, and bucket counts

By | Application integration & Middleware | One Comment

For my first blog post at dbi services, I think it could be a good opportunity to begin by discussing around SQL Server 2014, Hekaton memory optimized tables, and hash indexes. When you create a memory optimized table you have to consider the number of buckets that you have to reserve for its associated hash index. It’s an important aspect of configuration because after creating your table, you cannot change the number of buckets without…

Read More
Microsoft Team

IT Pro TechDays 2013 in Lausanne: BYOD, SQL Server & SharePoint

By | Technology Survey | No Comments

I had the opportunity to attend the IT Pro day at the Microsoft Techdays in Lausanne. Let me give you a few insights on my day there. Being a SharePoint specialist but also ramping up on Microsoft SQL Server I tried to balance between SQL and SharePoint related sessions. BYOD As usual, the day started with a Keynote focusing on an overview of the new Windows 8.1 and Windows Server 2012 R2 features. Well… it…

Read More
Microsoft Team

Collation changes in Microsoft SQL Server are not that simple

By | Database management | 4 Comments

Lots of DBAs are changing the collation of their SQL Server databases without knowing exactly what they do and the consequences of this change. And as they don’t know what they do, they often only perform the small and easiest part of it, changing only the collation on the database. In this blog I will explain the methodology that allows to change the collation of all objects (not only the database) and the consequences of…

Read More
Microsoft Team

Three basic points on SQL Server Best Practice

By | Technology Survey | No Comments

A few weeks ago, I went to the Swiss Database Days 2013 and followed the “Practical SQL Server Performance Troubleshooting” workshop. During this workshop, I have seen a different way of troubleshooting, but I was surprised to see that some participants were not aware that some basic SQL Server Best Practice do not depend on the instance settings. This blog posting is a reminder of some of these points. Swiss Database Days 2013: SQL Server…

Read More
Microsoft Team

SQL Server: Attunity connectors for data transfer to Oracle

By | Application integration & Middleware | 4 Comments

Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.

Read More