Stéphane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.
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) included in VSTS. What is SQL Server Data Tools? These new tools replace BIDS (Business Intelligence Development Studio). But they…
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 volume. The reason is that SQL Server has to use 4-5 worker threads per database in order to manage the…
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 To have more information and download it, click here Historic of SQL Server 2012 If you update your SQL Server…
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, also called EIM
Today it’s the real beginning of the TechEd with several sessions in parallel.
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.
It’s just a little blog to announce you that the first fix for SQL Server 2012 came out last week on Easter Break.
As we approach the release of version of SQL Server 2012, I think a little article about the Licencing is appropriate.
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 the role “securityadmin” to have such rights but with this role you can also manage logins, CREATE DATABASEs and change passwords.
This is “too many rights” for
…
The so called Release to Manufacturing (RTM) version of SQL Server 2012 now is available.
Following my article about Windows 8, today, Microsoft released the customer preview.
It’s just a small article to announce this fresh news!
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 features on Integration Services (SSIS)“, this article presents a summary from new features and enhancements for SQL 2012 Reporting Services.
