Stéphane Haby

SQL Server 2014 CTP1 is available

Last week, I gave you some news about SQL Server 2014 (here). SQL Server 2014 Community Technology Preview 1 (CTP1) now is available for download on TechNet here (you need a TechNet subscription).  (…)

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

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: 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: Configuring your TCP Port via Powershell

Changing the default TCP port 1433 for SQL Server is an important step for securing your SQL Server. I have written a script in PowerShell to modify the port number that helps me perform this task. This blog posting will show(…)

SQL Server 2012: First Hotfix for Service Pack 1 available

This month, Microsoft has released the first hotfix for SQL Server Service Pack 1. Analysis This Hotfix concerns the installation of SQL Server components and Analysis Services. If you have installed the RTM version with Analysis Service and successfully installed(…)

SQL Server 2012: new permissions

For this end of the year, I decided to present you the new permissions on SQL Server 2012. How to have a list of all permissions ? It’s very simple with this query: SELECT * FROM sys.fn_builtin_permissions(”) SQL(…)

Office 2013 and SQL Server 2012: an integrated, powerful BI solution

I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D First, what are(…)

SQL Server 2012: SQL Server Data Tools (SSDT) – Schema and Data Comparison

In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The “Schema and Data Comparison” feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude)(…)