Microsoft SQL Server in practice: installation, Always On availability groups, backup and restore, performance tuning, security, PowerShell automation, SQL Server on Linux and upgrades.
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…
Les journées SQL Server se dérouleront dans un mois à Paris dans les locaux de Microsoft. L’agenda n’a été qu’en parte dévoilé mais c’est avec plaisir que je peux dores et déjà vous annoncer que dbi services sera de la partie cette année encore en tant que speaker et sponsor de l’événement. Pour ma part j’aurai le plaisir de vous…
As you certainly know, the well-known tool SQLIO is officially deprecated since few months. From my part, I had the opportunity (maybe the last) to use SQLIO for a customer project in order to benchmark the storage for SQL Server AlwaysOn and availability groups. Now it’s time to change for a new benchmark tool : DiskSpd. First of all, DiskSpd…
Yesterday, I had a discussion with one of my friend who works with Oracle about some different behaviours between each query optimizer against one particular query. You can read his blog post and get the repro script here. I decided to write a blog post because our discussion has introduced some interesting concepts and I wanted to explain more things…
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: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used…
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 & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part IV – Maintenance & Metadata SQL Server version/built used for this serie of articles is…
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 read: Part I – Principle & Creation Part II – INSERT, UPDATE & DELETE commands Part III – SELECT command Part…
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 divide my article into 4 parts to be clearer and easier to read: Part I – Principle & Creation Part II – INSERT, UPDATE &…
A couple of weeks ago, I performed a SQL Server audit and my customer talked me about a performance issue he faced only during the login phase of its application. After various exchange of information between my customer and the software editor, they noticed that this problem doesn’t occur when the application and the SQL Server instance are on the…
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? The collation of the database is Latin1_General_CI_AS, so a case insensitive and accent sensitive collation. If a run the following query:…
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 all the database In-Memory but just Tables with critical performances and Stored Procedures with complex logical calculations. To identify which Tables or Stored…
A lot of discussions and most important, a feature requests in the Microsoft connect site here with more than 1000 votes is the origin of this new feature in SQL Server 2016. A lot of NoSQL have already this function and PostgreSQL for example have the json_extract_path_text functionality and you can at every time ask my colleague Daniel Westermann one of…
