Infrastructure at your Service

Category Archives: Technology Survey

Stéphane Savorgnano

SQL Server 2016: Always Encrypted – part 2

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

In my last blog post about SQL Server 2016 Always Encrypted, here, I showed how to use this new functionality but also that you have to separate the different execution context with an Application server, a database server and a security server to avoid that certificate will be available for all users and break the segregation. Let’s see how to build those environment. In my security server named SQL2016-2, I first create a Self-signed certificate…

 
Read More
Stéphane Haby

SQL Server 2016 – Query Store: retrieve query that doesn’t appear!

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

For our event SQL Server 2016 in September, I am studying the new functionality Query Store. My colleague David Barbarin have written few months ago about Query Store and how it’s working. Simple SELECT Query To begin, I execute a simple SELECT on a table with 3 different methods: SELECT * FROM QS_test; exec sp_executesql N’SELECT * FROM QS_test’ EXEC sp_GetQS_test; The “sp_GetQS_test” is a stored procedure with the select statement. I created a little…

 
Read More
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