Microsoft

SQL Konferenz 2024 – Microsoft Copilots

Today, we followed (with Roger Schönmann) the first day of the SQL Konferenz 2024.  We will be attending this event from October 01 to 02 in Hanau. At dbi services, we are no strangers to this conference, as(…)

M-Files What’s new?

As you may know, M-Files is providing monthly release and the one for October is going to be interesting. Since several month M-Files is heavily working on the integration of new Microsoft approach which is aligning desktop and web clients(…)

SQL Server: The importance of the default language during a login migration

Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about “conversion of a varchar data type to datetime data type” on this application.The error was an(…)

“Edit Top 200 rows” does not work between SSMS 18.12.1 & SQL Server 2022

Recently after a migration from SQL Server 2012 to SQL Server 2022, a end user contact me because SQL Server Management Studio (SSMS) does not work anymore when he want t o edit rows… I was surprised and do a(…)

SQL Server Tips: How to know how long goes a shrink ?

Few days ago, I perform a shrink on a data file to spend a little bit space on a disk.The SQL Server is a test server and the customer does not want to expand the disk. I run the shrink(…)

SQL Server: how do monitor SQL Dumps?

Few weeks ago, we had a big issue by a customer and a lot SQL Dumps was created in the SQL Server log folder. After playing fireman at the customer’s premises, we decided to set up a monitoring system for(…)

PosgreSQL + SQL Server = WiltonDB – Part 2 – Database Management

Few months ago I write about WiltonDB and how to install it. Now, I move one step forward with the Database Management. How to create a Database ? I test first with the T-SQL Command CREATE DATABASE script: I(…)

Investigative look into cloud-native hyper-converged infrastructure with Harvester (2)

In this second blog, we will see how we can deploy a Microsoft Windows Server 2022 virtual machine on Harvester, and play a little bit with scheduling.

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(…)

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(…)