Stéphane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.
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 I will share it with you… CONTEXT All morning, a policy checks orphan database user on all databases from all…
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 domain is COMPRESS and DECOMPRESS. Through a GZIP algorithm, you can compress and decompress an argument for nvarchar, varchar, varbinary, char and binary data…
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… Ich hatte im September in Lausanne einen Vortrag zum Thema Performance-Monitoring und Extended Events präsentiert… Viele Leute kennen das nicht, dass in den system_health des SQL Servers die Informationen zu den Deadlock-Events abgelegt sind. Wo sind…
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 à notre stand. Effectivement, comme l’année passée, nous sommes heureux d’être à nouveau sponsors GOLD de l’événement et seront placés comme le schéma ci-dessous vous le montre. N’hésitez pas…
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 just for 2 drop commands(See List of available objects below): one for a table one for a column in a…
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 System Center (is SQL Server included)??? I answer just “OK, OK, I understand, I wil check those points…” I search those information on…
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 wrote some weeks ago, a blog about JSON Support in SQL Server 2016: SQL Server 2016: native support for JSON With this new CTP version, JSON support…
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 with the db_owner role –> No masking sql login u2 with the db_datareader role –> masking The Data Types used are: xml, date, datetime and varbinary. I run this query…
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 with the db_owner role –> No masking sql login u2 with the db_datareader role –> masking The Data Types used are: sysname, char, nchar, nvarchar and varchar. I run this…
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 with the db_owner role –> No masking sql login u2 with the db_datareader role –> masking The Data Types used are: bit, tinyint, smallint, int, float & money. I run…
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 this new feature to my Oracle colleagues and I’m surprised that Oracle 12c has the same option known as Data Redaction. The principle is simple: for some users, data are masked…
In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since SQL Server 2014, this estimation has been good! See the PS from Paul Randal’s blog for this information, here But…
