Database Administration & Monitoring, Technology Survey SQL Server 2016: Always Encrypted 24.06.2016 by Stéphane Savorgnano One of the top new features of SQL Server 2016 is the Always Encrypted functionality. Always Encrypted provides that data, store in a database, remains encrypted the all times there are in the database. There is a complete separation between(…)
Database Administration & Monitoring, Operating systems, Technology Survey SCOM: schedule group maintenance task with PowerShell 08.06.2016 by Stéphane Savorgnano In my last blog post, here, I spoke about how to place SCOM group in maintenance mode. This script is really interesting with an integration in Windows Task Scheduler. At the end, the main purpose is to plan a(…)
Database Administration & Monitoring, Database management, Operating systems, Technology Survey SCOM: change group state to maintenance mode with PowerShell 07.06.2016 by Stéphane Savorgnano 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(…)
Database Administration & Monitoring, Technology Survey SCOM: Creation of a group in order to subscribe to alerts 27.04.2016 by Stéphane Savorgnano 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(…)
Database Administration & Monitoring Windows Containers: Migration 17.03.2016 by Stéphane Savorgnano In my last blog post (here), I explained how to configure a host for Windows Container as well as how to use some Windows Container cmdlets. Finally I demonstrated how to create a container with a SQL Server 2014(…)
Database Administration & Monitoring Windows Container: installation and utilization 15.03.2016 by Stéphane Savorgnano Some weeks ago, I did a general presentation about Windows Server 2016 and the new Container feature (here). Today, I will go through the installation and utilization of Windows Containers. I will use a Virtual Machine, under Hyper-V, during(…)
Operating systems, Technology Survey Windows Server 2016: Containers 14.12.2015 by Stéphane Savorgnano One of the new feature which will come with Windows Server 2016 is the Containers. Microsoft made available its fourth technical preview of his Windows Server 2016 platform some days ago. This new Technical Preview brings with it and for(…)
Database management, Technology Survey SQL Server 2016 CTP3.0: Stretch Database enhancements 26.11.2015 by Stéphane Savorgnano Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and(…)
Database Administration & Monitoring SQL Server 2016: New possibilities for Index Maintenance Task 16.10.2015 by Stéphane Savorgnano The new CTP 2.4 has been released some weeks ago by Microsoft. My colleagues and I have already blogged about some new functionalities. I will focus in this blog about the new possibility of Index Maintenance Tasks regarding Indexes. Until(…)
Database Administration & Monitoring SQL Server 2016: Transaction Performance Analysis Overview & In-Memory OLTP Migration Checklists 28.09.2015 by Stéphane Savorgnano To be able to define which Tables or Stored Procedures will us the best performance gain after migration to In-Memory OLTP, SQL Server 2014 provided a tool called AMR (Analysis Migration and Reporting). This tool was really interesting but we(…)