SQL Server 2012

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

SnapManager for SQL Server: databases limitation policy

I recently talked to a customer about SnapManager, its recommendation on the number of databases and about a way to prevent the creation of more than 35 databases. The NetApp recommendation is no more than 35 databases on a single(…)

SQL Server 2012: Cumulative Update 3 (CU3) now available

This week, the third cumulative update was made available on the Microsoft website. What is in this CU for SQL Server 2012? This CU has 36 hotfixes: 25 for the engine 1 for SSAS 4 for SSIS 6 for SSRS(…)

Stéph@TechEd 2012: End – the new Certification Cycle for SQL Server 2012

For this last day () of the TechEd 2012, I going to present the new certification cycle for dba who wants to be certified for SQL Server 2012. But before, let's start with a brief introduction on Enterprise Information Management,(…)

SQL Server 2012: First cumulative update is online

In my precedent article, I announce you the first fix for SQL Server 2012. One week after, the first cumulative update is downloadable on Microsoft website for SQL Server 2012.

SQL Server 2012: First fix has arrived

It’s just a little blog to announce you that the first fix for SQL Server 2012 came out last week on Easter Break.

SQL Server 2012: New Licensing

As we approach the release of version of SQL Server 2012, I think a little article about the Licencing is appropriate.

SQL Server 2012: How to create a Server Role?

Recently, during my many missions, a client asked me to give access rights to the SQL Server Logs from SSMS to his application managers.   As you know, you must give(…)

SQL Server 2012: RTM now available

The so called Release to Manufacturing (RTM) version of SQL Server 2012 now is available.

SQL Server 2012: new features for Reporting Services (SSRS)

I decided to take some times in this cold February's month to continue this small series. This time, I'm going to speak about Reporting Services (SSRS) and these new features.Like my other article "SQL Server 2012: New(…)