BE SHARING

Author: Stéphane Haby

Business Intelligence

SQL Server 2012: new features for Integration Services (SSIS)

10.02.2012 by Stéphane Haby

Like the others products of SQL server 2012, Integration Services has a lot of new features and enhancements.

Database Administration & Monitoring

SQL Server 2012: Feature Pack

26.01.2012 by Stéphane Haby

Since the third CTP version of SQL Server 2012 codename Denali, you have some features available to provide an additional value for Microsoft® SQL Server 2012 like the other SQL Server versions. This Feature Pack or Manageability Tool Kit are(…)

Database management

Forefront Endpoint Protection (FEP) 2010 and database policies

01.01.2012 by Stéphane Haby

I have seen at a customer that the SQL Server's policy doesn't follow the Microsoft's recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn't exist in(…)

Technology Survey

SQL Server 2012 Express LocalDB RC0 is Available

09.12.2011 by Stéphane Haby

Since a few days, Microsoft® SQL Server® 2012 Express LocalDB Release Candidate 0 is online.

Technology Survey

SQL Server 2012 ‘Denali’: the Release Candidate is available

21.11.2011 by Stéphane Haby

We looked forward to and it has finally arrived... Since Friday, Microsoft® SQL Server® 2012 Release Candidate 0 is online.

Database management

SQL Server 2012 ‘Denali’: a new panel of DMVs

17.11.2011 by Stéphane Haby

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.Since few months, I test the future new version SQL Server 2012 codename Denali and(…)

Hardware & Storage

SQL Server 2012 ‘Denali’ : AlwaysOn High Availability – Restore is blocked

17.10.2011 by Stéphane Haby

During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you(…)

Hardware & Storage

Windows Server 8 Hyper-V 3.0: a real step forward in virtualization

14.10.2011 by Stéphane Haby

As we are on Microsoft Connection Days 2011 in Lausanne yesterday, we have a presentation of Windows Server 8 and specifically of Hyper-V 3.0.I take this opportunity to introduce some news about this.

Business Intelligence

SQL Server vNext : ‘Denali’ is 2012 and ‘Crescent’ is PowerView

13.10.2011 by Stéphane Haby

Today, Microsoft gives us his secrets of the next SQL Server version.

Application integration & Middleware

SQL Server Tuning: Detect SPARSE columns candidate

19.09.2011 by Stéphane Haby

dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.The property of Spare columns is not the most used in client environment that we(…)