Microsoft

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

SQL Server 2012 SP1: Second Cumulative Update available (CU2)

A couple of days ago, Microsoft published the second Cumulative Update (CU2) for Microsoft SQL Server 2012 SP1. If this CU covers an issue you are experiencing, you should install it quickly. Otherwise, it is not mandatory. Which issues(…)

SQL Server View problem in LightSwitch 2012

I recently faced a problem in Visual Studio LightSwitch 2012 with SQL Server views. I attached an external datasource to my project and when I tried to import my view (which is very simple) I experienced some issues. Here(…)