Infrastructure at your Service

SQL Server 2017 Archives - Blog dbi services

Stéphane Haby

SQL Server 2017: TRIM not only a replacement of RTRIM and LTRIM

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

Last month, I present in the IT-Tage 2017 in Frankfurt am Main, a session about SQL Server 2017 overview. During my session I made a demo on one of the new string T-SQL Commands: TRIM. My demo was very simple but I have also 2 very good questions. Before, I write about these question, I will show you what is TRIM. This function is a replacement of RTRIM and LTRIM to delete all space character…

 
Read More
Stéphane Haby

SQL Server 2017 RTM is available: time to try!

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Now SQL Server 2017 RTM  is available. The first step is to go to the Evaluation Center here After completing the registration with your contact information, you download the file “SQL Server 2017-SSEI-Eval.exe” Run SQL Server 2017-SSEI-Eval.exe and now it begins! A first screen gives me 3 choices to install SQL Server Basic: easy and fast to download and install SQL Server 2017 Custom: Download the setup package and launch the SQL Installation Center Download…

 
Read More
Stéphane Savorgnano

SQL Server 2017 on RHEL first installation

By | Database Administration & Monitoring | No Comments

Beginning of last week Microsoft announced the general availability of SQL Server 2017 for today, the second of October. In the same time, but in a more marketing side, Microsoft announced a SQL Server on Red Hat Enterprise Linux offer, more information here. It looked for me like the good time to do my first installation of SQL Server 2017 on Linux. My first concern was to download an ISO of the Red Hat Enterprise…

 
Read More
David Barbarin

SQL Saturday Toulouse 2017: SQL Server on Linux – Slide deck

By | Technology Survey | No Comments

#SQLSatToulouse was definitely a great event. Firstly, a big thanks to the organization team (@Guss and @Fredg_31) as well as all the sponsors and attendees (without whom this kind of event would not be possible). As promised, here the slide deck of my session “Introduction to SQL Server on Linux for DBAs“. It was for me a great moment of sharing. Thanks to all!    

 
Read More
David Barbarin

SQL Server 2017 high availability and Resumable Online Indexes

By | Database Administration & Monitoring | No Comments

Ensuring data availability is an important part of the high availability design. SQL Server AlwaysOn features including SQL Server FCIs and availability groups address some aspects of the problem but we may also rely on the online operations features to maximize data availability. Indeed, for some high-critical workloads, offline operations during the maintenance phase are not permitted and may contribute to call into question the entire architecture. But have you ever faced an outage from…

 
Read More
Stéphane Haby

SQL Server 2017: Python server

By | Technology Survey | 2 Comments

After my article SQL Server 2017: first steps with Python Service, I write this article about my first test with the Python Server feature in SQL Server 2017. The installation is very simple, in the features Selection window, you have in the Shared Features, you have a Machine Learning Server (Standalone) with R and Python. I check Python to install the Python Server and here we go. Like for the Python services, you need to…

 
Read More
Stéphane Haby

SQL Server 2017: first steps with Python Service

By | Development & Performance, Technology Survey | No Comments

Last year, I written blogs about SQL Server 2016 and his integration from the R language. Just for information, you can find these blogs about SQL Server 2016 R Services here: SQL Server 2016: R Services SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL? Now, the next version of SQL Server, named officially SQL Server 2017 integrate also the language Python. The first step is to install the Python…

 
Read More
David Barbarin

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

By | Database Administration & Monitoring | No Comments

As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first blog post, I wrote about SQL Server on Linux and the introduction of availability groups features. At this moment the SQL Server release version was CTP 1.3. As a reminder, with previous CTP releases, listeners were unusable because they did not persist when…

 
Read More