Business Intelligence Office 2013 and SQL Server 2012: an integrated, powerful BI solution 13.11.2012 by Stéphane Haby 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(…)
Database management SQL Server 2012: SQL Server Data Tools (SSDT) – Schema and Data Comparison 10.10.2012 by Stéphane Haby 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)(…)
Database management SnapManager for SQL Server: databases limitation policy 06.09.2012 by Stéphane Haby 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(…)
Technology Survey SQL Server 2012: Cumulative Update 3 (CU3) now available 30.08.2012 by Stéphane Haby 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(…)
Technology Survey Stéph@TechEd 2012: End – the new Certification Cycle for SQL Server 2012 29.06.2012 by Stéphane Haby 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,(…)
Technology Survey Stéph@TechEd 2012: Episode2 – SQL Server 2012 & Windows Server 2012 26.06.2012 by Stéphane Haby Today it’s the real beginning of the TechEd with several sessions in parallel.
Technology Survey SQL Server 2012: First cumulative update is online 18.04.2012 by Stéphane Haby 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.
Technology Survey SQL Server 2012: First fix has arrived 11.04.2012 by Stéphane Haby It’s just a little blog to announce you that the first fix for SQL Server 2012 came out last week on Easter Break.
Database management SQL Server 2012: New Licensing 02.04.2012 by Stéphane Haby As we approach the release of version of SQL Server 2012, I think a little article about the Licencing is appropriate.
Database management SQL Server 2012: How to create a Server Role? 15.03.2012 by Stéphane Haby 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(…)