Technology Survey Journées SQL Server 2015: Retrouvez nos sessions sur SlideShare et Youtube! 24.12.2015 by Stéphane Haby Avant de partir pour des vacances bien méritées et une année pleine d’aventures sur SQL Server, je fais un dernier petit article pour vous informer que nos sessions des Journées SQL Server 2015 sont disponible sur SlideShare et(…)
Database Administration & Monitoring Delete an orphan user-database under SSISDB 24.12.2015 by Stéphane Haby I post a little tips for orphan database-users that we cannot drop so easily in the SSISDB… I discovered this by a customer and it was very tricky to find the explanation and the solution. This is the reason why(…)
Technology Survey SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS 14.12.2015 by Stéphane Haby In live from the JSS2015 (Journée SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days. One new feature available for this release in the T-SQL(…)
Development & Performance SQL Server Extended Event: Eine Deadlock-Event aus der “system_health” Überwachung 10.12.2015 by Stéphane Haby Wie Sie vielleicht wissen, gibt es eine Überwachung über Extended Events: system_health. Kürzlich fragt mich ein Kunde an, um ein zufälliges Deadlock-Problem zu analysieren...
Technology Survey Journées SQL Server (JSS) 2015 à Paris – Sessions & Sponsoring 11.11.2015 by Stéphane Haby Faisant suite à la première annonce de David Barbarin sur les journées SQL Server du 30 novembre et 1er décembre, j’ai le plaisirs de vous inviter à venir nous voir également(…)
Development & Performance, Technology Survey SQL Server 2016: IF EXISTS is included in the DROP command 09.11.2015 by Stéphane Haby With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested(…)
Application integration & Middleware, Development & Performance SQL Server Collation for System Center Products 05.11.2015 by Stéphane Haby A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in(…)
Development & Performance, Technology Survey SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0! 02.11.2015 by Stéphane Haby For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I(…)
Database Administration & Monitoring, Technology Survey SQL Server 2016 – Security: Dynamic Data Masking – Other Data Types 23.10.2015 by Stéphane Haby This blog is a part of the series "SQL Server 2016 - Security: Dynamic Data Masking". I remember you my different logins used to connect to AdventureWorks: sql login u1(…)
Database Administration & Monitoring, Technology Survey SQL Server 2016 – Security: Dynamic Data masking – String Data Types 23.10.2015 by Stéphane Haby This blog is a part of the series "SQL Server 2016 - Security: Dynamic Data Masking". I remember you my different logins used to connect to AdventureWorks: sql login(…)