Microsoft SQL Server in practice: installation, Always On availability groups, backup and restore, performance tuning, security, PowerShell automation, SQL Server on Linux and upgrades.
La prochaine édition du 24 Hours of PASS 2017 edition francophone se déroulera les 29-30 juin prochain. Pour rappel le format est simple: 24 webinars gratuits répartis sur 2 jours de 07:00 à 18h00 GMT et en Français. La seule obligation: s’inscrire aux sessions auxquelles vous assisterez. Cela vous permettra également de récupérer l’enregistrement vidéo si vous voulez la visionner à nouveau…
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…
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…
I’m pleased to announce that Microsoft gives now the opportunity to choose Linux as a new operating system for SQL Server. To try this new version, you can find in the Cloud Azure a new template in the marketplace. In the search bar, tape “SQL Server vnext” and you’ll find the “SQL Server vNext on Red Hat Enterprise Linux 7.2”.…
If you have restricted access to the server and you do not know if your packages are installed on the SQL Server with the R Services, you have the possibility to do it by T-SQL. The R command/function to use is “installed.packages()”. As you can read in the R Documentation for installed.packages(), this function scans the description of each package.…
Now, in the latest version of SQL Server, you have one of the most expected function as well as for developers as for administrators, splitting a string natively in T-SQL: STRING_SPLIT(<character expression>,<separator>) This function has 2 parameters: The character expression with a data type of nvarchar,varchar,nchar or char The separator with a data type of nvarchar(1), varchar(1), nchar(1) or char(1)…
Did you ever consider an index seek as an issue? . Well, let’s talk about a story with one of my customers where the context is pretty simple: a particular query that is out of the range of the application’s performance requirements (roughly 200ms of execution time in average). The execution plan of the query was similar to what you…
Some Trace Flag like T1117 and T1118 are no more needed as you can read on David’s blog. But that’s not all, you have also the T4199… What’ does the Trace Flag T4199? This Trace Flag enables all query optimizer fixes. A lot of DBAs have enabled this Trace Flag globally during the build of a new server. If you…
Breaking news lady and gentlemen. In case you missed it, SQL Server 2016 is live from MSDN subscription. As a reminder, this version offers a lot of very interesting new features and enhancements. Here a summary of the new features per edition. From my part, I’m looking forward to see what it was made of in real customer cases, especially new…
In this blog post, let’s talk about a weird situation where I faced a nonclustered columnstore issue with SQL Server 2012. Let’s say we are in the same context than this previous blog post here. So as a reminder, we decided to benefit from the columnstore index feature after installing a new SQL Server 2012 based infrastructure at my customer…
The first RTM release of SQL Server 2016 will be released soon. It’s official now! Indeed, Microsoft announced here the SQL Server 2016 RTM release being generally available for use the 1st June 2016. What does this mean? Well, customers who have been thinking either to upgrade their SQL Server environments or to install a new architecture can now include…
In my last article, I wrote about the R Services into SQL Server. Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016. On the Microsoft Website, you can download directly R Server 2016 for different operating systems: Windows of course SUSE Linux Red Hat Linux Version for Hadoop on Red Hat…
