Database Administration & Monitoring, Technology Survey SQL Server 2016 – Security: Dynamic Data masking 23.10.2015 by Stéphane Haby After my first blog on Security with Row level Security, I test the second Security new feature in the next version of SQL Server: Dynamic Data Masking. I presented(…)
Database Administration & Monitoring, Database management, Technology Survey SSISDB is too big and it is not every time the retention period’s fault! 09.10.2015 by Stéphane Haby In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I(…)
Database Administration & Monitoring, Technology Survey Row Level Security (RLS) is also coming to MS SQL Server 29.09.2015 by Stéphane Haby Why “also” in my title? On 29 August, my colleague Daniel Westermann wrote an article about Row Level Security in the next version of PostgreSQL. Row Level(…)
Database Administration & Monitoring, Technology Survey SQL Server 2016: Upgrade Advisor 14.09.2015 by Stéphane Savorgnano During the read of a blog of my colleague Nathan Courtine about Stretch database, I installed the version of SQL Server 2016 Upgrade Advisor and Oh surprise! it looks really NEW! “A new generation of advisor tool for SQL(…)
Technology Survey SQL Server 2016: the Time Travel with temporal table – Part IV 28.08.2015 by Stéphane Haby Maintenance & Metadata My last chapter is about the maintenance backup/restore, index rebuild/reorg., etc. and the Metadata. I divide my article into 4 parts to be clearer and easier to read:(…)
Technology Survey SQL Server 2016: the Time Travel with temporal table – Part III 28.08.2015 by Stéphane Haby SELECT command In this article, I present the last command SELECT. I divide my article into 4 parts to be clearer and easier to read: Part I – Principle &(…)
Technology Survey SQL Server 2016: the Time Travel with temporal table – Part II 28.08.2015 by Stéphane Haby INSERT, UPDATE & DELETE commands After the introduction and the table creation, in this second part, I present the 3 important commands INSERT, UPDATE & DELETE. I divide my article into 4 parts to be clearer and easier to(…)
Technology Survey SQL Server 2016: the Time Travel with temporal table – Part I 28.08.2015 by Stéphane Haby Principle & Creation Microsoft create in SQL server 2016 a new feature temporal table, based on the latest edition of the SQL standard: SQL:2011. If you want read more about this standard, click here. I(…)
Technology Survey How to solve accent sensitive problems? 16.07.2015 by Stéphane Savorgnano Some days ago, one of my customer claimed that searching for “Muller” doesn’t return “Mueller” and “Müller” as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem?(…)
Technology Survey SQL Server 2014: Analysis, Migrate and Report (AMR) – a powerful In-Memory migration tool 17.06.2015 by Stéphane Savorgnano An important new functionality of Microsoft SQL Server 2014 is the In-Memory OLTP engine, which enable you to load Tables and also Stored Procedures In-Memory for a very fast response time. The goal is not to load(…)