Infrastructure at your Service

SQL Server 2012 Archives - Page 2 of 7 - Blog dbi services

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

SQL Server & memory leak: Are you sure?

By | Database management | 2 Comments

I have recently come across an issue with one of my customer that told me that their SQL Server 2008 R2 instance had a memory leak. These are strong words! The server has 64 GB of RAM and the concerned SQL Server instance is limited to 54 GB according to the max server memory (GB) server option. However, he noticed that SQL Server used 60 GB of memory which did not correspond to the configured…

 
Read More
David Barbarin

SQL Server failover cluster, VSphere, & SCSI-3 reservation nightmares

By | Operation systems | No Comments

When I have to install a virtualized SQL Server FCI at a customer place as an SQL Server consultant, the virtualized environment usally is ready. I guess this is the same for most part of the database consulting people. Since we therefore lack practice, I have to admit that we do not always know the good configuration settings to apply to the virtualized layer in order to correctly run our SQL Server FCI architecture. A…

 
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
David Barbarin

SQL Saturday 323: SQL Server AlwaysOn and availability groups session slides

By | Hardware & Storage | 4 Comments

This SQL Saturday’s edition in Paris is now over. It was a great event with a lot of French and international speakers. There were also many attendees indicating that this event is a great place to share about SQL Server technologies. Maybe the Montparnasse tower in Paris played a role here with its panoramic view over Paris from the 40th floor! For those who didn’t attend on Saturday, you will find our SQL Server AlwaysOn…

 
Read More
David Barbarin

SQL Server: DBCC CHECKDB does not detect corruption

By | Database management | 3 Comments

During my audits at customer places, it still happens very often to find SQL Server databases with page verification option configured to “none”. I always alert my customers on this configuration point because it can have an impact on the overall integrity of their databases. One of my customer told me that the integrity task of its maintenance will detect the corruption anyway and alert him by email – but is it really the case?…

 
Read More
David Barbarin

SQL Saturday in Paris on 12 -13 September

By | Database management | No Comments

As you certainly know SQL Saturday events are very popular in SQL Server world community. This is the second time the event takes place in Paris (France), but this time, we have a new format with pre-conferences on Wednesday and classic sessions on Saturday. During pre-conferences, we will talk about a particular subject for a whole day. This time, I have the opportunity to participate twice by giving two sessions (in French) with the following program:…

 
Read More
Nathan Courtine

Master Data Services installation for SQL Server 2012

By | Database management | One Comment

This posting is a tutorial for installing Master Data Services on your Windows Server 2012. Microsoft SQL Server Master Data Services (MDS) is a Master Management product from Microsoft, code-named Bulldog. It is the rebranding of the Stratature MDM product, titled +EDM and acquired in June 2007 by Microsoft. Initially, it was integrated for the first time in Microsoft SQL Server 2008 as an additional installer. But since SQL Server 2012, Master Data Services is…

 
Read More
Stéphane Haby

SQL Server: How to find the default data path?

By | Database management | 4 Comments

I have read a lot of SQL Server blog postings and articles in order to find the default data path. This post covers different SQL Server versions (SQL Server 2012, SQL Server 2014, SQL Server 2008, SQL Server 2005) and provides a generic script with different methods. Search with SERVERPROPERTY Since SQL Server 2012, we can use the parameter “InstanceDefaultDataPath” in the T-SQL command SERVERPROPERTY. More information on msdn here. Test with SQL server 2008…

 
Read More