Skip to content

Microsoft

SQL Server Security: Ensure that SQL Server service accounts are not a member of the Windows local Administrator group

These last few weeks, I work on a project to check the compliance of an instance with the Center for Internet Security (CIS) document. The Benchmark documentation provides prescriptive guidance to secure SQL Server and I develop a tool to do a security audit automatically following these recommendations. On the Authentication and Authorization Chapter, you have three sub-chapters: These three… 

PosgreSQL + SQL Server = WiltonDB – Part 1 – Installation

I know,  few years ago, it was uncredible to associate SQL Server & PostgreSQL or see Microsoft in the Open source world. 😉 The world changes and we follow it… My colleague Daniel Westermann will enjoy that I write a blog about PostgreSQL but also SQL Server… My first one in 10 years by dbi services but it’s good to… 

Sql Konferenz 2023 in Hanau, Germany

Introduction It was a very great pleasure to participate to the Sql Server konferenz 2023 in Hanau, Germany, the 12 and 13 September 2023. I went with my colleague Petar, of the same Microsoft Sql Server team by dbi services, Switzerland. For Microsoft Sql Server fans, this event was really the right place to be. Where is located Hanau First… 

SQL Server Tools: First steps with go-sqlcmd tool on Windows Server 2022

As you know, with the new version of SSMS since the version 18, the tools like sqlcmd are no more included in the installation. You need to download separately the tools that you need here Few months ago, Microsoft announces the replacement of the “old” sqlcmd with a new version called go-sqlcmd. This new version includes all parameters from the… 

SQL Server Tips: CMS – Connection Error: -2146893019 Severity: 20

Few days ago, I install new instances SQL Server 2022 and the new SSMS by a customer and when I register the instances in the Central Management Servers (CMS), I was surprise by the error coming from the connection test: ERROR Message: A connection was successfully established with the server, but then an error occurred during the login process. (provider:… 

Microsoft:Backup and restore your distribution on WSL

Introduction Hi team I hope you are doing well, in a previous post, we have seen how to enable Windows Subsystem to install Linux distribution. Create a folder to store your backups Example: Right-click: New/Folder/your directory name Identify the distribution name you want to backup In your Powershell prompt type the below command to display all installed distribution on WSL… 

Microsoft Flexible Server Compute V5

Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same vCPU and Memory, but 2TB Storage (7500 IOPs). Microsoft told me that they have replaced the used Linux, from Ubuntu 18.04… 

Flexible Server for PostgreSQL, Status March 2023

As many know about a year ago I wrote some critical posts about Microsofts Flexible Server for PostgreSQL, now it is time to take a look again. At first, many promised functions where delivered with a latency of about one year or more, for example AAD integration or customer keys. One topic was Compute V4, the Cascade Lake Xeon CPUs… 

SQLBits 2022 – Levelling up my Performance Tuning skills

As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022. The SQLBits conference is currently taking place at ExCel London and features over 300 sessions over 5 days. Tuesday and Wednesday, the pre-conference,…