Microsoft

SQL Server 2014: In-memory OLTP project “Hekaton”

I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I’m beginning with the SQL Server In-Memory(…)

Three basic points on SQL Server Best Practice

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(…)

SQL Server 2012: System views poster available

Good news for all SQL Server DBAs: DMVs and DMFs poster are now available for SQL Server 2012. You can download them here. You can choose between 2 formats: pdf and xps. What’s new?(…)

Windows Server 2012 R2: soon available

During North America TechEd, Microsoft released some details on the upcoming release of Windows Server. This new version is called Windows Server 2012 R2 and will be at the heart of the Microsoft Cloud OS. Windows Server 2012(…)

SQL Server 2014: the next version

At TechEd North America 2013, Microsoft introduced a lot of new versions: Windows Server 2012 R2, System Center 2012 R2, Windows 8.1, Visual Studio 2013 and, and, and… SQL Server 2014, of course!8-O You think I’m crazy or(…)

SQL Server 2012: CompoundCurve – a new geospatial feature

There are three new geospatial features in Microsoft SQL Server 2012: CircularString, CurvePolygon, and CompoundCurve. For the fun and as an example, I will test CompoundCurve, a set of circular strings that may be combined with line strings, and(…)

SQL Server 2012: Create & replay a trace with Distributed Replay

My last blog was about installing and configuring Microsoft SQL Server 2012 Distributed Replay. This time, I will show you how you can create a trace and replay it with Distributed Replay Clients on a specific SQL Server target.

SQL Server 2012 SP 1: Third Cumulative Update (CU3) available

Three weeks ago, Microsoft published the third Cumulative Update (CU3) for Microsoft SQL Server 2012 Service Pack one. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which(…)

SQL Server 2012: Installing and configuring Distributed Replay

Distributed Replay is a new fonctionality of Microsoft SQL Server 2012. It helps you assess the impact of future upgrades (SQL Server, hardware, OS) or SQL Server tunings by replaying a trace captured from a productive SQL Server environment(…)

SQL Server 2012: new perfmon counters

I have read some blog postings concerning the new perfmon counters, but I have not seen really extensive overviews yet. In this post, I would like to present not only what is new, but also what has changed (or(…)