Infrastructure at your Service

Category Archives: Technology Survey

Stéphane Haby

Trace Flag 4199 or not in SQL Server 2016?

By | Technology Survey | 2 Comments

Some Trace Flag like T1117 and T1118 are no more needed as you can read on David’s blog. But that’s not all, you have also the T4199… What’ does the Trace Flag T4199? This Trace Flag enables all query optimizer fixes. A lot of DBAs have enabled this Trace Flag globally during the build of a new server. If you want to take advantage of an enhancement or a fix, the T4199 becomes a necessity……

 
Read More
Stéphane Savorgnano

SQL Server 2016: Always Encrypted

By | Database Administration & Monitoring, Technology Survey | One Comment

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 persons who own the data and person who manage it. Only persons who own the data can see plain text data and person like DBAs, sys admins or privilege logins cannot have access to the…

 
Read More
Stéphane Savorgnano

SCOM: schedule group maintenance task with PowerShell

By | Database Administration & Monitoring, Operation systems, Technology Survey | No Comments

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 maintenance window of our different servers. Let’s see how we can do that with PowerShell script. First, I try to use the cmdlet Register-ScheduledTask, which can be used to register a scheduled task definition on a…

 
Read More
David Barbarin

SQLSaturday #510–Locks, latches et spinlocks

By | Technology Survey | No Comments

J-16 avant le prochain SQL Saturday à Paris et il est encore temps de s’inscrire.  Le prochain SQL Saturday en quelques chiffres c’est: 4 parcours 20 sessions + Chalk-Talk 9 nationalités 15 speakers francophones 10 speakers anglophones de réputation internationale En résumé un événement à ne pas louper! Pour ma part j’aurais l’opportunité de parler du verrouillage logique et physique sous SQL Server (dernière session de la journée). En guise d’appetizer: débogage de problèmes de latch…

 
Read More
Stéphane Savorgnano

SCOM: change group state to maintenance mode with PowerShell

By | Database Administration & Monitoring, Database management, Operation systems, Technology Survey | No Comments

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 like an update, a patching, …, we don’t want to be spoiled by lots of alerts. To avoid those unexpected Emails, we need to place our group and so, objects contained in this group, in maintenance…

 
Read More
David Barbarin

SQL Server 2016 is available on msdn

By | Technology Survey | No Comments

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 summary of the new features per edition.   From my part, I’m looking forward to see what it was made of in real customer cases, especially new high-availability and performances features. As said by Microsoft in this official blog post, we may potentially notice large…

 
Read More
David Barbarin

SQL Server 2016 RTM – Coming soon!

By | Technology Survey | No Comments

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 this mean? Well, customers who have been thinking either to upgrade their SQL Server environments or to install a new architecture can now include SQL Server 2016 in their plan. As you already know, SQL Server 2016 will provide…

 
Read More
Stéphane Haby

SQL Server 2016: Microsoft R Server

By | Development & Performance, Technology Survey | No Comments

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. On the Microsoft Website, you can download directly R Server 2016 for different operating systems: Windows of course SUSE Linux Red Hat Linux Version for Hadoop on Red Hat Version for Teradata DB Here is the link Installation In the SQL Server Installation Center…

 
Read More
Stéphane Savorgnano

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

By | Database Administration & Monitoring, Technology Survey | No Comments

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 different versions of SQL Server as 2008, 2012 and 2014. The defined target was to create two groups of instances, respectively Production and Test, in order to manage differently the alert’s subscription. Let’s see how…

 
Read More
Stéphane Haby

SQL Server 2016: R Services

By | Development & Performance, Technology Survey | 3 Comments

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 step is to install the R Services during the installation of SQL Server. As you can see on the picture, you have 2 selections in the feature Selection Menu: R Services (In-Database) is the service that enable…

 
Read More