Technology Survey

SCOM: change group state to maintenance mode with PowerShell

Some weeks ago, I wrote a blog post about the creation of SCOM groups in order to subscribe to alerts. Subscribe to alert is mandatory, of course, to be able to receive alerts concerning our group. But during operations(…)

SQL Server 2016 is available on msdn

Breaking news lady and gentlemen. In case you missed it, SQL Server 2016 is live from MSDN subscription. As a reminder, this version offers a lot of very interesting new features and enhancements. Here a(…)

SQL Server 2016 RTM – Coming soon!

The first RTM release of SQL Server 2016 will be released soon. It’s official now! Indeed, Microsoft announced here the SQL Server 2016 RTM release being generally available for use the 1st June 2016. What does(…)

SQL Server 2016: Microsoft R Server

In my last article, I wrote about the R Services into SQL Server. Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.

SCOM: Creation of a group in order to subscribe to alerts

I am currently managing at one of my customer a monitoring project that concerns SQL Server instances and SCOM (System Center Operation Manager). The project includes many instances, more or less 50, divided in two environment (Production and Test) and(…)

SQL Server 2016: R Services

I was during a long time captivated by the R programming language. I’m happy to see that SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts. The first(…)

SQL Server 2016: CREATE TABLE for Stretch Database is available

This month, the Release Candidate 1 (RC1) for SQL Server is available. With this new version, you can now use the “CREATE TABLE” command for Stretch Databases. If you read the msdn page(…)

SQL Server 2016: new upgrade advisor

I write this article because it is very interesting to see that the upgrade advisor has evolved… Recently (February 11, 2016), a new version is available: Microsoft® SQL Server 2016® Upgrade Advisor Preview 1.4 The msi package(…)

About SSH keys in Oracle Public Cloud

When working with resources on the Oracle public cloud, whatever it is IaaS or PaaS, the principle access method is based on SSH keys exchange. Once our instance is created this is going to be the first and only way(…)

SQL Server 2016: temporal table with In-Memory

In SQL Server 2016 CTP 3.0, temporal tables with In-Memory OLTP is supported. 🙂 At the JSS2015 (Journée SQL Server 2015), I have presented a little demo about temporal table with a table(…)