Infrastructure at your Service

All Posts By

Microsoft Team

Microsoft Team

Introducing SQL Server on Kubernetes

By | Database Administration & Monitoring | One Comment

After spending some times with Docker Swarm let’s introduce SQL Server on Kubernetes (aka K8s). Why another container orchestrator? Well, because Microsoft gives a strong focus on Kubernetes in their documentation and their events and because K8s is probably one of the most popular orchestration tools in the IT industry. By the way, I like to refer to the Portworx Annual Container Adoption Survey to get a picture of container trend over the years and we…

Read More
Microsoft Team

SQL Saturday Paris 2018 – Pré-conférence SQL Server Linux, Docker et Azure

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

The next SQL Saturday in Paris is coming soon and the agenda has been published by the @GUSS on twitter. Le prochain SQL Saturday Paris arrive bientôt et l’agenda a été publié sur Twitter par le @GUSS Cette année, un savant mélange de speakers francophones et internationaux, un plus pour les participants … Un rapide coup d’œil à l’agenda – si on se focalise sur la partie moteur SQL Server – montre également qu’une bonne…

Read More
Microsoft Team

OpenSSH is now available on Windows 10

By | Database Administration & Monitoring | No Comments

A couple of days ago, the Windows 10 april 2018 update was installed on my laptop. And what, you may say? Well, surprisingly this update provides some interesting “hidden” features and one of them concerns OpenSSH that is now available on-demand in Windows 10 (and likely available soon on Windows Server). This a obviously a good news because so far, I used either putty or directly a bash environment from my Windows 10 laptop available since…

Read More
Microsoft Team

Windocks – a different way to use SQL Server on Docker

By | Database Administration & Monitoring | No Comments

I spent some times to write blog posts about SQL Server on Docker since few months and you likely noticed it concerned mainly SQL Server on Linux. But what about SQL Server on Docker and Windows? If you take a look at the Docker images provided by Microsoft, only 2017 version is available and it is only intended for development and testing use. Versions prior 2017 seem to not be supported so far (but I…

Read More
Microsoft Team

Load Balancing with Docker Swarm mode and SQL Server containers

By | Database Administration & Monitoring | 6 Comments

Docker swarm mode provides an easy way to publish ports for services. Indeed, in this mode all nodes participate in an ingress routing mesh and accept connections to any service port published. Thus, all incoming requests are routed to available nodes hosting a service. That’s a pretty cool feature but it has some drawbacks. Let’s say that a node goes wrong … In this case the application must retry connecting to the next available node…

Read More
Microsoft Team

Managing SQL Server sa credentials with Docker secrets on Swarm

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I was working on a MSSQL Server docker image in a context of Hidora, a swiss cloud provider based on jelastic and for Docker-based applications. When writing my jps manifest file I was agreeably surprised about the section concerning the MSSQL Server credentials information. We may able to define global variables for SQL Server sa password with ${fn.password} as function as shown below: globals: sa_password: ${fn.password} user_password: ${fn.password} nodes: -…

Read More
Microsoft Team

SQL Server on Docker and network bridge considerations

By | Database Administration & Monitoring | 2 Comments

Let’s continue with this blog post series about SQL Server and Docker. A couple of days ago, I was in a customer shop that already implemented SQL Server 2017 on Linux as Docker containers. It was definitely a very interesting day with a lot of customer experience and feedbacks. We discussed with him about lot of architecture scenarios. The interesting point here is I was able to compare with a previous customer who used docker…

Read More
Microsoft Team

Index seek operator and residual IO

By | Database Administration & Monitoring | No Comments

This blog post draws on the previous article about index seek and gotchas. I encountered another interesting case but it is not so much because of the nature of the problem I decided to write this article but rather the different ways that exist to troubleshoot it. Firstly, let’s set the scene: A simple update query and its corresponding execution plan that tend to say the plan is efficient  in terms of performance declare @P0…

Read More
Microsoft Team

Introducing SQL Server on Docker Swarm orchestration

By | Database Administration & Monitoring | One Comment

SQL Server 2017 is available on multiple platforms: Windows, Linux and Docker. The latter provides containerization features with no lengthy setup and special prerequisites before running your SQL Server databases which are probably the key success of adoption for developers. It was my case as developer for our DMK management kit which provide to our customers a SQL Server database maintenance solution on all editions from SQL Server 2005 to SQL Server 2017 (including Linux)….

Read More
Microsoft Team

SQL Server on Linux and logging

By | Database Administration & Monitoring | No Comments

On Windows world, SQL Server logs information both into the SQL Server error log and the Application log. Both automatically timestamp all recorded events. Unlike the SQL Server error log, the Windows application log provides an overall picture of events that occur globally on the Windows operating system. Thus, regarding the encountered issues taking a look at such event logs – by using either the Windows event viewer or the Get-EventLog PowerShell cmdlet – may be very helpful to figure…

Read More